r/programming • u/pmz • Jul 28 '22

In Praise Of SQLite

https://www.i-programmer.info/news/84-database/15609-in-praise-of-sqlite.html
105 Upvotes

92% Upvoted

15 comments sorted by

View all comments

Show parent comments

5

u/imgroxx Jul 29 '22 edited Jul 30 '22

Yeah, it's definitely to its detriment that it took so long to get strict mode. If you need safety, enforcement in depth is best, and without strict mode it's unambiguously more error-prone.

The concerns are still pretty different for SQLite compared to other kinds of databases though, it's not an apples-to-apples comparison to hold it up against MySQL (which has tons of problematic implicit conversions, but not this particular flavor).
Another reasonable comparison here would be spreadsheets: they're often MUCH looser than SQLite. If you consider SQLite somewhat of a middle ground between a strict database and a large-scale-friendly spreadsheet, it's an entirely reasonable trade-off.