Ask HN: Strict alternatives to SQLite?

3 pointstorrance7y ago2 comments

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

2 comments · 2 top-level

jstewartmobile7y 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.

viraptor7y ago

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

j / k navigate · click thread line to collapse