Database Design Issues

Random Stuff 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

Random Stuff 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

Forum Progress

Random Stuff 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

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

New tutorials on the way

Random Stuff Posted on 07 Mar 2006, 06:42 AM Posted By Chris Smith  Unrated
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...
Read More


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

Blog Intro

Random Stuff Posted on 02 Mar 2006, 05:58 AM Posted By Chris Smith  Unrated
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!
Read More