Comment by wenc
4 years ago
SQLite is a file format with a SQL engine which makes it a great embedded database.
It is not an RDBMS in the true sense so in my opinion it is correctly rated.
I tried using SQLite to solve problems which normally would require an RDBMS and ran into so many issues like the lack of enforced static types, built in date or decimal types (and fast aggregations on dates), concurrent writes, etc. It’s only when you’ve gone through this process that you’ll realize that SQLite it not the database you think it is — and SQLite itself is up front about that: https://www.sqlite.org/aff_short.html
Enforced static types are now available, as of SQLite 3.37.0 which came out last week: https://www.sqlite.org/stricttables.html