TryGhost
The bundled version of SQLite is not 3.45.0
Issue Summary
It is 3.44.2, which means it doesn't support JSONB.
Steps to Reproduce
select sqlite_version();
Version
5.1.7
Node.js Version
21.6.2
How did you install the library?
npm install sqlite3 on the latest macos on an m3 mac
3.45.0 is only on the master branch and unreleased. I managed to upgrade it to 3.50.0 (and 3.48.0 in macOS) in my fork. Also, made things a bit more modern by targeting Node >= 20, etc, so not sure if upstream might like them here. Got into some weird build errors with 3.50.0 on macOS alone, so have a hack to downgrade during build.
its been a few months now, official sqlite release is at 3.50, while the master branch here has already been updated to 3.45
is it possible to get a release including this version? jsonb support would really be great if there are some blocking issues and no contributors are available to solve them, I can volunteer to assist if there is someone to sync with on this.
honestly with the lack of commits and releases it is beginning to seem like this project has been abandoned
