Use newest sqlite3.dll with SQLiteStudio?

[GeneGeneGitHub]

Can I just drop the newest sqlite3.dll (v 3.36.0) into the root SQLiteStudio directory (replacing the current one) and have it work?

[pawelsalawa]

Yes, you can.

[GeneGeneGitHub]

Thanks. The sqlite3.dll in the SStudio root directory is just 977KB, while the latest one from SQLite is 2078KB. Why such a big difference?

[pawelsalawa]

I don't know. Maybe they include some big extensions compiled in...
This is how SQLite3 is compiled for SQLiteStudio:

                gcc.exe sqlite3.c -Os -fpic -DWIN64 -m64 -I. -shared -o sqlite3.dll \
                    -DSQLITE_ENABLE_UPDATE_DELETE_LIMIT \
                    -DSQLITE_ENABLE_DBSTAT_VTAB \
                    -DSQLITE_ENABLE_BYTECODE_VTAB \
                    -DSQLITE_ENABLE_COLUMN_METADATA \
                    -DSQLITE_ENABLE_EXPLAIN_COMMENTS \
                    -DSQLITE_ENABLE_FTS3 \
                    -DSQLITE_ENABLE_FTS4 \
                    -DSQLITE_ENABLE_FTS5 \
                    -DSQLITE_ENABLE_GEOPOLY \
                    -DSQLITE_ENABLE_JSON1 \
                    -DSQLITE_ENABLE_RTREE \
                    -DSQLITE_ENABLE_MATH_FUNCTIONS

[GeneGeneGitHub]

Thanks for your responses, pawel. And thanks for making SQLite Studio available for free. I'll get around to donating some day - I use the app fairly often, but not for work stuff.