Using SQLite3

SQLite3 is the latest version of SQLite and is one of the most common databases found in application development. This database, unlike others, is stored as a single file and does not require a server instance to be running or installed. For this reason, it is widely used due to its portability and is found in many applications for mobile devices, desktop applications, and web services. It uses a slightly modified SQL syntax, but is one of the simpler versions. Naturally, there are some limitations to this lightweight database. These limitations include a restriction to one writer to the database at a time, 140 terabytes of storage, and it is not client-server based. Because our application will not execute multiple write statements simultaneously, uses less than 140 terabytes of storage, and does not require a client-server setup for distribution, we will be using SQLite.

Using the Structured Query Language

Before developing our code, let's take a look at basic SQL statements...