This forum is in READ-ONLY mode.
You can look around, but if you want to ask a new question, please use the new forum.
Home » support » General discussion » Visual database modeling (doctrine/symfony)?
Visual database modeling (doctrine/symfony)? [message #43826] Sun, 20 January 2008 21:46 Go to next message
symfawe  is currently offline symfawe
Messages: 11
Registered: January 2008
Junior Member
Hi all,

I am starting a new extensive project with synfony (to which I'm new as well). Since the database will not be so simple, I'm trying to find a way to use a visual modeling tool.

My question: which visual modeling tool can I use so that the model I create can be automatically translated to the ORM layer (I figure doctrine is most relevant for me)? The point is not to do the work visually and then with the code so every update would need to be done twice.

Options I thought of so far (and yes, they may seem wierd):

A - Use DBDesigner4 for modeling, save .XML file which can be imported to a Propel model which I can convert to Doctrine model.

B - Use Power*Architect or another one which will interface my database directly (currently mySQL but maybe PostgreSQL later) and build the Doctrine model from the database every time.

If any of these options seem reasonable, please let me know if you have any experience with them or tips you can share.
If you guess they're bad options - I am eager to hear what's in your toolbox.

Thanks,
Amir.
Re: Visual database modeling (doctrine/symfony)? [message #43836 is a reply to message #43826 ] Mon, 21 January 2008 08:54 Go to previous messageGo to next message
al_n  is currently offline al_n
Messages: 321
Registered: May 2006
Location: The Netherlands
Faithful Member
Look at this post of my where I explained how I'm using clay for the database modeling: http://www.symfony-project.org/forum/index.php/m/15387/


Re: Visual database modeling (doctrine/symfony)? [message #43850 is a reply to message #43836 ] Mon, 21 January 2008 12:00 Go to previous messageGo to next message
symfawe  is currently offline symfawe
Messages: 11
Registered: January 2008
Junior Member

Which visual modeling tool do you use for your database design?[ 14 vote(s) ]
1.Don't use any 2 / 14%
2.DBDesigner 5 / 36%
3.Clay 1 / 7%
4.Power*Architect 0 / 0%
5.Other tool (opensource) 2 / 14%
6.MySQL WorkBench 1 / 7%
7.Other tool (commercial) 3 / 21%

Thank you for your reply. It seems pretty similar to my first option (replacing DBDesigner with Clay - BTW: do you consider Clay better?).

Since I wish to use Doctrine I would still need to convert the Propel schema to Doctrine one, right?

Here are the links from Symfony Wiki (maybe you should add your solution there as well for the public):

DBDesigner to Propel -
http://trac.symfony-project.com/wiki/DBDesigner2PropelTool

Propel to Doctrine -
http://trac.symfony-project.com/wiki/ConvertPropelSchemaToDo ctrineSchema

al_n wrote on Mon, 21 January 2008 09:54

Look at this post of my where I explained how I'm using clay for the database modeling: http://www.symfony-project.org/forum/index.php/m/15387/


Re: Visual database modeling (doctrine/symfony)? [message #43856 is a reply to message #43850 ] Mon, 21 January 2008 13:41 Go to previous messageGo to next message
al_n  is currently offline al_n
Messages: 321
Registered: May 2006
Location: The Netherlands
Faithful Member
As I'm using Eclipse for all of my development work then clay is my choice. I'm sure that there are some better tools out there if you are looking for a professional expansive solution but clay is just fine for a single database development within a Symfony project.

[Updated on: Mon, 21 January 2008 13:44]

Re: Visual database modeling (doctrine/symfony)? [message #43859 is a reply to message #43856 ] Mon, 21 January 2008 14:15 Go to previous messageGo to next message
symfawe  is currently offline symfawe
Messages: 11
Registered: January 2008
Junior Member
Since I'm also using Eclipse I'll look into it. Are you using Doctrine or Propel? Is there a way to convert Clay's output to Doctrine schema?

10x

al_n wrote on Mon, 21 January 2008 14:41

As I'm using Eclipse for all of my development work then clay is my choice. I'm sure that there are some better tools out there if you are looking for a professional expansive solution but clay is just fine for a single database development within a Symfony project.


Re: Visual database modeling (doctrine/symfony)? [message #43860 is a reply to message #43859 ] Mon, 21 January 2008 14:29 Go to previous messageGo to next message
al_n  is currently offline al_n
Messages: 321
Registered: May 2006
Location: The Netherlands
Faithful Member
I'm using propel. If you look at my post you will see that I'm using an xslt transformation to convert the clay model to propel schema. You can tweek the xslt to for doctrine or you can convert the propel schema to doctrine schema.
Re: Visual database modeling (doctrine/symfony)? [message #43881 is a reply to message #43860 ] Mon, 21 January 2008 17:28 Go to previous message
symfawe  is currently offline symfawe
Messages: 11
Registered: January 2008
Junior Member
I'm really wondering if there's no other person who has been working with Doctrine and using some visual modeling tool...

Thanks for the tip, I'll be able to pick it from there Smile

al_n wrote on Mon, 21 January 2008 15:29

I'm using propel. If you look at my post you will see that I'm using an xslt transformation to convert the clay model to propel schema. You can tweek the xslt to for doctrine or you can convert the propel schema to doctrine schema.

Previous Topic:wrapped: Could not execute update [Native Error: Duplicate entry '0' for key 1]
Next Topic:Caching page per user
Goto Forum:
  

powered by FUDforum - copyright ©2001-2004 FUD Forum Bulletin Board Software