Re:Django SQLite Production Config
by kmac_ on Saturday June 15, 2024 @08:38AM
(#40689417)
There is no one-size-fits-all solution in the SQL world, and using SQLite in such a scenario is not a good idea. SQLite is an embedded database for embedded use. Even PostgreSQL is not universal, as many people assume. For use cases like analytics, there are many better-suited database engines.
[ Parent
| on HN ]
Sure, but there are one-size-fits-95% solutions, and they're better than one-size-fits-90% solutions.
Absolutely agree. As most projects are small or medium in size, PostgreSQL is a good default choice. Problems arise when the problem does not fit the solution or tool. For example, using SQLite for high-volume transactions and then complaining that it doesn't work.