Page Comparison

...

• SQLiteBrowser
  • I've used this and it works fine.

SQLite

• Installation
  • Go to [SQLite3 download page](http://www.sqlite.org/download.html)
    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:

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

...