These are the most recent articles posted on the site.

If you wish to find something specific, use the search feature or browse through the available categories.

Group Concat In PostgreSQL

Hints and Tips Posted on 16 Jun 2007, 07:55 AM Posted By Chris Smith  
Group Concat is a useful mysql function, but how do we get the same results in PostgreSQL?
Read More

Database Design Issues

Forum Project Posted on 20 Apr 2006, 08:54 AM Posted By Chris Smith  
Database normalization and design issues is a difficult topic to write about. A lot of it depends on the application you are writing and how you want to access the data.

Whilst writing my forum, I decided to do things slightly differently to a normalized setup to speed things up.

Here's a look...
Read More

Introduction to Database Joins

PostgreSQL Posted on 02 Apr 2006, 08:34 AM Posted By Chris Smith  
Database joins are an essential skill to learn, whether it's using PostgreSQL or any other database management system.
Read More

Creating a Cache

PHP Posted on 02 Apr 2006, 07:08 AM Posted By Chris Smith  
I decided to create a simple cache system for this site, to cut down on the number of database queries being run.

Here's a look at how I did it, what it caches and how simple it is to get up and running.
Read More

PostgreSQL Enum Types

PostgreSQL Posted on 26 Mar 2006, 07:22 AM Posted By Chris Smith  
An enum datatype allows only certain values to be entered into a particular field (for example - 'red', 'blue', 'yellow', 'purple' for favourite colours).

Postgresql doesn't have an enum datatype, but we can emulate it quickly and easily.

Instead of an enum type we can set up a CHECK CONSTRAIN...
Read More

Introduction to Full Text Indexing

PostgreSQL Posted on 26 Mar 2006, 07:00 AM Posted By Chris Smith  
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.
Read More

Using Explain

PostgreSQL Posted on 05 Mar 2006, 07:31 AM Posted By Chris Smith  
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.
Read More

PostgreSQL and FreeBSD

Starting Out Posted on 26 Feb 2006, 12:41 AM Posted By Chris Smith  
PostgreSQL can be installed using on FreeBSD using the ports that all *BSD systems use.

Check out this install guide.
Read More

Calculating database size

PostgreSQL Posted on 25 Feb 2006, 02:57 AM Posted By Chris Smith  
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...
Read More

Introduction to Object Oriented Programming

PHP Posted on 19 Feb 2006, 07:13 AM Posted By Chris Smith  
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.
Read More