Sonntag, 24. November 2019

Schema & Data Browser Part 1 – An application of springy-forced diagrams for database design.



I have written a playful Oracle Cloud-ready APEX app for my own leisure, that shows you the BIG-picture of a DB schema, the DB object dependencies, and dynamic actions of an APEX app page. It helped me to understand the APEX sample applications and my customer's databases, by giving me an overview and also showing any detailed aspect with simple mouse movements.

Especially in the absence of documentation, this tool can illustrate relationships, modules, and methods. Information that I would otherwise have to procure with great difficulty.
So if you are as lazy and graphically minded as me, this might be something for you.

When you load a diagram the first time, it will take some time for the diagram to be arranged.
You can manually arrange nodes by dragging them. Sometimes you have to untangle modules to separate them. You can then save the picture for later use.
When the mouse is over the background canvas, you can zoom into the graphic with the
mouse scroll wheel and move the canvas with mouse drag and drop. You can zoom the font size of the nodes with the mouse wheel when the mouse hovers over a node. Click on a node, to show detailed Infos. The page 'Springy Diagrams' allows you, to upload your own networks to be rendered.

The diagrams are part of an integrated editor for the schema objects and for datasets.

As you see in this video, you can build your own dropbox for documents in 4 Minutes.


here is a link to the demo with a custom account
https://strack-software.oracleapexservices.com/apex/f?p=2000:1

here is a link to the demo with an apex account
https://apex.oracle.com/pls/apex/f?p=48950:1

an here is a link to an Installer for the app
https://github.com/dstrack/Schema_Data_Browser

The diagrams are based on the work of Dennis Hotson
http://getspringy.com

Regards
Dirk Strack