News for hackers. Stuff that matters.
Re:An efficient ActivityPub Server, for small installs with ... by simonw on Thursday November 24, 2022 @12:12PM (#33733677)
SQLite has check constraints - and recent versions can have STRICT tables: https://www.sqlite.org/stricttables.html

It also has excellent JSON features - JSON maybe stored as text rather than a binary format like JSONB in PostgreSQL, but the SQLite JSON functions crunch through it at multiple GBs per second so it doesn't seem to matter.

Re:An efficient ActivityPub Server, for small installs with ... by scrollaway on Thursday November 24, 2022 @05:26PM (#33736953)
Didn't know about strict tables, very cool!