4 ms·
MySQL 8 is not that far behind in feature parity. And is ahead when it comes to scalability. So I don't see postgres as necessarily standing alone.
by jjeaff 5y ago
MySQL 8 is not that far behind in feature parity. And is ahead when it comes to scalability. So I don't see postgres as necessarily standing alone.
- paozac 5y agoMySQL's lack of DDL transactions is a serious shortcoming.
- ezekiel68 5y agoYou claim that MySQL 8 is ahead when it comes to scalability. What are the bases of this claim? When I see comparisons or entire systems that rely on a database (that is, not micro-benchmarks) such as the TechEmpower web framework benchmarks [0] , I notice that the 'Pg' results cluster near the top, with the "My" results showing up further down the rankings. I understand this isn't version 14 of the former versus version 8 of the latter. But it makes me wonder what the basis of your claims is. [0] https://www.techempower.com/benchmarks/ https://www.techempower.com/benchmarks/
- isbvhodnvemrwvn 5y agoAren't those run on a single node DB server? And the queries don't really seem realistic at all, e.g. single query test fetches 1 out of 10 000 rows, with no joins at all. Fortunes fetches 1 out of 10 rows. This seems extremely trivial.
- merb 5y agowell if you need more than one server, mysql has vitess, which is huge. postgres has citus, but that is way more complex to setup than vitess. I still would never use mysql, just because of vitess.
- deleted 5y ago[deleted]
- the_duke 5y agoTechempower is not a database benchmark. The tests that involve a DB exist to include a DB client in the request flow, not to put any serious load on the database.
- purerandomness 5y agoNo DDL transactions, no materialized views, the list is endless. There's almost no reason to pick MySQL for a new project.
- tfigment 5y agoMySQL and mariadb have first class temporal tables. Pg has compile requirement and so cannot use in AWS RDS.
- dragonwriter 5y ago> MySQL and mariadb have first class temporal tables. Pg has compile requirement and so cannot use in AWS RDS. There’s a pl/pgsql reimplementation of temporal tables specifically for that use case.
- phonon 5y agohttps://news.ycombinator.com/item?id=26768220 https://news.ycombinator.com/item?id=26768220
- lowercased 5y agoI was aware maria had temporary tables, but not mysql proper. Any links you can point me to? Every search is coming up with 'temporary' table info, not temporal.
- lowercased 5y agomysql8 has gis/spatial stuff built in now. may not quite be on par with postgis, but... i also don't have to futz with "doesn't come baked in". Dealt with someone who wrote a whole bunch of lat/lon/spatial stuff in client code because we're on postgres but ... he couldn't get postgis installed (then even if he could, figuring out how to convince the ops people to add a new 'thing' in production would have been a delay). having stuff baked in is often a win.
- aseipp 5y agoMySQL has transactions for DDL changes since 8.0.
- ksec 5y agoAre there any Roadmap for MySQL 9 ?