fiatjaf on Nostr: , for example, uses a Postgres database and that's so awful because it's meant to be ...

https://noflux.nostr.technology/, for example, uses a Postgres database and that's so awful because it's meant to be used by a single person in a desktop home machine. I even tried to switch it to SQLite because it would be a strict improvement (https://github.com/fiatjaf/narr uses it luckily) but couldn't (yet) because SQL is so bad it's not even standard among all databases (and everybody knows that, but it's impossible to do anything about it).

I also tried to use https://pglite.dev/, but it didn't have easy to use Go bindings apparently.

quoting
nevent1q…t5re

Or is it because SQL is associated with servers running externally to the programs that use the data and as such they constitute a weird unnecessary slow abstraction that isn't needed for 99% of the programs we write today that could pretty much use an embedded simpler database or sometimes just some files?