The Joel on Software Discussion Group (CLOSED)

A place to discuss Joel on Software. Now closed.

This community works best when people use their real names. Please register for a free account.

Other Groups:
Joel on Software
Business of Software
Design of Software (CLOSED)
.NET Questions (CLOSED)
TechInterview.org
CityDesk
FogBugz
Fog Creek Copilot


The Old Forum


Your hosts:
Albert D. Kallal
Li-Fan Chen
Stephen Jones

Open source data modelling tool

Can anyone recommend a good open source (or cheap commercial) data modelling tool for OS X (or failing that windows)?

Doesn't need to be anything too complicated, I just want something that can edit and help visualise a decent-sized database schema. Doesn't need to generate code even, more just for reference and getting ideas straight.
Matt Send private email
Sunday, February 27, 2005
 
 
This open source one here is VERY impressive:

http://www.fabforce.net/dbdesigner4/

It also works with any odbc database….

I don’t know if there is a OSX one (it was written in Delphi)


Albert D.Kallal
Edmonton, Alberta Canada
Kallal@ msn.com
http://www.members.shaw.ca/AlbertKallal
Albert D. Kallal Send private email
Sunday, February 27, 2005
 
 
I should point out that the tool has some rough edges...but it still is a nice start
Albert D. Kallal Send private email
Sunday, February 27, 2005
 
 
Ooh that looks very nice. No mac version by the looks of it, although I may be able to compile the Linux version for X11 on OS X. Actually if it's written in Delphi maybe not. Hm.

So far I've found a lot of database administration tools but none of them have visual editors for the schema. That and a few very expensive commercial tools. Ah well cheers for the info!
Matt Send private email
Sunday, February 27, 2005
 
 
DBDesigner 4 looks very nice, but I haven't had any success getting it to run on a Linux box that doesn't have Delphi installed. Binaries are available for download, but there are no installation instructions and the application depends on a bunch of libraries that I can't find.

It's too bad, because I can't find another such app for Linux that's both free and mature.
comp.lang.c refugee
Monday, February 28, 2005
 
 
I think I should just put this up as an FAQ somewhere.

Microsoft have this abandoned product called VisoModeler it was the last standalone version of InfoModeler which they'd bought in from a Paul Allen funded company (another example of how Paul Allen has generated more flowers than billG).

It was absorbed and generally screwed up in Visio Enterprise but the standalone version still works and hasn't rusted.

http://do-
wnload.microsoft.com/download/visio2000enterprise/ORMtool/3.1/WIN98/EN-US/msvm31.exe
Simon Lucy Send private email
Monday, February 28, 2005
 
 
Simon Lucy Send private email
Monday, February 28, 2005
 
 
Course it won't run in OSX, but then you should give allowance for my non reading ability this morning and my doing seven things simultaneously.
Simon Lucy Send private email
Monday, February 28, 2005
 
 
For something Visio-like have a look at Dia (http://www.gnome.org/projects/dia/home.html)

It has alot of plugins/addons that look usefull too

Found this site, http://www.databaseanswers.com/modelling_tools.htm, with a list of tools you can consider...
Honu
Monday, February 28, 2005
 
 
Honu
Monday, February 28, 2005
 
 
Aha!

Am now trying out this:
http://www.malcolmhardie.com/sqleditor/

Which is shareware but seems to be nice simple and pretty and do exactly what I need :-). Took a while to find though!
Matt Send private email
Monday, February 28, 2005
 
 
By reading this post, I want to ask a question.
Is there a convention on building databases? What is "data modelling" ??
wannabeboy Send private email
Monday, February 28, 2005
 
 
Well yes there are (loose) conventions on how to diagram database schemas.

There are also various approaches to data modelling / database design, try googling on Entity-Relational Modelling and on Normal Forms and the relational model
Matt Send private email
Monday, February 28, 2005
 
 
And data modelling is essentially just figuring out how best to reflect selected parts of the 'real world' in a database schema. Pretty hard to get right if you're modelling something complicated, hence the need for visual tools.
Matt Send private email
Monday, February 28, 2005
 
 

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics
 
Powered by FogBugz