Re:An efficient ActivityPub Server, for small installs with ...
by scrollaway on Thursday November 24, 2022 @11:34AM
(#33733224)
SQLite is magical and incredibly lean, but it is not leaner than Postgres if you need real database features. You end up reimplementing a lot of features in code that belong in the db.
[ Parent
| on HN ]
Re:An efficient ActivityPub Server, for small installs with ...
by simonw on Thursday November 24, 2022 @11:43AM
(#33733320)
What kind of features are you talking about here?
This doesn't match my experience from the last few years. SQLite in WAL mode is extremely capable.
The only thing I really miss from PostgreSQL is that PostgreSQL has more built-in functions for things like date handling - but SQLite custom functions are very easy to register when you need them.
Re:An efficient ActivityPub Server, for small installs with ...
by scrollaway on Thursday November 24, 2022 @12:03PM
(#33733565)
Constraints and validation for example. Efficient json store. Etc
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!