<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>

CC BY-SA 3.0
2017-07-27T16:24:02.987Z
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.
ItamarG3
CC BY-SA 3.0
2017-07-27T12:52:52.230Z
2017-07-27T12:52:52.230Z
T K Sourabh
<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>

CC BY-SA 3.0
2017-07-23T18:59:10.857Z
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.
ctrl-alt-delor
CC BY-SA 3.0
2017-07-28T01:26:17.403Z
SQLite rocks. It's free and on billions of devices.
Ellen Spertus
CC BY-SA 3.0
2017-07-28T10:28:51.983Z
Why won't you use sql DB for applications? @richard
T K Sourabh
CC BY-SA 3.0
2017-07-28T10:39:11.603Z
@TKSourabh it is probably not what you want, Don't just eat oranges. See http://nosql-database.org/
ctrl-alt-delor
CC BY-SA 3.0
2017-07-28T10:43:18.293Z
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
T K Sourabh
<java><self-learning><resource-request><databases>
Ideas for introducing databases to Android development students
# 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**: @TKSourabh 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.  

---

