Database Metadata

January 30, 2012

"Table Builder" window

"Table Builder" window

http://simplphp.com

The image shows a new browser called “TableBuilder”.

At the top-left, is a panel showing the accessible MySql databases and below it is a panel which shows the tables defined within the selected database. The large panel in the center shows field information for the selected table.

At the moment, there are only two databases visible without a login account:
— simpl (which contains all of the SIMPL objects)
— demo (tables for use in demos)

This browser will be used for generating ExtJs specifications from database metadata.

In particular:
— field definitions for data stores
— column definitions for grids
— data validation functions
— table relationships for SQL queries

The goal is to automate the most tedious and error-prone tasks of creating a use interface.

And all the more important the larger the project.