(Leo Hsu and Regina Obe) A very long time ago, we wrote an article on how to use PostgreSQL to show the fully qualified name of an item in an inventory tree. Basically we were modeling a paper products tree. The original article can be found here Using PostgreSQL User-Defined Functions to solve the

(Sarah) Here’s a quick list of common mistakes that I’ve seen regarding indexing in MySQL.

After reading Fernando Ipar’s interesting post on partial indexes for string columns, there were two things I wanted to note:

(Sean Hull) Many articles on database administration take the perspective of trying to help you do your job better. We thought we might take a different tack and poke a little fun at some of more egregious mistakes we’ve seen over the years at IT shops.

(Andrew Morgan) If you have asynchronous replication where the slave database is using MySQL Cluster then you can use the NDB API events functionality to mask/overwrite data. You might do this for example if the replica is to be used for generating reports where some of the data is sensitive and no

(Fernando Ipar) This time, I’m talking about indexes for string typed columns. In particular, I’ll show a procedure I find useful while looking for good index length values for these columns.

(Andrew Morgan) This article shows how to create a MySQL-plugin that can be used to create a function which can in turn be used in stored procedures. The function will produce an integer value representing the time (to the nearest usec).

(Shlomi Noach) My other half says I’m losing it. But I think that as an enthusiast kernel developer she doesn’t have the right to criticize people. (”I like user space better!” – she exclaims upon reading this).

(Anders Karlsson) I got the question on how small a packaged application with a built-in MySQL server could be. I had an idea that it could be made very small, but I didn’t have any exact numbers. The platform was Windows, so I decided to try to build an application like this, to test it.

(Baron Schwartz) Every once in a while, I find myself needing to round a number up to the nearest even power of 10, or round a time interval to the nearest quarter of an hour, or something like that. This is actually quite simple, but for some reason I always find myself confused about how to do it.