Installing SQLite on Windows

SQLite is not installed on Windows by default, so unless you have used it on your machine before, you are going to need to install it to follow this short tutorial.

It's a very simple process and will only take a few minutes.

Go to the SQLite download page and download the pre-compiled binaries from the Windows section. You will need to download the sqlite-shell-win32-*.zip and sqlite-dll-win32-*.zip zip files.

Create a C:\sqlite folder and unzip the two files into it. This should give you the files sqlite3.def, sqlite3.dll and sqlite3.exe. Add C:\sqlite in your PATH environment variable and finally go to the command prompt and issue the sqlite3 command, which should display a result similar to this:.

C:\>sqlite3
SQLite version 3.7.15.2 2013-01-09 11:53:05
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite>