StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<p>DBAs sometimes have a data modeling tool that keeps the database model documented and that can create (and maintain) the database script in different database engine syntaxes.</p> <p>One such (less expensive) examples is <a href="http://www.toadsoft.com/toaddm/toad_data_modeler.htm" rel="nofollow noreferrer">toad modeler</a>. More expensive tools can go in the thousands of dollars - <a href="http://www.ca.com/us/data-modeling.aspx" rel="nofollow noreferrer">ERWin</a> comes to mind.</p> <p>But you seem to be looking for something way simpler. And I think you already have your answer - ActiveRecord would do it just fine (and give you migrations while at it). Django's models are another possibility. </p> <hr> <p>Edit: </p> <p>I'm not an Active Record guy... But in Django you would do <code>./manage.py sqlall <appname></code> - that would spill out all the create statements, including for indexes. </p> <p>In your case, <code><appname></code> will probably be the sole app you need. The only two files you will ever touch are <code>settings.py</code> (to define the database configuration) and <code><appname>/models.py</code> (to define the database models).</p> <p>The <a href="http://docs.djangoproject.com/en/dev/intro/tutorial01/" rel="nofollow noreferrer">Django tutorial</a> will be a good place to start; particular emphasis on <a href="http://docs.djangoproject.com/en/dev/intro/tutorial01/#id3" rel="nofollow noreferrer">creating models</a>.</p> <p>Hope that helps.</p> <hr> <p>Edit 2:</p> <p>Hmmm... Your mention of "Free" made me thing of "... as in beer" and I googled "open source data modeling". Found this:</p> <p><a href="http://www.sqlpower.ca/page/architect" rel="nofollow noreferrer">http://www.sqlpower.ca/page/architect</a> </p> <p>I know nothing about it other than it claims to do forward/reverse engineers to PostgreSQL and MySQL.</p> <p>I think it is worth you taking a look - much better for your purposes than trying to learn Django's ORM layer. Especially if it is indeed free. (Actually, I'm going to check it out myself).</p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload