Database joins are an essential skill to learn, whether it's using PostgreSQL or any other database management system.

PostgreSQL can be installed using on FreeBSD using the ports that all *BSD systems use.

Check out this install guide.

Database indexing can be quite tricky. Here is a basic guide on how to get started with it, when you should index and when you shouldn't.


Written for Interspire

Deleting old data from your database is a useful thing to do. If you keep a list of books or cd's you own and you sell or give something away, you can remove it from the list. Here's a quick introduction on how to do it.

Now we can add and show the records in a database, how can we update it? This tutorial will give you a quick introduction on how to do it.

We've seen how to put data into our database, here's a look how to get it back out again using php and the postgresql functions.

Adding data to your database is an essential part of creating a dynamic site. Here's a look at how to get started.

Databases can store lots of different data in quite a few different ways. This guide shows some of the basic and common types you'll run across and how to pick which type is the right one to use.

Written for Interspire

Before we start coding anything, we'll look at how to design your database. It can be quite a complicated procedure but this guide should show you everything you need to think about.

Written for Interspire

PostgreSQL of course supports multiple databases. Here's an introductory look at how to get them up and running.