SQLite 3.45 Released With JSON Functions Adapted To Use JSONB
SQLite 3.45 was released today with the SQLITE_DIRECT_OVERFLOW_READ optimization being enabled by default that can help for apps relying on SQLite and doing a lot of reads of large BLOBs or strings deliver better read performance. There are also query planner improvements while most interesting with SQLite 3.45 is all JSON functions being rewritten to use the new JSONB format...