Ask HN: Strict alternatives to SQLite?

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?