@John @stfn @nf3xn @rrwo @szescstopni @Threadbane we often forget that there's actually a very lightweight way of running SQL that doesn't require any server, it can also fit into memory, and even into a WASM frontend - SQLite :)
It may not come with all the bells and whistles of a full-blown RDBMS (no stored procedures and triggers AFAIK), but it definitely solves the use cases of (I'd say) 90-95% of the applications out there.
I've actually got the db of my Matrix server (~20GB) fully running on SQLite, and I've been impressed by its versatility and performance.
@blacklight @John @stfn @nf3xn @rrwo @szescstopni @Threadbane sqlite has triggers.