Even though we’re specialized in web development, we like new challenges.
One of our client asked if we could build a desktop application for sales agents. Agents need to scan images, also add several information using a form and submit the data when Internet connection is available. Even though it sounds easy, it can be a [...]
Posts under ‘databases’
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 [...]
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 [...]