I need a simple tool for visually modeling a database schema for an SQLite database. I do not need it to generate code, I just want some visualization. I really liked WWW SQL Designer but when I use it locally I am not able to save or load anything. It is also very poorly documented as it is still relatively young. Can anyone suggest another tool for this task? It does not have to be browser based, and it should be usable offline. It should support Mac OS and it should be free.
+3
A:
I model all my schemas by hand (on paper) at the entity level. I do not get into using a tool until I get to column level design.
Raj More
2010-04-29 14:57:20
hmmm. that doesn't look like a Mac thing. ;)
Ken Aspeslagh
2010-04-29 20:23:42
true, but it runs on Linux - wandering if there a port to Mac
IMHO
2010-04-30 01:59:20
A:
If you have a copy of MS Access, you can use it to build a prototype schema, and then use the relationship diagram tool to visualize the schema.
You can slide the boxes around in the relationship diagram, and you can print a relationship diagram with some versions of Access.
Having a prototype offers another benefit. You can test the schema before building the real thing.
Walter Mitty
2010-04-30 11:45:02
A:
I like Dia. It's free, cross-platform, and there are plugins to turn your design into SQL queries or take an existing database and create a design from it.
dj_segfault
2010-04-30 11:51:25