Ask HN: Strict alternatives to SQLite?

3 points by torrance 8y ago ↗ HN

I love using SQLite for small (and even large) amounts of data and giving me a fast and efficient SQL frontend to query it all. But I don’t love SQLite’s decision to forgo type safety, foreign key constraints and all that. Are there alternatives that give me the simplicity of SQLite with the data safety of traditional databases?

2 comments

[ 3.6 ms ] story [ 13.8 ms ] thread

viraptor 8y ago ↗

There's firebird which can be used as embedded sql db. It supports foreign keys. No idea about type safety though.

jstewartmobile 8y ago ↗

Referential integrity is nice, though not losing data is always job #1. In that respect, SQLite is pretty hard to beat. Seems like half the linux filesystem bugs I read about have a sidenote of "SQLite unaffected".

Richard Hipp did some very solid engineering on it.