3
$\begingroup$

I teach an Android development course to students who have had two full years of Java experience - including a year of data structures. In the past, my students have used services such as Firebase, Parse, and Couchbase to store their data.

Recently, I've had some experience with Cupboard for Android (https://bitbucket.org/littlerobots/cupboard) which maps Java classes to database tables and maps Java class member variables to the table columns. Cupboard allowed me to create, modify, delete, and query my SQLite database using instantiated objects instead of writing SQL every time.

Now I have a new interest in learning SQLite and in turn teaching it to my students. I am looking for recommendations of resources for an intro unit on SQLite.

Improve this question
$\endgroup$
5
  • $\begingroup$ I could not recommend using an sql db, in an application. SQL is great for ad-hoc queries, but not for creating applications. There are much better choices, such as the ones you mentioned. Having said that, I would definitely read up on 1st, 2nd, 3rd normal form. It is essential, and also transferable to non-relational DBs. $\endgroup$
    – ctrl-alt-delor
    Jul 23, 2017 at 18:59
  • 1
    $\begingroup$ SQLite rocks. It's free and on billions of devices. $\endgroup$
    – Ellen Spertus
    Jul 28, 2017 at 1:26
  • $\begingroup$ Why won't you use sql DB for applications? @richard $\endgroup$
    – T K Sourabh
    Jul 28, 2017 at 10:28
  • $\begingroup$ @TKSourabh it is probably not what you want, Don't just eat oranges. See nosql-database.org $\endgroup$
    – ctrl-alt-delor
    Jul 28, 2017 at 10:39
  • 1
    $\begingroup$ I know there are two sides to everything. But I need a reason to why not? The webpage you shared doesn't seem to have anything other than listing No-SQL DBs $\endgroup$
    – T K Sourabh
    Jul 28, 2017 at 10:43

1 Answer 1

Reset to default
2
$\begingroup$

SQlite is small and as the name suggest "lite" is great for storing data for mobile applications. Apart from that It can easily be used for other small scale web applications without hiccups (100k or more rows).

Resources

  • The official guide is great. Also checkout the reference of the sqlite package once you are comfortable with using SQlite.
  • Here's a tutorial that provides step-by-step guide.
  • Also the sqlite page have some docs for Android Bindings.

That said, SQlite is one of the most tested(tests are larger than code itself) and have a brilliant code base which makes it very suitable for mobile applications.

Improve this answer
$\endgroup$
1
  • $\begingroup$ Why don't you come by The Classroom? It's our main chat room, and you might find it interesting. $\endgroup$
    – ItamarG3
    Jul 27, 2017 at 16:24

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.