This is a brief description of the method used to build the library archives available in the modified distributions of SQLite provided at [[SQLite_Library]].

Files needed from [[http://www.sqlite.org/download.html]]:

* sqlite-amalgamatian-#######.zip

* sqlite-dll-win32-x86-#######.zip (only if building shared library stub)

Both can be unzipped to the same folder as their files don't conflict.

MinGW's g++ package contains all the programs needed to build the library archives.

== Linkable SQLite library (sqlite-lib-win32-x86) ==

'''Files needed:''' sqlite3.c, sqlite3.h, sqlite3ext.h

'''Outputs:''' libsqlite3.a, sqlite3.h, sqlite3ext.h

Run the following commands in the directory containing the necessary files:

<pre>> gcc -O2 -c sqlite3.c -o sqlite3.o

> ar r libsqlite3.a sqlite3.o</pre>

== Linkable SQLite shared library (sqlite-lib-dll-win32-x86) ==

'''Files needed:''' sqlite3.dll, sqlite3.def, sqlite3.h, sqlite3ext.h

'''Outputs:''' libsqlite3.a, sqlite3.dll, sqlite3.h, sqlite3ext.h

Modify sqlite3.def by placing the following line of text at the beginning of the file:

<pre>@@LIBRARY sqlite3.dll@@

EXPORTS

sqlite3_aggregate_context

sqlite3_aggregate_count

...</pre>

Then run the following command:

<pre>> dlltool -d sqlite3.def -l libsqlite3.a</pre>