Appendix D. Installing SQLite on Windows
SQLite does not require a full installation. Simply unzip the package, place it in a folder, and add the folder to your system's Path environment variable. Follow these steps for Windows setup. For other operating systems, refer to the SQLite documentation.
- Download SQLite:
- Go to the SQLite download page: https://www.sqlite.org/download.html.
- Download the latest zipped tools package, e.g., sqlite-tools-win-x64-3460100.zip.
- Extract Files:
- Unzip the downloaded file to a folder, for instance, C:\sqlite.
- After unzipping, you should see the files, including the SQLite executable, in C:\sqlite\sqlite-tools-win-x64-3460100.
- Add SQLite to the System Path:
- Open the Start menu, go to Control Panel, and search for “edit system environment variables.”
- In System Properties, click the Environment Variables button.
- In the System variables section, select Path and click Edit.
- Add C:\sqlite\sqlite-tools-win-x64-3460100 at the end of the list, then click OK to close all dialog boxes.
- Verify Installation:
- Open a new command shell and type sqlite3. If everything is set up correctly, you’ll enter the SQLite prompt where you can start creating and managing databases.
With SQLite installed and configured, you can now create the database for the examples in Chapter 9.