How to compile SQLite for AutoIT

[seangriffin]

Hi everyone.

Sharing some knowledge on how to compile sqlite and make it work with AutoIT in case it helps anyone.

The SQLite website below explains how to compile SQLite into both an EXE and DLL.

https://www.sqlite.org/howtocompile.html

Initially I tried "gcc" with limited success.  The EXE file (sqlite3.exe) worked both standalone and also through the AutoIT _SQLite_SQLiteExe command.  But the DLL (sqlite3.dll) wouldn't be accepted by AutoIT _SQLite_Startup at all.

I then tried Visual Studio's compiler "cl".  This method is also described on the page above.  Again the EXE file (sqlite3.exe) worked both standalone and also through the AutoIT _SQLite_SQLiteExe command.  The DLL (sqlite3.dll) worked in _SQLite_Startup but _SQLite_LibVersion returned a "0" for the version.

The compilation command that finally worked (specifically for the DLL) was this one:

cl sqlite3.c -DSQLITE_API=__declspec(dllexport) -link -dll -out:sqlite3.dll

This one works against all the SQLite commands in AutoIT.

Note this assumes you want to create the 32-bit version of SQLite.

[Nine]

1 hour ago, seangriffin said:

But the DLL (sqlite3.dll) wouldn't be accepted by AutoIT _SQLite_Startup at all.

You need to have both the corresponding .dll for x86 and x64.  Got that same problem at first because I didn't have the right dll format.

[jchd]

You can also simply download the pre-built binaries for Windows available on the SQLite page.

Well, that's unless you absolutely need a custom build with your own set of options.

Edited March 1, 2019 by jchd

[Skysnake]

On 3/1/2019 at 9:10 PM, jchd said:

You can also simply download the pre-built binaries for Windows available on the SQLite page.

Yes, I can only agree with @jchd. You really do not need to compile your own binaries.  You can, of course, do so if you really, really want to, but the standard downloads work just fine.

 

[jchd]

If you're unsure about which compile option was used to produce a given SQLite DLL you can run the " PRAGMA compile_options;" statement by use of _SQLite_GetTable(). The result is an array of compile options used.