When should one switch from MySQL to Oracle or PostgreSQL?
12th October 2010
My answer to When should one switch from MySQL to Oracle or PostgreSQL? on Quora
When your own benchmarks prove that your application’s particular load characteristics will perform better on another database—and the difference is large enough that it’s worth the cost involved in retargeting your code. If that cost is high (and it probably will be) it may be worth paying for some expert consultants to ensure that your implementations against the different databases are properly optimised.
External benchmarks and reports for products as similar as these will rarely teach you anything useful about your own particular situation.
More recent articles
- Video + notes on upgrading a Datasette plugin for the latest 1.0 alpha, with help from uv and OpenAI Codex CLI - 6th November 2025
- Code research projects with async coding agents like Claude Code and Codex - 6th November 2025
- A new SQL-powered permissions system in Datasette 1.0a20 - 4th November 2025