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.

$\endgroup$
  • $\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 '17 at 18:59
  • 1
    $\begingroup$ SQLite rocks. It's free and on billions of devices. $\endgroup$ – Ellen Spertus Jul 28 '17 at 1:26
  • $\begingroup$ Why won't you use sql DB for applications? @richard $\endgroup$ – T K Sourabh Jul 28 '17 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 '17 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 '17 at 10:43
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.

$\endgroup$
  • $\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 '17 at 16:24

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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