News for hackers. Stuff that matters.
Re:SQLite Release 3.42.0 by SQLite on Tuesday May 16, 2023 @11:39AM (#35963351)
The important point to keep in mind is that SQLite will read JSON5, but it never writes it. The JSON that SQLite generates is canonical JSON that is fully compliant with the original JSON spec.

It turns out that there is a lot of "JSON" data in the wild that is not pure and proper JSON, but instead includes some of the extensions of JSON5. The point of this enhancement is to enable SQLite to read and process most of that wild JSON.

This feature was requested by multiple important users of SQLite.

Re:SQLite Release 3.42.0 by alberth on Tuesday May 16, 2023 @11:52AM (#35963557)
Dr. Hipp

Off topic: would you mind sharing any info on potential timing of begin-concurrent-pnu-wal2 branch being merged into main (or consideration of forking sqlite to have a "client/server" version)?

https://www.sqlite.org/src/timeline?r=begin-concurrent-pnu-w...

(Love what you have created. Thank you so much for all the years of amazing work)

Re:SQLite Release 3.42.0 by SQLite on Tuesday May 16, 2023 @12:24PM (#35964087)
That branch has been renamed "bedrock" (after its principal user) and is up-to-date.
Re:SQLite Release 3.42.0 by alberth on Tuesday May 16, 2023 @03:41PM (#35966727)
Hi Dr Hipp

Curious, would you recommend using this bedrock branch?

Why / why not?

Re:SQLite Release 3.42.0 by kwiromeo on Tuesday May 16, 2023 @06:45PM (#35968777)
Expensify is the main user from what I could gather. They've been using it for awhile now.

https://bedrockdb.com/

Re:SQLite Release 3.42.0 by sidewndr46 on Tuesday May 16, 2023 @11:58AM (#35963661)
Isn't this just the YAML debacle all over again? Where virtually any sequence of text is "valid" (albeit meaningless) YAML?
Re:SQLite Release 3.42.0 by masklinn on Tuesday May 16, 2023 @12:03PM (#35963763)
While I don't care for JSON5 it's hardly "virtually any sequence of text", it rather hews closer to JavaScript content, rather than the very limited subset (ish) that is JSON.
Re:SQLite Release 3.42.0 by conradev on Tuesday May 16, 2023 @12:08PM (#35963851)
Virtually any sequence is not the same as adopting a specification five years after it’s been published and adopted by industry: https://spec.json5.org/

I appreciate that SQLite can’t write the format, because those changes are human afordances