Hacker News Reader

I agree with you. There are 2 dozen foot-guns to be kept in mind. And discovered a new footgun regarding multi-byte strings and NUL handling today on HN. SQLite became popular because it was the only free and open-source choice 2 decades ago. Now there are other type-safe and robust choices.

View on HN

It is very simple. Which means fast to setup in dev environment for local testing. Which makes first version very easy. And then people just keep fixing that one.

Still I quite a lot of question the use on servers if you have decided that I need a database.

Not that there isn't more valid use cases like local storage or self-contained information transfer for specific use.

What are other choices for FOSS serverless relational databases? I’ve been looking everywhere and couldn’t find anything.

DuckDB ? Strict by default and excellent for logs, telemetry, dashboard apps, etc.

From what I can tell, DuckDB is more focused on huge-scale data analysis than simple data persistence, so I’m not sure if it fits my use cases. Otherwise, it looks good.

Firebird can be embedded, although neither the database itself, nor the embedded mode are as popular as they once were.

It's a fully featured database though, with everything you expect from one, including actually working ALTER TABLEs.

Reply on news.ycombinator.com