Hacker News new | ask | show | jobs
by ivanjermakov 17 days ago
Wow, SQLite not believing in fail-fast systems is disappointng. Never knew SQLite was JS of SQL!
1 comments

That doesn't do justice to some of the arguments that SQLite authors are making.

In Postgres, if you insert a real number into an int column, the data gets rounded and stored as int. In SQLite, the data is inserted as real.

Neither approach is fail-fast.