SQLite 3.45 Released With JSON Functions Adapted To Use JSONB

[phoronix]

Phoronix: 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...

https://www.phoronix.com/news/SQLite-3.45-Released

[intelfx]

By storing SQLite's internal binary representation of JSON directly in the database <...>

Yeeeaaah, no way this could ever go wrong. Unless they use a proper serialization protocol that actually validates the data read from disk rather than happily casting it to a struct pointer?

[NobodyXu]

Yeeeaaah, no way this could ever go wrong. Unless they use a proper serialization protocol that actually validates the data read from disk rather than happily casting it to a struct pointer?

It does contain a proper serialisation protocol https://sqlite.org/draft/jsonb.html

[intelfx]

It does contain a proper serialisation protocol https://sqlite.org/draft/jsonb.html

Oh, okay. Good for them then :-)

[curfew]

Yeeeaaah, no way this could ever go wrong. Unless they use a proper serialization protocol that actually validates the data read from disk rather than happily casting it to a struct pointer?

No fucking way nobody never implemented binary JSON format in an RDBMS before! PostgreSQL and MySQL have had similar support for nearly a decade now.

[S.Pam]

I really wish sqlite would support transparent page or row compression.

[intelfx]

No fucking way nobody never implemented binary JSON format in an RDBMS before! PostgreSQL and MySQL have had similar support for nearly a decade now.

Hold your horses, I never said that any binary JSON support is something that could go wrong.

It's the specific words of "storing <...>internal binary representation <...> directly in the database" that triggered me. If you take them out of context, it sounds like a pretty dangerous thing to do.