Musings of a Manchester Drupal guy

Drupal, Open Source, Analytics, Social Media.

Tuesday, July 13, 2004

Postgres Tools

About 6 months ago I migrated the major project I am responsible for from MSSQL Server to Postgresql. The move was fundamentally easy, stress free and opened up opportunities to start using Geo-Spatial queries. This is my second experience of Postgres, it has moved on heaps and there are some good third party tools available, which makes life much easier and opens the product to less techy people.

Some useful tools are available for Postgres including Aqua Data Studio which is the equivelant to Query Analyser (and can point to MSSQL anyway). It is much faster also. Additionally I have found EMS PostgreSQL Manager 2 to be invaluable.