1

I needed an interface/admin (web or desktop) from which I could manage all the databases in my system. Currently I use separate admins for each (phpmyadmin for mysql, pgadmin/phppgadmin for postgres, sqlite manager in firefox for sqlite etc). Whenever I have to work with all the databases, the only option I am left with is shell access to all the databases.

I wanted to know if there is an admin which can manage all kinds of databases in a single interface, possibly similar to the one used by jennifer widom in her coursera lectures?

  • With "admin" you mean some kind of GUI tool? – a_horse_with_no_name Feb 18 '13 at 8:33
  • @a_horse_with_no_name yes. actually didn't know what exact term to use. Feel free to edit the question if you think is necessary – gopi1410 Feb 18 '13 at 8:35
  • I'm happily using sql-workbench.net (cross-platform and cross-operating system). It doesn't have a specialized "DBA GUI" for specific DBMS features though - you (mostly) need to find your way around using pure SQL. – a_horse_with_no_name Feb 18 '13 at 8:37
  • hm.. I fine even with pure SQL. Will check it out. Thanks for the link :) – gopi1410 Feb 18 '13 at 8:40
  • There's Embarcadero's DB Artisan which works with heterogeneous environments, with distinct db servers. But it's a paid tool and you didn't specify what your options are. – Marian Feb 18 '13 at 11:19
2

A bit too late, but the product Data Utensil aims to be just that. As of now, it supports SQL Server, My SQL, Oracle & Firebird (embedded).

Disclosure: I work for Maxotek, who created Data Utensil.

| improve this answer | |
  • 1
    You should explicitly identify your association with a product when answering a question with a link. I realize you said "our product", however this is not the same as saying something like "disclosure: I work for XYZ company, who created the xyz product" – Max Vernon Oct 7 '13 at 3:30
  • seems pretty good. Will give it a try sometime soon – gopi1410 Oct 7 '13 at 8:35
1

You can try Adminer (http://www.adminer.org/) which supports MySQL, PostgreSQL, SQLite, MS SQL, Oracle

An additional beauty with this is that its a single PHP file that is deployed to your server

| improve this answer | |
0

SquirrelSQL http://squirrel-sql.sourceforge.net supports a wide range of jdbc compliant DB's.

| improve this answer | |

Not the answer you're looking for? Browse other questions tagged or ask your own question.