Install SQLite on Windows 10

Step 1: Download SQLite

Open the SQLite download page and download the sqlite-tools zip for Windows.

Step 2: Extract the files

Extract the zip to a folder, for example your Desktop in a folder named SQLite. It contains three tools:

• sqlite3.exe is the command-line shell for running SQL.
• sqldiff.exe compares two SQLite databases.
• sqlite3_analyzer.exe shows how space is used inside a database.

  

Step 3: Run SQLite from Command Prompt

1. Open Command Prompt.
2. Go to the folder with the files:

cd Desktop\SQLite

1. Start the shell:

sqlite3

Use the shell

• Open or create a database: .open database_name
• Create a table: CREATE TABLE table_name (column1, column2);
• Insert data: INSERT INTO table_name (column1, column2) VALUES (value1, value2);
• Read data: SELECT * FROM table_name;

To see all shell commands:

.help

To leave:

.quit

Main features of SQLite

• Serverless. No database server is needed.
• No setup. It works as soon as it is extracted.
• One file. A database is a single file.
• Reliable. Transactions follow ACID rules.
• Small. It uses very little disk and memory.

Quick recap

• Download the sqlite-tools zip and extract it.
• Open Command Prompt in that folder and run sqlite3.
• Use .help for commands and .quit to exit.