Small. Fast. Reliable.
Choose any three.

This information is obsolete. You are looking at the CVSTrac source management system display for SQLite that was replaced by Fossil on 2009-08-11. The information shown here has not been updated since that cut-over. These pages are retained for historical reference only.

These instructions for building SQLite with MinGW on windows. More detailed explanation is found at http://techtonik.blogspot.com/2005/12/how-to-compile-sqlite-for-windows.html

Compiled .exe is standalone and does not require the .dll.

cd sqlite
mkdir bld; cd bld
../configure --disable-tcl
make target_source
cd tsrc
mv tclsqlite.c tclsqlite.c.unused
gcc -O2 -DNDEBUG=1 -DTHREADSAFE=1 -c *.c
gcc -s -o sqlite3 *.o
rm shell.o
gcc -shared -s -o sqlite3.dll *.o *.def -Wl,--out-implib,libsqlite.dll.a
mkdir ../release
cp sqlite3.dll sqlite3.exe libsqlite3.dll.a sqlite3.h ../release
cd ../release