(Leo Hsu and Regina Obe) Every programmer should embrace and use regular expressions (INCLUDING Database programmers). There are many places where regular expressions can be used to reduce a 20 line piece of code into a 1 liner. Why write 20 lines of code when you can write 1.

(Sean Hull) Heartbeat automates all the moving parts and can work as well with the MySQL master-master active/passive solution as well as it can with the MySQL & DRBD solution. It manages the virtual IP address used by the database, directs DRBD to become primary, or relinquish primary duties, mount

(Ronald Bradford) Before undertaking such migration the first step is a lesson in understanding more about how latin1 and utf8 work and interact in MySQL. latin1 in a common and historical character set used in MySQL. utf8 (first available in MySQL Version 4.1) is an encoding supporting multiple byt

(Vincent Danen) When it comes to open source databases, MySQL gets the lion’s share of attention. MySQL is an easy-to-use database, and a lot of open source web applications are geared towards it.

(Peter Zaitsev) I’m running in this misconception second time in a week or so, so it is time to blog about it.

(Kerry Osborne) Hey, I just thought of something. One of the things I do fairly regularly when struggling with a SQL statement that is not behaving goes like this: –create a copy of the statement in a test script –add the GATHER_PLAN_STATISTICS hint –duplicate all the bind variables (with

(Shlomi Noach) In mathematics, a monotonic function (or monotone function) is a function which preserves the given order.

(Geert Vanderkelen) Yes, MySQL has transactions if you use InnoDB or NDB Cluster for example. Using these transactional storage engines, you’ll have to commit (or roll back) your inserts, deletes or updates.

(Baron Schwartz) I explored two interesting topics today while learning more about Postgres.

(Rob Gravelle) After the All About the Crosstab Query article was published, some astute readers pointed out that my SQL statement was more complex than it needed to be. Their suggestions sent me in search of a simplified statement that would yield the same results. There were a couple of ways to sh