I'm glad I set up comments with comment-spam in mind. They are not automatically authorized, and I added checks in to make sure you can't send mail through them (I don't get notified when a comment gets made, it's just put into the system without being authorized).

I'm starting to see a few spam ...

Full text indexing in postgresql is a little more complicated to set up compared to other databases.

This is a quick introduction on how to install it, how to set it up and how to keep it up to date.

I found a useful little tool the other day.

Practical Query Analyzer (written in ruby) will parse a postgresql or mysql log (though at last look mysql support was broken) and tell you what sort of queries are being run. This can help you work out whe...

Hi all,

I'm busy trying to come up with new tutorial ideas.

I'm in the middle of writing a tutorial about sql trees (this is a bit more advanced than the current ones on the site). They replace parent / id relationships and with larger systems can speed things up quite a bit.

I'm also in th...

Now that you've set up a database, you need to check it's being utilized properly.

Using 'Explain' to check your queries are using an index is a good way to do it. Here's a quick introduction in to reading the output.

Bit of a strange topic to find on a site about postgresql.. but mysql has some strange ideas.

I found a mysql blog that details a rather strange bug.

Some queries are not logged into the system log.

I'm not really sure why but the poster doesn...

Hey guys,

This blog is going to be about random stuff to do with the web - not necessarily php or postgresql.

I'm still looking for ideas on articles so send 'em through!

PostgreSQL can be installed using on FreeBSD using the ports that all *BSD systems use.

Check out this install guide.

Postgresql creates directories to keep each database in. These directories aren't names, they are kept as the 'OID's of each database (oid's are "object identifiers"). This saves issues when you rename databases etc.

How then do you find out a databases size?

There is a "contrib" module called...

Object oriented programming is a little different to procedural programming.

Here's an introduction to "OOP" and a proper example of where it can come in handy.