4 ms·
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
by lenkite 3mo ago
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.
- xigoi 3mo agoWhat are other choices for FOSS serverless relational databases? I’ve been looking everywhere and couldn’t find anything.
- lenkite 3mo agoDuckDB ? Strict by default and excellent for logs, telemetry, dashboard apps, etc.
- xigoi 3mo agoFrom 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.
- homebrewer 3mo agoFirebird 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.
- Ekaros 3mo agoIt 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.