Creating a PostgreSQL and MySQL driver
By Tony Marston2005-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:
|
|
|||||||||
You might also want to check these out:
|
Leave a Comment on "Creating a PostgreSQL and MySQL driver"
You must be logged in to post a comment.
Link to This Tutorial Page!
