← Back to context

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