Ok, "making" some headway. :) ; COMPILE SOURCE AS DLL: ; Use MS Visual Studio Command Prompt with the appropriate target: x86 or x64. ; Ex. shortcut: x64 Native Tools Command Prompt for VS 2017 ; %comspec% /k "C:\Program Files (x86)\Microsoft Visual Studio\2017\Community\VC\Auxiliary\Build\vcvars64.bat ; ; Then create and execute a bat file with the following: (enable/disable desired options) ; cl sqlite3.c -DSQLITE_THREADSAFE -DSQLITE_API=__declspec(dllexport) -link -dll -out:sqlite3.dll
SQLite Version = 3.28.0 SQLite Lib = 2019-04-16 19:49:53 884b4b7e502b4e991677b53971277adfaf0a04a284f8e483e2553d0f83156b50 SQLite ThreadSafe = 1 SQLite Options: COMPILER=msvc-1915 THREADSAFE=1 This approach is super fast and light, but it does not populate the version fields within the dll? I need that for traceability. So, needs more work or try compiling with nmake cmd and the edited makefile.msc(which is huge). Maybe someone has a clue? Thanks for SQLite! On Fri, Apr 19, 2019 at 7:26 PM <[email protected]> wrote: > I was afraid you'd say that. > I wanted to edit the Windows x64 make file to reduce a lot of the options. > > SQLite Version = 3.28.0 > SQLite Lib = 2019-04-16 19:49:53 > 884b4b7e502b4e991677b53971277adfaf0a04a284f8e483e2553d0f83156b50 > > Anyway, I iterated this sql query: > "SELECT sqlite_compileoption_get(0-n until empty return); " > SQLite Options Returned: > COMPILER=msvc-1500 > ENABLE_COLUMN_METADATA > ENABLE_DBSTAT_VTAB > ENABLE_FTS3 > ENABLE_FTS4 > ENABLE_FTS5 > ENABLE_GEOPOLY > ENABLE_JSON1 > ENABLE_RTREE > ENABLE_STMTVTAB > MAX_TRIGGER_DEPTH=100 > TEMP_STORE=1 > THREADSAFE=1 > > Any chance to publish the make file used for the releases? > I found this thousand liner in the amalgamated sqlite-autoconf-3280000 > folder. > ~\sqlite-autoconf-3280000\Makefile.msc > But it makes no mention of ENABLE_FTS5? > Most of the other options are in there. > > Any examples to drop an option? > Ex. OPT_FEATURE_FLAGS = $(OPT_FEATURE_FLAGS) -DSQLITE_ENABLE_RTREE=0 <--0|1 > > Also, I read the mail list that some additional flag is required to export > the functions in the dll? > > Thanks for SQLite! > > On Fri, Apr 19, 2019 at 9:36 AM Warren Young <[email protected]> wrote: > >> On Apr 18, 2019, at 2:37 PM, [email protected] wrote: >> > >> > Searched a while...what was the makefile or the options used to create >> the >> > latest precompiled sqlite3.dll? >> > https://www.sqlite.org/download.html >> > --> sqlite-dll-win64-x64-3280000.zip >> >> Execute “PRAGMA compile_options;” and it’ll tell you. >> _______________________________________________ >> sqlite-users mailing list >> [email protected] >> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users >> > _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
