(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
Tag: Open Source
Common indexing mistakes
(Sarah) Here’s a quick list of common mistakes that I’ve seen regarding indexing in MySQL.
On partial indexes for string columns
After reading Fernando Ipar’s interesting post on partial indexes for string columns, there were two things I wanted to note:
7 Ways To Crash a Database
(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.
Using NDB API Events to mask/hide colum data when replicating
(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
Indexing text columns in MySQL
(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.
Creating a MySQL plugin to produce an integer timestamp
(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).
SQL pie chart
(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).
A minimal MySQL ODBC application
(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.
How to round to the nearest whole multiple or fraction in SQL
(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.
