Sunday, August 2, 2009

What Linux program can I use for database designing?

Hey, a classmate and I are working on a project together, and we were planning the database. My friend used DBDesigner (http://fabforce.net/dbdesigner4/) which is available for Linux but not too pretty, running with wine is supposed to be better but it still has a few flaws. So now I was looking for an alternative program for Linux (preferable GTK) that we could use. Thanks in advance.

What Linux program can I use for database designing?
Dia diagrams do the trick. it is usually included in your Linux distribution.





RJ
Reply:Well... I guess the key question here is what database are you using? There are a LOT of databases that run on Linux, and it's hard to make a recommendation about what management tool to use without knowing what database you're actually using.





I'll just poke in the dark here though:





MySQL


- The MySQL Server administrator is an awesome tool that is multi-platform. You can read more about it here:





http://mysql.com/products/tools/administ...





I use this on windows and linux. I also use phpMyAdmin.





PostgreSQL


- PG Admin is the GTK tool of choice:


http://www.pgadmin.org/





I generally use phpPgAdmin however - so that I can access my databases from anywhere.





If you're open to a java-based database administrator - I'd recommend Aqua Data Studio:





http://www.aquafold.com/





Being Java-based, it runs on any OS that has a JRE and you can connect to just about any database with it - Oracle, MS SQL Server, etc. I've primarily used it to connect to MS SQL Server databases from my Linux machine.





Hope this helps!
Reply:I'll be honest, I have not found anything that is all that great that runs on Linux. I do db design for a living and the tools just aren't there yet. I too have used dbdesigner and without much luck. Sorry.


No comments:

Post a Comment