6 ms·
tuning defaults for performance feels much more acceptable than tuning defaults for correctness
by lacunary 2mo ago
tuning defaults for performance feels much more acceptable than tuning defaults for correctness
- Rohansi 2mo agoIt's for backwards compatibility, as always. You also need to enable foreign keys or they aren't enforced. You also need to tune for performance (enable WAL, adjust cache size, etc.). The SQLite documentation is very up front about these things [1] and more. It should only be an issue if you're the type of person who never reads any documentation. [1] https://sqlite.org/quirks.html https://sqlite.org/quirks.html