Creating a social networking app using SQLite

This recipe will discuss how you can build a complex relational database app using SQLite. In a real-world scenario, the database usually stays in the backend, where it's more feasible to process a large amount of data for multiple users.

However, there are some cases where the app just needs to work on a limited set of data in the local client device. While it's possible to leverage Local Storage, you will run into the 5 MB limitation of Local Storage very quickly. In addition, you can take advantage of the relational database features, such as table joins, because such a query can have a very poor performance using Local Storage.

It's easy to get started by using a very common example in most social networking apps, where there are definitions of users and memberships. You will go through a process in this recipe for the creation of an app to allow users to subscribe to various groups. This is very similar to how Facebook or Twitter...