Tag

postgresql Archives - AWS Managed Services by Anchor

Extending PostgreSQL with high level languages (and cats)

By | Technical | No Comments

In a recent post we extolled the virtues of creating your own brand new operators in PostgreSQL. SELECT =^_^= FROM happycats; That’s well and good, but the output was a little lacklustre, returning “meow” for every tuple. We’d like to make it more interesting, and one way to add interesting functionality to Postgres is to embed a procedural language. This lets you juggle data with a little more finesse when it comes to certain operations, compared to the usual relational algebra. We’re going to use Perl because it’s easy to integrate with Postgres, and is generally a quick and dirty way to Get Stuff Done. When embedded in Postgres it’s referred to as PL/Perl. Let’s get started. We begin by “installing” the language into the database in which we wish…

Read More

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 be amusing to have more vague (and hilariously unwieldy) operators, such as: SELECT * FROM foo WHERE a VAGUELY RESEMBLES b; Something like this isn’t too implausible. It’s similar to what a full-text search entails, but it’s far from trivial. This got us thinking: if we can’t easily do that, can we at least have some amusing query syntax? Yes we can!

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 Complete support on Debian Wheezy immediately. Aside from the improvements and new software versions shipped with Debian Wheezy, we are also supporting some newer versions of software we like that didn’t make it into the release. When you choose Anchor Complete support with Debian Wheezy, you also get full support for the following: nginx 1.4 with SPDY built in Percona 5.5 (performance-enhanced MySQL fork) PostgreSQL 9.2 with massive performance gains Redis 2.6 with NDS If…

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) puts a lot of load on the server and tends to be very slow. We started looking into something like mylvmbackup for postgres, but then discovered that there was no need – it’s already built in! We’ve made a easy guide to trying it out for yourself. It’s fairly detailed and hands-on, so we’ve split things out to a separate page: Better PostgreSQL backups with WAL archiving If you’re a Postgres user, we’d love to…

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 sigh* As if you *needed* any further convincing to choose Postgres over Mysql, we’ve put together a little comparison for you that highlights some of the most obvious differences for you. 🙂 http://www.anchor.com.au/hosting/dedicated/mysql_vs_postgres Oh yeah, using a Redhat OS? You’re short outta luck, you don’t get anything newer than 8.1.11 in the stock release – go use Debian, it’s better anyway. What are you missing out on? Plenty.

Read More