If you'd like to contribute to this site or have an article suggestion, please contact us.

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

PostgreSQL Posted on 20 Apr 2006, 10:15 AM Posted By Chris Smith  Unrated
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...
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

Forum Progress Part II

Forum Project Posted on 17 Apr 2006, 09:27 AM Posted By Chris Smith  Unrated
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...
Read More

Site update

Site News Posted on 03 Apr 2006, 05:59 AM Posted By Chris Smith  Unrated
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...
Read More

Forum Progress

Forum Project Posted on 02 Apr 2006, 08:59 AM Posted By Chris Smith  Unrated
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...
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

New project

Random Stuff Posted on 28 Mar 2006, 06:02 AM Posted By Chris Smith  Unrated
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...
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