I'm looking for a windows application which will allow you to connect to a postgres or mySQL database and view it and make changes to databases in a "gui" format.
Do any of you know of a good application which can work with both database types?
Thanks,
Jesse Edwards
it's not a real windows app, but u can use phpmyadmin http://sourceforge.net/projects/phpmyadmin/ to control your mysql db via a html-php frontend - or u try to get obdc drivers for your db (i think for mysql there's something called myobdc or so) and use some obdc app to modify your db (access should do, i.e.) hth
Yeah, i know about myphpAdmin, and there are several applications that will allow you to manage mySQL or postgres. I'm searching for one that will interact with both.
Jesse
good luck but i think (if u use windoze) the obdc drivers allow u to manage your db's (if u got obdc drivers for em) via access etc.. hth
I understand that I can connect to the databases using odbc, however i'm looking for an interface that will allow me to make changes to them. (both formats)
Does that make sense or am I miss understanding your last post?
no but obdc allows u to modify dbs, too
These guys make a nice product, for not too much money:
http://www.phpbuilder.com/news/item.php?id=512 http://www.phpbuilder.com/news/item.php?id=496
if you get the odbc drivers you can use access to connect to the databases through the odbc connections. You can even create a front end for your database in access so you can have an offline admin area which is much more secure then an online one.
For PostgreSQL, you really want to use pgAdmin 3 if you want a windows GUI.
http://pgadmin.postgresql.org/pgadmin3/
Chris
I pretty much just use phpmyadmin and phppgadmin for GUI's these days. There are quite a few others out there: mysql-front, dbtools, EMS, pgadmin, pgexplorer, ...
