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

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

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

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

Comment Spam

Site News Posted on 26 Mar 2006, 07:10 AM Posted By Chris Smith  Unrated
I'm glad I set up comments with comment-spam in mind. They are not automatically authorized, and I added checks in to make sure you can't send mail through them (I don't get notified when a comment gets made, it's just put into the system without being authorized).

I'm starting to see a few spam ...
Read More

Log analyzer

Hints and Tips Posted on 08 Mar 2006, 07:02 AM Posted By Chris Smith  Unrated
I found a useful little tool the other day.

Practical Query Analyzer (written in ruby) will parse a postgresql or mysql log (though at last look mysql support was broken) and tell you what sort of queries are being run. This can help you work out whe...
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