News for hackers. Stuff that matters.
Re:MySQL is to SQL like MongoDB to NoSQL by astrodust on Wednesday October 02, 2013 @12:23PM (#6483421)
MySQL has been my go-to database for years because it was fast, reliable and effective. Unfortunately it hasn't been evolving as quickly as other databases, Postgres in particular.

There's a lot of quirks in MySQL that were excusable a decade a go, but now they're problems that've been solved in virtually every other database engine. Working with Sybase was never a pleasant experience, but versions a decade old have features that MySQL still doesn't have.

Every so often you'll hit the wall with MySQL, little things like applying a LIMIT in a subselect, or row length limitations, that will make you wonder why you're using MySQL at all.

MySQL is absolutely the PHP of databases.

Re:MySQL is to SQL like MongoDB to NoSQL by xd on Wednesday October 02, 2013 @12:31PM (#6483487)
Be aware that when using text or blob types, these only contribute ~12bytes to the total row length limitation of 65kb.
Re:MySQL is to SQL like MongoDB to NoSQL by astrodust on Wednesday October 02, 2013 @02:50PM (#6484415)
Actually that's what I thought, but it's not always the case. Sometimes a good chunk of the TEXT type column is saved in the row itself (~768 characters), and when the length exceeds that, the remainder is stored in the blob area of the table store. (http://www.mysqlperformanceblog.com/2011/04/07/innodb-row-si...)

This depends on your row format, an obscure technical issue most never have to deal with, but it can be a problem.