Viewing page 1 of 3
« | Back | Next | »

Group Concat In PostgreSQL

PostgreSQL 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

PostgreSQL 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

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

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

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

PostgreSQL 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

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

PostgreSQL and FreeBSD

PostgreSQL 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