Creating a PostgreSQL and MySQL driver

By Tony Marston
2005-09-20


Administrative programs

Although both MySQL and PostgreSQL come with command line interfaces I think that as we are now in the 21st century the vast majority of developers would insist on a set of proper GUI tools.

MySQL has the following:

• MySQL Administrator - a multi-platform GUI tool.
• MySQL Query Browser - a multi-platform GUI tool.
• phpMyAdmin - a web-based tool written in PHP.

PostgreSQL has the following:

• pgAdmin - a multi-platform GUI tool.
• phpPgAdmin - a web-based tool written in PHP.

These are all freely available, although there are also commercial products available for both databases.

In my personal opinion the tools for PostgreSQL are second rate when compared with those for MySQL. I particularly dislike the feature in phpPgAdmin for executing SQL statements. You type in the statement, hit "Go", and nothing happens. This is because it has opened up a second browser window for the input of SQL commands, and all results appear in the first window. Very user-unfriendly!

Tutorial Pages:
» Introduction
» Administrative programs
» Connecting to a Database
» CREATE TABLE syntax
» SQL queries
» Conclusion

Related Tutorials: » Installing MySQL on Windows » Implementing High Availability in MySQL » Stored Procedures are EVIL » MySQL Database Handling in PHP » A Flexible Method of Storing Control Data » Exploring MySQL CURDATE and NOW. The Same But Different.