5 ms·
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 rou
by fauigerzigerk 2mo ago
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.