13 ms·
While a lot of people people have disagreed with this guy in the past, I find it very hard to disagree with him in most of his posts. My exposure, as far as SQ
by zamalek 13y ago
While a lot of people people have disagreed with this guy in the past, I find it very hard to disagree with him in most of his posts.
My exposure, as far as SQL goes, has been MsSQL, PostgreSQL and MySQL. With absolutely loads of MsSQL, and pretty hairy data structures at that (they have an aversion to the polyglot approach where I work) - SQL is one of the most enjoyable things that you can do once you get past the elementary "SELECT WHERE" (and stop using graphical development tools).
I have been saying what Markus said for a long time, MySQL is why RDBMS has a bad name and why the "not using SQL" movement exists. I really hope the MariaDB team spend their time where it is needed most (a join engine that doesn't suck), if they haven't already.
I mean, at the end of the day you have MySQL that can't even do hash joins, and then you have PostgreSQL with GEQO: http://www.postgresql.org/docs/9.0/static/geqo-pg-intro.html http://www.postgresql.org/docs/9.0/static/geqo-pg-intro.html
- xd 13y agoYou should know that the fork of MySQL, MariaDB, addressed hash joins well over a year ago: https://mariadb.com/kb/en/block-based-join-algorithms/#block-hash-join https://mariadb.com/kb/en/block-based-join-algorithms/#block...
- zamalek 13y agoAwesome! It really sounds like they are making a decent effort. I did some more searches and they even support things like join elimination[1]. [1]: https://mariadb.com/kb/en/what-is-table-elimination/ https://mariadb.com/kb/en/what-is-table-elimination/
- xd 13y agoThey're doing all kinds of awesome and the greater community is starting to see this, which is evident with Archlinux* for example whom has dropped MySQL in favour of MariaDB. Slowly but surely MySQL will fall to the waysides, which I can't help but think is what Oracle wants. * https://www.archlinux.org/news/mariadb-replaces-mysql-in-repositories/ https://www.archlinux.org/news/mariadb-replaces-mysql-in-rep...
- pyre 13y agoWhat is Oracle's aim in killing MySQL only to have it replaced by MariaDB?
- aioprisan 13y agoeven if you kill 80% of free signups to MySQL to get 10% of those converted to premium offerings, it would be worth it.. the rest would go to other MySQL-compatible drop-in replacement solutions, like MariaDB
- VLM 13y agoUnfortunately thats only a year ago. I believe MySQL added transactions over a decade ago and you still run into people who insist MySQL doesn't have transactions, because five years ago they read something written seven years ago that was years out of date at that time. You just don't see behavior like that outside the database community. Hey did you know that BIND doesn't support IPv6? Yeah version 4.9.3 doesn't support ipv6. Don't bother me with facts like version 9.0 was released more than thirteen years ago in 2000. So once every installed and reasonably security patched mysql server in the world supports hash joins, the world has at minimum a decade of people who have no idea what a hash join is, and no idea how or why to use it, none the less demanding that mysql doesn't support it. (Bitter? Yeah maybe a little. You can get good advice about OS, or compilers, off the internet. But overall the internet is useless for database advice, a couple stars don't outshine the greater cesspool)
- xd 13y agoI agree, and it's unfortunate, but you also see this happen in the programming language community as well, just look at the wealth of perpetuated ignorance around PHP for instance.
- VLM 13y agoFair enough, don't ask the internet for advice on databases, language selection, and how about editor. Maybe not as unique as I initially claimed but the situation still sucks.
- jerdavis 13y agoMysql has Transactional DDL?
- pyre 13y agoOracle doesn't have transactional DDL.
- dragonwriter 13y ago
- denysonique 13y agoThe API of RethinkDB is quite enjoyable as well