SQLite Forum

extension-functions.c - pre-compiled Windows Binary
For those that are trying to follow these directions to build their own copy of extension-functions.dll on a Windows machine, a few things to keep in mind:

You'll need a copy of the sqlite3 sources available.  Generally, decompressing the sqlite3 amalgamation and copying the files from the zip file to a working directory alongside extension-functions.c is enough.

Also, speaking of working directories, you'll want to make a working folder to perform your work in.  The example above suggests working in the root directory, but that will not work on most modern Windows installations, so make a directory to build in.

The command itself should be:

`gcc -shared -o extension-functions.dll extension-functions.c`

Note the correct filename extension-functions.c.  This is the file you want to build, the extension-functions.dll name is a free form output filename of your choosing.  You will use .load on this filename later in the sqlite shell.

And, the original post in this thread mentioned a request for a 32-bit DLL.  That's likely the version you want as well, since the version of sqlite3.exe that's available on the SQLite website itself is 32-bit, so I think this is the command you'll want to run:

`gcc -m32 -shared -o extension-functions.dll extension-functions.c`

(I don't have a Windows machine to test this on to verify it works)

Good luck.