views:

110

answers:

2

Hey Stackoverflow,

Yeah it's spring and a lot of things happens to me...

Also changing some software things at my computer, because suddenly everything seems to be boring after starting my laptop. I even changed my wallpaper!!!

Besides I'm looking for a new database frontend and after using google with several queries I didn't find the right software. You have to know, my laptop and me are very very special :)

I'm looking for a database frontend which should have the following features

  1. can access PostgreSQL and MySQL databases
  2. can handle schemata
  3. offers a nice sql query tool
  4. supports an import and export functionality (something like tab separated text files)
  5. it's free
  6. looks awesome - every time when a colleague comes to my office he must get the feeling: oh boy, this man really knows his job and should get more money!

At the moment I've used phpmyadmin, phppgadmin, pgadminIII, mysqladmin and dbVisualizer. Furthermore I was a big fan of the aqua datastudio until it became commercial. This tools offers a great variety of functionalities which can simplify a programmer's life. However, now you have to buy a license...I'm a scientist and money for software is limited. =)

So it's my first time (question) here at stackoverflow please be cheerful. :)

+1  A: 

OpenOffice Base can use ODBC to connect to almost anything, including PostgreSQL and MySQL.

Point 6 might be a problem... :(

Frank Heikens
Bounty awarded because Base does provide a lot more in the customisable UI department.
Edmund
+6  A: 

My Swiss army knife for databases is SquirreL SQL.

  • universal client (JDBC based)
  • extensible (through plugins)
  • does the job

It's UI is not its biggest strength though. But I rate higher what I can do with it than the way it looks like.

Pascal Thivent