Wednesday, November 18, 2009

Improvements to Rdbadmin program


Rdbhost sports its own admin utility, Rdbadmin, implemented in Javascript. It is useful to create and remove tables and views, adding and deleting data from tables, and performing queries.

Rdbadmin has been upgraded, with both new features and bug fixes.

New features include:
  • Table and view lists are sorted.
  • Tables and views can belong to schemas other than public. This will become more important with upcoming features.
  • New feature to set field defaults on tables.
  • HTML content is now escaped, so that it reads as the tags themselves, and the data inline formats cannot interfere with the display table structure.
  • In the select page, query data values are parameterized, so the data values cannot be misinterpreted by the SQL engine as statements.
  • The login and logout functionality has been removed. Logging in is done via the www.rdbhost.com front page (or the www.rdbhost.com login page), and logging out from the profile page. The admin script gets role and authcode from the rdhost member cookie, and just bounces the user to the login page if member cookie is missing. The 'guest_account' functionality is still present, where the 'r'-role can be provided on the url.
As always, the admin program is linked from the profile page. As always, your questions and criticisms are welcome.

No comments:

Post a Comment