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

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

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

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!