News for hackers. Stuff that matters.
Re:SQLite as a Document Database by triangleman on Friday November 27, 2020 @11:40AM (#25230150)
Yes it seems the json() function is good enough for most applications, and in fact you probably want to use it anyway as it will minify the JSON input before inserting.

Now, a dedicated JSONB datatype (and indexes!) like Postgres would be awesome, but sqlite3's "poor man's JSON" seems appropriate for many use cases.

Re:SQLite as a Document Database by formerly_proven on Friday November 27, 2020 @02:39PM (#25231920)
Unfortunately can't be "universally relied on", as it remains disabled by default and in many distributions (mostly Linux, but e.g. Python for Windows has an SQLite with few extensions, which you can fix quite easily though by replacing the sqlite3.dll).
Re:SQLite as a Document Database by samatman on Friday November 27, 2020 @04:21PM (#25232676)
SQLite has the rare combination of being superbly stable and backwards compatible (thus, little motive for systems to keep it up to date) and regularly shipping new features I want.

As a result, I like to statically link it into the binary, when possible. Life is too short to write a bunch of feature discovery and graceful degradation code.