Monday, July 30, 2012

Re: Tool to visualize database schema on cakephp

Hi.

Such a toll cannot be bundled with Cake itself because Cake can use different DataSources.

The best tool I've used (for MySQL) is MySQL Workbench. It does design and forward/reverse engineering for MySQL only, but for "schema visualization" it will do the trick for all.
I've incorporated this wonderful piece of software in my dev process and I can freely say that there are many benefits, some being:
- An always up to date model of the database
- All changes to the DB are made from MySQL Workbench
- Versioning for DB changes
- Real easiness  for "Database Forward/Reverse Engineering"
- Generation of SQL divs
- ...

Of course all of its features would work only on MySQL (and its forks maybe like MariaDB), but if you would only like to visualize then it will do wonders for you. You can also check out Dia - the open source diagram editor, with which you can create graphs, but you wouldn't have any of the other features, as
it is not solely a DB design tool. Try Workbench out.

Cheers,
   Borislav.

On Tuesday, 31 July 2012 05:41:13 UTC+3, Lightee wrote:
Dear cakephp experts,

Does anyone know of tools that can help us visualize the database schema on cakephp? Hopefully, it can show the relationship (1 to many, 1 to 1) between different tables.

Thank  you.

--
Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org
Check out the new CakePHP Questions site http://ask.cakephp.org and help others with their CakePHP related questions.
 
 
To unsubscribe from this group, send email to
cake-php+unsubscribe@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php

No comments: