PostgreSQL hasn’t had much coverage on this site yet and that’s something we’re going to correct now. PostgreSQL has, for the longest time, had a running rivalry with MySQL as the great open source database. MySQL has arguably been more popular but PostgreSQL is not without its share of advocates and adherents.

In this short article, we’re going to take a quick look at two tools written for designing and administering PostrgreSQL databases. These were selected for their recent releases this April.

First up, we have pgDesigner, an open source program for graphic design of PostgreSQL databases. pgDesigner is written in Gambas, a Visual BASIC-like programming language and requires Gambas to run. pgDesigner is currently at version 1.2.3.

Next, we have phpPgAdmin, a web-based administration tool for PostgreSQL databases. phpPgAdmin can administer multiple servers and is ideal for managing remote databases. Almost all aspects of a running PostgreSQL database can be managed using phpPgAdmin. phpPgAdmin is currently at version 4.2.