Hi all,

There have been a couple of site updates in the last few days.

Site searching should work properly now. It wasn't paging properly but that has been fixed.

When you display an article, it will show related articles in case there's something else that might be of interest.

I've add...

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 ...

Hi all,

Welcome to the new designmagick site!

Hopefully this site will be easier to maintain and attract a few more contributors (hint hint!).

If you notice any problems or have any questions contact me and I'll get them sorted out.

If you have any suggestions for tutorials send them thr...

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