Answers.Body: <p>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). </p>
  
  <p><strong>Resources</strong></p>
  
  <ul>
  <li>The official <a href="https://developer.android.com/training/basics/data-storage/databases.html" rel="nofollow noreferrer">guide</a> is great. Also checkout the <a href="https://developer.android.com/reference/android/database/sqlite/package-summary.html" rel="nofollow noreferrer">reference</a> of the sqlite package once you are comfortable with using SQlite.</li>
  <li><a href="http://www.vogella.com/tutorials/AndroidSQLite/article.html" rel="nofollow noreferrer">Here</a>'s a tutorial that provides step-by-step guide. </li>
  <li>Also the sqlite page have some <a href="https://www.sqlite.org/android/doc/trunk/www/index.wiki" rel="nofollow noreferrer">docs</a> for Android Bindings.</li>
  </ul>
  
  <p>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.</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-07-27T16:24:02.987Z
Answers.Text: Why don't you come by [The Classroom](https://chat.stackexchange.com/rooms/59174/the-classroom)? It's our main chat room, and you might find it interesting.
Answers.UserDisplayName: ItamarG3
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-07-27T12:52:52.230Z
Answers.LastActivityDate: 2017-07-27T12:52:52.230Z
Answers.UserDisplayName: T K Sourabh
Body: <p>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.  </p>
  
  <p>Recently, I've had some experience with Cupboard for Android (<a href="https://bitbucket.org/littlerobots/cupboard" rel="nofollow noreferrer">https://bitbucket.org/littlerobots/cupboard</a>) 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.</p>
  
  <p>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. </p>
  
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2017-07-23T18:59:10.857Z
Comments.Text: 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.
Comments.UserDisplayName: ctrl-alt-delor
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2017-07-28T01:26:17.403Z
Comments.Text: SQLite rocks. It's free and on billions of devices.
Comments.UserDisplayName: Ellen Spertus
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2017-07-28T10:28:51.983Z
Comments.Text: Why won't you use sql DB for applications? @richard
Comments.UserDisplayName: T K Sourabh
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2017-07-28T10:39:11.603Z
Comments.Text: @TKSourabh it is probably not what you want, Don't just eat oranges. See http://nosql-database.org/
Comments.UserDisplayName: ctrl-alt-delor
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2017-07-28T10:43:18.293Z
Comments.Text: 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
Comments.UserDisplayName: T K Sourabh
Tags: <java><self-learning><resource-request><databases>
Title: Ideas for introducing databases to Android development students
ThreadText: # Ideas for introducing databases to Android development students
  
  (Asked by: username_0 on 2017-07-23)
  
  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.
  
  **Tags:** java, self-learning, resource-request, databases
  
  > **Comments:**
  > **username_1**: 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.  
  > **username_2**: SQLite rocks. It's free and on billions of devices.  
  > **username_3**: Why won't you use sql DB for applications? @richard  
  > **username_1**: @username_3 it is probably not what you want, Don't just eat oranges. See http://nosql-database.org/  
  > **username_3**: 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  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_3 on 2017-07-27. Score: 2 | Accepted answer
  
  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](https://developer.android.com/training/basics/data-storage/databases.html) is great. Also checkout the [reference](https://developer.android.com/reference/android/database/sqlite/package-summary.html) of the sqlite package once you are comfortable with using SQlite.
  * [Here](http://www.vogella.com/tutorials/AndroidSQLite/article.html)'s a tutorial that provides step-by-step guide.
  * Also the sqlite page have some [docs](https://www.sqlite.org/android/doc/trunk/www/index.wiki) 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.
  
  > **Comments:**
  > **username_4**: Why don't you come by [The Classroom](https://chat.stackexchange.com/rooms/59174/the-classroom)? It's our main chat room, and you might find it interesting.  
  
  ---
  
  