Group Concat is a useful mysql function, but how do we get the same results in PostgreSQL?

Creating a good database design takes some thought. Sometimes, a normalized database won't perform the way you want it. Using some features of postgresql, you could get your performance back.

I decided to use some functions and triggers to keep queries nice and simple, but not lose any functional...

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...

The forum is very slowly getting put together. The basic admin areas are done:

- forums have group access
- groups can have users

Since most of the work is done on the frontend, I have been putting the design together and working out how to keep things in check.

Since postgresql has advanc...

I finally got around to adding an area for users to submit articles.

You have to be logged in to submit an article - that saves me having to worry about the form being used for spam, random php scripts trying to be used to hack the site and so on..

So, if you want to submit something, go for i...

I haven't made much progress with the new forum yet, but I've worked out how to manage permissions.

At the bottom level will be users.

Users will be in groups.

Groups will have permissions in particular forums (so a user can be a forum moderator in a particular forum, but a simple user in a...

Database joins are an essential skill to learn, whether it's using PostgreSQL or any other database management system.

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.

I've decided to do something a little more constructive than random tutorials.

I've been looking for a forum to put on the site to make it a bit more interactive, but haven't been able to find anything suitable.

Either they are mysql-only or security-issue prone.

Fud-forum works with postgr...

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...