I own and run Design Magick. I have around 6-7 years experience with PHP, PostgreSQL and MySQL.
Viewing page 2 of 4
« | Back | Next | »

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

Introduction to Full Text Indexing

PostgreSQL Posted on 26 Mar 2006, 07:00 AM Posted By Chris Smith  
Full text indexing in postgresql is a little more complicated to set up compared to other databases.

This is a quick introduction on how to install it, how to set it up and how to keep it up to date.
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

Using Explain

PostgreSQL Posted on 05 Mar 2006, 07:31 AM Posted By Chris Smith  
Now that you've set up a database, you need to check it's being utilized properly.

Using 'Explain' to check your queries are using an index is a good way to do it. Here's a quick introduction in to reading the output.
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

PostgreSQL and FreeBSD

Starting Out Posted on 26 Feb 2006, 12:41 AM Posted By Chris Smith  
PostgreSQL can be installed using on FreeBSD using the ports that all *BSD systems use.

Check out this install guide.
Read More

Calculating database size

PostgreSQL Posted on 25 Feb 2006, 02:57 AM Posted By Chris Smith  
Postgresql creates directories to keep each database in. These directories aren't names, they are kept as the 'OID's of each database (oid's are "object identifiers"). This saves issues when you rename databases etc.

How then do you find out a databases size?

There is a "contrib" module called...
Read More

Introduction to Object Oriented Programming

PHP Posted on 19 Feb 2006, 07:13 AM Posted By Chris Smith  
Object oriented programming is a little different to procedural programming.

Here's an introduction to "OOP" and a proper example of where it can come in handy.
Read More