Archive for the 'PostgreSQL' Category » Page 4

On MotorsportReg.com, we store vehicle numbers as a string because every so often someone has a letter as part of their number. The problem with storing numbers as strings is that they sort poorly. Instead of “1, 2, 3… 10, 20, 30…” you are presented with “1, 10, 2, 20, 3, 30…”. [...]

I’m doing a bit of consulting for a local health services organization. The environment is the predictable “LAMP” stack: Linux, Apache, MySQL and PHP. I’m about a half day into writing the PHP and remembering all of the reasons why I use ColdFusion: you have to roll your own solutions (or find somebody [...]

I just got myself a new machine to use as a dedicated database server for MotorsportReg.com. I run Postgres and wanted to figure out the fastest configuration for this machine (running a fresh install of CentOS 4.2 with non-critical daemons turned off). I ran the tests and have uploaded the results in HTML [...]

What should have been an easy download and install turned out to be a ./configure nightmare. Here’s what’s necessary to compile the RC (and likely the final) on RH9. Using YUM against Fedoralegacy.org did not resolve a key dependency of readline on termcap-devel.

Make sure the -devel versions of the following packages are installed: [...]