Thursday, March 3, 2011

Update for RdbAdmin

The RdbAdmin utility has been updated.  This is the 3rd major revision, and adds quite a few nice features.

New features:
  • Supports use of back and forward buttons within the app.  This was implemented using the sammy.js library.
  • Breadcrumb display to assist navigation.
  • New Function editor
  • New Trigger editor, linked from the table structure page.
  • Record Editing forms now include table and column comments; when adding or editing a record, you can see how the table owner described each field.
  • Record editing now supports a null checkbox for making value NULL.
  • Most forms (all except SQL-command) support dynamic display of SQL generated.  As you fill in the form, you can see what SQL RdbAdmin will generate to change the database when you submit the form.
  • Most forms have an edit option, so that dynamically generated SQL can be edited in the SQL-command form.  So if you need your query to include options not provided by the form, you can 'rough-in' the necessary query using the form, and fine-tune it by editing in the SQL-command form prior to submitting.
  • Most forms have an 'add query to lookup.queries' link that will display the record-insert form, with the dynamic SQL from the previous form pre-loaded into the record form.  When you have a query perfected and tested, you can add it to the lookup.queries table in one step.  The lookup.queries table enables your script to execute queries by keyword, and invoke queries using roles that cannot execute free-form queries directly.
  • In various forms interface now enables and disables buttons depending on relevance.
  • The '** keep same **' option in record-edit type lists is now gone, replaced by relevant custom type name.
  • In select panel, records are editable whenever a suitable index is available to uniquely identify unique records.
  • You cannot see this, but most classes have been refactored to make private attributes genuinely private, and minimize the number of global variables.


Todo:
  • Restore syntax highlighting; Previously, it previously used CodeMirror, but I had intermittent problems with code dependencies not getting defined.
  • Add type editing tool, for creating and modifying custom types.

Links:
Github repository
Sample Account

.

No comments:

Post a Comment