3 ms·
Not quite the in-depth article I expected sadly. Very disappointed. As someone who has used all three extensively, I would say steer clear of SQLite for large-
by DigitalSea 13y ago
Not quite the in-depth article I expected sadly. Very disappointed.
As someone who has used all three extensively, I would say steer clear of SQLite for large-scale applications or a web app in production. I tend to use SQLite for prototyping because it means you don't have to worry about setting up a database, I wouldn't use it for much more than that.
I used to use MySQL quite a bit, and since version 5.5 MySQL has actually been really good in terms of performance and feature-set. Both MySQL and PostgreSQL have their advantages, and as long as you know when to scale and shard your database it's all relative in the end regardless of which of the two you choose, both can be tuned to do the same things.