appendix-d

appendix D Installing SQLite on Windows

 

SQLite doesn’t require a full installation. Simply unzip the package, place it in a folder, and add the folder to your system's Path environment variable.

D.1 Installing SQLite

Follow these steps for Windows setup (for other operating systems, refer to the SQLite documentation):

  1. Download SQLite:
    • Go to the SQLite download page at www.sqlite.org/download.html.
    • Download the latest zipped tools package, e.g., sqlite-tools-win-x64-3460100.zip.
  2. 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.
  3. 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, and then click OK to close all dialog boxes.
  4. Verify the installation by opening a new command shell and entering 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 chapters 10 and 12.