Project Description
DB Schema Viewer is a Silverlight widget that allows to display a database diagram on an existing website via javascript.

It implements advanced RIA options like table rearranging by drag and drop, zooming, ...

snapshot.jpg

Right now is a subset of DBSchemaEditor(DBSchemaEditor). Hope to get some collaborators or time to start customizing it.

It can be integrated on almost any web dev technology (ASP .net, PHP, JSP...). Just plug the OBJECT / asp:Silverlight tag in your HTML or ASP .net pages, a brief diagram about how to load a diagram via javascript:

jsinstantiation.jpg

The diagram is passed in a parameter to the SL plugin via javascript as a string (XML format).

About the XML diagram structure (you can download here a sample DB XML), is quite simple:

  • Header: (diagram metadata like size of the canvas, las internal ID used).
  • Tables: tables definitions (tables and fields, important use a unique ID for each table or field).
  • Relations: relation between tables definitions (this relations support multi relations fields, important use a unique ID for each relation).

About the type of each table field, right now is not used in the current version, but will be soon, the current type mapping (numeric ID to DB type) can be downloaded from this link.

Hope as well to fully integrate it with DBSchemaEditor diagrams (save to local a diagram and directly use it on the Viewer).





Last edited Aug 8, 2009 at 12:57 PM by braulio, version 12