db structure graphical analysis tool

[Jurgis Pralgauskis]

Hi, 

in our DB we have ~300 tables. So I hacked into graph_model to filter  shown tables/fields. 

It was very helpfull for me when I joined the project with so many tables.

The most common use case -- searching for possible join-paths between two tables, but also can filter by (fragments of) tablenames.

It shows SVG by default (less memory consumption than png), 

and tables are hyperlinked to their admin pages.

Also made beta plugin (the code is quite dirty and  not optimal, but does the job : ).  

src: controller, view 

screenshot

Would be glad if someone finds it usefull :)

ps.: what is the best way to distribute it? http://www.web2pyslices.com/ seems to be frozen for 1 year..

[António Ramos]

+1 good job

--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscribed to the Google Groups "web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Paolo Valleri]

Hi Jurgis,
web2py master has recently switched from pygraphviz to a js based solution. I would suggest you to adapt your change with current master branch and then publish a PR for an integration.

Paolo

+1 good job

To unsubscribe from this group and stop receiving emails from it, send an email to web2py+un...@googlegroups.com.

[Richard Vézina]

Does the old appreciate pygraphviz still work out of the box??

I thought we would keep support for it??

Thanks

Richard