MySQL 5.1 released as GA with crashing bugs | Hacker News Reader

MySQL 5.1 released as GA with crashing bugs

monty-says.blogspot.com

25 pointschaostheory12 comments

It seems that the MySQL guys are working really hard to give a lot of people the excuse they were looking for to switch over to PostgreSQL.

The MySQL people or the Sun people?

According to the article, the Sun people didn't have much to do with the GA release.

People need an excuse?

Edit: On a more serious note, this is nothing new. MySQL has had bugs and an insane amount of gotchas ever since it was released. Admittedly, every software product has some gotchas but compare the irregularities of MySQL against a comparable product, say PostgreSQL, and MySQL is significantly worse. Combine that with what used to be the developer's disdain for ACID and ANSI SQL standards and there have always been very good reason to never start using MySQL in the first place. Furthermore, MySQL still has inferior support for transactions, views, constrints, etc. compared to other databases and has absolutely atrocious multi-core and multiuser performance.

Sadly, the LAMP stack has reached canonical status. To alter any portion of it is to depart from the standard and embark on a never-ending uphill hike.

For example, nearly every Drupal module is developed against MySQL and then ported to PostgreSQL as an afterthought. Half of them have nothing but a big //FIXME where the PostgreSQL CREATE TABLE statements are supposed to be. And Drupal has actually made a big, occasionally controversial effort to remain DB-agnostic, to create and use an abstract database API, and to explicitly require every bit of core code to work and be tested under PostgreSQL. I'd guess that a lot of other PHP projects are far more tightly bound to MySQL.

Having said that, this article gives me fond thoughts of ripping MySQL off my servers and running aptitude install postgres.

I could be wrong, but I feel the same could be said for rails (until very recently). It seemed to me that rail's primary target (and maybe ruby at large) is mysql and postgres support was just an afterthought (until the latest 2.2.2 release for rails)

the only places that I don't feel treat mysql as the main premiere db is python and java

in mysql's defense, they have come a long way. they finally added stuff like stored procedures and triggers

In what way do you feel like rails support for postgresql is an afterthought?

I've noticed some books / documentation assume mysql, but that's usually limited to the "and now setup your database" section.

I've been using rails + postgresql for a long time now (almost 2 years in production) and I can't think of a single problem that was due to not using mysql. Of course, I don't use every plugin or feature, so there may be something out there...

the last one I remember are postgres specific bugs involving postgres datatypes.

my memory could be fuzzy but I feel that this would generally occur after a fresh rails release (2.2.2 is the exception)

well I am in the midst of migrating my rails app to postgres now - hopefully what I feel and reality don't match

Is GA a common acronym that I completely missed in acronym class? What does it mean?

Generally Available

I've always heard it as 'General Availability', essentially a synonym for the time/version of 'official release' -- no longer a beta/preview/release-candidate.

FCS, for 'First Customer Shipment', is a nearly-analogous term as far as I know, just preferred by other organizations.

(Both are very similar to the ideas of 'going gold', having a 'golden master', or 'RTM' [release-to-manufacturing] -- those meaning a final freeze of the intended release is available, and could be reproduced/'manufactured' as if on CDs or as box-packaged software. Though of course, the idea of physically pressing or shipping hard media is increasingly outdated.)

Thanks!

Reply on news.ycombinator.com