Install SQLite on Windows for Python

Installation of SQLite is rather straight forward but still it isn't like using installer.

Python first. Download WinPython 3.4.4.2/ and install it.

Add following on system PATH

C:\WinPython-32bit-3.4.4.2\python-3.4.4;

Go to SQLite download page and download sqlite-dll-win32-x86-3130000.zip. ( Or other version/arch file )

Unzip the downloaded file at c:\sqlite then put the path to the system PATH

Python comes with sqlite interface so no need further action. You should be able to type below and then find an example.db created on the working directory. Refer sqlite3

Python 3.4.4 (v3.4.4:737efcadf5a6, Dec 20 2015, 19:28:18) [MSC v.1600 32 bit (In
tel)] on win32
Type "help", "copyright", "credits" or "license" for more information.
>>> import sqlite3
>>> conn = sqlite3.connect( 'example.db' )
>>> c = conn.cursor()
>>> conn.commit()
>>> conn.close()