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

Newer versions of PostgreSQL have a 'pg_stat_activity' view to show you who is currently connected to your database system.

By default, this doesn't show you the queries being run.

How do you show that?

Edit your postgresql.conf file and add (or uncomment):

stats_command_string = true

...

How do you know how long a query took?

PostgreSQL lets you time the queries and print the output in your psql session.

Create a $HOME/.psqlrc file with:

\timing

in it and next time you log in to a psql session, PostgreSQL will show you how long the query took!

Doing it this way means ...

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.