Following is the first of a multi-part series on SQLite. SQLite is a small, self-contained database engine. It is cross-platform and with a single file representing your database and associated objects. Let’s start with installing.
- Create a directory (in this example, we are using a Windows machine) called c:\SQLite
- Download the tools.zip file from https://www.sqlite.org/download.html
- Extract into the SQLite folder
- Verify the installation by navigating to c:\SQLite and typing sqlite3
- You can explore the help by typing .help
- To exit SQLite, type .quit
Next we will explore the command line interface and import a sample database.