View Source

Installation
- Go to SQLite3 download page
  1. Go down to the “Precompiled Binaries For Windows” section.
  2. Download “sqlite-shell” and “sqlite-dll” archive files.
    - sqlite-dll-win64-x64-3160200.zip
  3. Download the sqlite tools .zip
    - sqlite-tools-win32-x86-3160200.zip
  4. Unpack everything in C:\sqlite folder.
  5. Add that folder to your PATH.
Creating the empty .db file:
1. Hit the Windows key, type 'cmd', then right-click the 'Command Prompt' result and select 'Run as Administrator'.
2. Navigate to the folder where you want the db to be.
3. Type 'sqlite3 name_of_the_db.db' and hit 'Enter'.

Simple example of a schema file:

CREATE TABLE salespeople (
  id INTEGER PRIMARY KEY,
  first_name TEXT NOT NULL,
  last_name TEXT NOT NULL,
  commission_rate REAL NOT NULL
);