On: SQLite the only database you will ever need in mos...

[lerax]

saying the obvious for the new comers, sometimes is really necessary in that generation of master of overengineers and not only that, but with pretty useless and unecessary abstractions

[hummus_bae → lerax]

What the author says is true, but the implementation in the linked sqlite isn't.

The cache is implementation defined.

The locking is implementation defined.

The index does not work on foreign keys.

The planner isn't thread safe.

The only reasons for 90% of use cases to use sqlite are that it can be embedded and it has an sql parser.

In a major application written by a company with an actual software engineering department, you would use Postgres or MySQL.