#SQLITE_DLL_FNPATH$ = "C:\mysqlitepath\sqlite3.dll"
UseSQLiteDatabase(#SQLITE_DLL_FNPATH$)
I wanted to compile a light sqlite3.dll.
Below you can see many more features compiled into the precompiled binary than the Static PB lib.
For some app's I don't require any full text search. Speed of insertion/retrieval is the goal.
Here is a comparison of the PB Static lib vs the latest downloaded from SQLite's Windows x64.
Does anyone have a light make file for MS VS on Windows?
The one on the SQLite site is ~1000 lines long!
Code: Select all
STATIC PB lib:
SQLite Version = 3.27.0
SQLite Lib = 2019-02-07 17:02:52 97744701c3bd414e6c9d7182639d8c2ce7cf124c4fce625071ae65658ac6alt2
SQLite ThreadSafe = 1
SQLite Options:
COMPILER=msvc-1800
ENABLE_FTS3_PARENTHESIS
ENABLE_FTS4
ENABLE_UPDATE_DELETE_LIMIT
THREADSAFE=1
Precompiled sqlite3.dll:
SQLite Version = 3.28.0
SQLite Lib = 2019-04-16 19:49:53 884b4b7e502b4e991677b53971277adfaf0a04a284f8e483e2553d0f83156b50
SQLite ThreadSafe = 1
SQLite Options:
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