4 ms·
It can be surprising difficult to upgrade to a more recent SQLite release, depending on your operating system and which language bindings you are using. I stil
by simonw 4y ago
It can be surprising difficult to upgrade to a more recent SQLite release, depending on your operating system and which language bindings you are using.
I still haven't found a good, reliable method of upgrading the SQLite version that is made available to Python's "sqlite3" standard library module for example, that works reliably across Linux and macOS. https://til.simonwillison.net/sqlite/ld-preload https://til.simonwillison.net/sqlite/ld-preload is one mechanism I've explored, but it's not ideal.
As such, extensions which package stuff that you could get in SQLite core if you had a good way of recompiling that with extra options are really useful.