Extending PostgreSQL for fun: with cats

By | Technical | 2 Comments

Perhaps you’ve thought I wish I had more cats in my Postgres database before. We certainly have. Just the other day we were lamenting some of the differences between MySQL and PostgreSQL, particularly the way that MySQL has case-insensitive matching using the LIKE operator, while Postgres has LIKE and ILIKE. This got us thinking, it’d […]

Read More

Let us take your breath away with Wheezy!

By | Technical | No Comments

A new version of the Debian GNU/Linux operating system, version 7.0 (codename “Wheezy”) has been released today. Thanks to the open and transparent development cycle of Debian, we have been able to work on improving our support for this release ahead of time, and are happy to announce that we now offer our market-leading Anchor […]

Read More

Backups for Postgres that don’t suck

By | Technical | No Comments

PostgreSQL is awesome in many, many ways. One of these ways is in its use of a write-ahead log, or WAL, that enables: Atomicity Durability Replication (that isn’t insane, like MySQL’s) Backups And much much more! </televisionSalesman> We’re interested in backups today, because textual dumps for backups (the lowest common denominator for mysql and pgsql) […]

Read More

PostgreSQL 8.4

By | Technical | 2 Comments

Good news, everyone! PostgreSQL 8.4 is out, as of several weeks ago. Okay, this isn’t “new” news, but it’s not at all ungood, delay or otherwise. You can catch the feature list here, there’s some good stuff: http://www.postgresql.org/about/press/features84.html Of course the real trick is getting more of our customers to use the superior alternative, *le […]

Read More