blog’s amazing Rotating Header Image

Posts Tagged ‘database’

MySQL – limitations you never heard of

We all know MySQL has its limits – it works fine in general, but has its weaknesses too. The authors of MySQL Performance blog started a miniseries about such limitations for experienced users. Okay, I guess you know there’s no way to create fulltext index on InnoDB tables – but bid you know, that MySQL [...]

Why You Should Replace ENUM With Something Else

There are many developers who prefer using ENUM in MySQL, which seems to be a viable choice many times. However it’s important to take care as…

ENUM requires a rebuild of the table when adding a value to the middle of the set.
ENUM values are ordered in the order they’re added to the database
ENUM values do [...]