Orange is my favorite color

Archive for the 'PostgreSQL' Category

Date and time fields can cause chaos in the database but there are modern ways to model and control temporal data

Download a free database of 600 conjugated Spanish verbs under a Creative Commons license courtesy of Professor Fred Jehle

Store only a subset of files on Amazon S3 using s3cmd and a little date logic. Lets us put the last 5 database backups (or something similar) in a safe place without saving every dump forever and costing us $$$.

New PostgreSQL performance book by Gregory Smith released – covers versions 8.1 to the brand new 9.0.

Postgres 9.0 is here (next week) and the elephant has brought some new toys.

Make sure you get an appropriate alert when a drive goes dead in your HP/Compaq RAID array

Wordpress inches closer to PostgreSQL support with a third-party plugin that maps MySQL calls to Postgres.

A SQL tip for inserting large numbers of database rows at a time. Improve performance by grouping inserts into fewer commits.

Working replication between two Postgres or MySQL database servers in under 5 minutes with few limitations – it’s true!

What I took home from cf.objective() 2009 and the slides from my two presentations on PostgreSQL and migrating to a framework.