4 ms·
> MySQL What‘s the point of it, by the way? Why would one start a new project based on MySQL instead of postgres today?
by Traubenfuchs 3y ago
> MySQL
What‘s the point of it, by the way? Why would one start a new project based on MySQL instead of postgres today?
- giovannibonetti 3y agoMySQL has an actively maintained LSM-tree based storage engine like MyRocks, while Postgres doesn't have production-ready options in that regard.
- dboreham 3y agoWhy is LSM useful for a RDB workload?
- AtlasBarfed 3y agoLog Structured Merge Trees are superior in write volume and scaling B+ trees higher. LSMs are part of the sauce of Cassandra and (I believe) DynamoDB for horizontal scaling. RocksDB is a single node very efficient (better than Cassandra's in the 2.x/3.x releases, not sure about now) single node LSM implementation.
- WJW 3y agoBecause you know it better? Same reason as for most technical decisions tbh. Besides that, there are still some points where the MySQL and/or the tooling around it simply performs better than Postgres. Anything to do with replication and big table migrations comes to mind.
- kreetx 3y agoNot an expert, but briefly looking into this, MySQL is 1. easier to configure and manage 2. faster for read-heavy workloads 3. has pluggable storage engine (though, if you care about this, then 1. likely doesn't matter anymore)
- Icathian 3y agoJust as a note, Postgres also has pluggable storage engine, using their tableam API.
- woooooo 3y agoIt's much less emphasized compared to MySQL, I didn't even know about it until your comment, and search results are sparse. MySQL has had multiple viable storage engines for most of its existence. MyISAM, InnoDB and more recently MyRocks.
- TurningCanadian 3y agoYou might be able to argue that Postgres' foreign data is a different form of pluggable storage engine. E.g. you can even use a CSV file as a backing store for a table with file_fdw. https://www.postgresql.org/docs/current/ddl-foreign-data.html https://www.postgresql.org/docs/current/ddl-foreign-data.htm... https://dbaclass.com/article/how-to-access-csv-files-on-file-system-using-file_fdw_in_postgres/ https://dbaclass.com/article/how-to-access-csv-files-on-file...
- kreetx 3y agoSomeone should do an experience report on adding the same storage system to both databases. What you say looks powerful but Facebook added their MyRocks to MySQL.
- steve_rambo 3y agoMulti-master replication out of the box. Very useful, very occasionally.
- rob 3y agoBecause I make money with WordPress.
- jillesvangurp 3y agoI personally also prefer postgres but I have used mysql in the past as well on and off over the last 20+ years or so. Managed postgres was at some point slightly more expensive in Amazon for some reason. So that's a good reason. If all you need is some simple database, either is fine.
- netol 3y agoBecause it may be good enough. In my case, because I already maintain an instance of MariaDB in production, and I may prefer to share this that maintain another thing
- Fartmancer 3y agoI would choose MySQL because I'm more familiar with it and it's good enough for what I need. PostgreSQL might be able to give me better benchmarks but it won't have any meaningful benefit for me the developer or for the user.
- graemep 3y agoBenchmarks are not the reason people choose PostgreSQL over MySQL. I have never even bothered to benchmark the two for any project that could have used either. Features, better ACID (at least historically) and maybe better standards compliance. The big one for me is being able to run schema changes in transactions, which makes it easy to roll back a failed migration.
- berniedurfee 3y agoI wouldn’t, only because the big O is behind MySQL. Otherwise, why not? It’s basically a Chevy vs Ford decision.
- ksec 3y agoHad Oracle stopped investing into MySQL, may be people would have moved on. But they didn't. Just like when people were worried about JAVA, instead we have 15 years of continuous improvement. And that is the same with MySQL. There are lots of features MySQL has as defaults, while postgres simply accept it is not something they want to deal with but leave it to extensions.