Tuesday, September 14, 2004
HTMLDB
If not exactly a best-kept secret, certainly one of the coolest new features of the 10g release is htmldb. This is a declarative programming environment for producing database driven web applications. Perhaps the most compelling example of it in use is Ask Tom which is the Q&A web site run by Tom Kyte of Oracle.
We had a requirement in house just recently to produce a small app that would be used by appropriately authorised systems administrators to populate a couple of tables with small amounts of lookup data for a new system.
Using HTMLDB we produced an app that
1. Authenticates the user from the Enterprise wide LDAP compliant directory.
2. Provides a consistent look and feel using CSS.
3. Uses bind variables throughout for scalability.
4. Could be hosted in an enterprise portal if necessary.
In less than 2 days development time by a DBA (not a developer).
Other fetures that htmldb makes available almost on a pick and choose basis are
1. Full text searching.
2. SSO Integration.
3. Workflow.
4. Email Notifications.
5. File Upload/Download to database BLOB columns.
6. SVG Charting.
Finally, though the product is available on the 10g Companion CD (available FOC from OTN). It is supported (and works just fine) from 9.2.0.3 onwards - so you don't need to migrate a production database to take advantage of it.
0 Comments
If not exactly a best-kept secret, certainly one of the coolest new features of the 10g release is htmldb. This is a declarative programming environment for producing database driven web applications. Perhaps the most compelling example of it in use is Ask Tom which is the Q&A web site run by Tom Kyte of Oracle.
We had a requirement in house just recently to produce a small app that would be used by appropriately authorised systems administrators to populate a couple of tables with small amounts of lookup data for a new system.
Using HTMLDB we produced an app that
1. Authenticates the user from the Enterprise wide LDAP compliant directory.
2. Provides a consistent look and feel using CSS.
3. Uses bind variables throughout for scalability.
4. Could be hosted in an enterprise portal if necessary.
In less than 2 days development time by a DBA (not a developer).
Other fetures that htmldb makes available almost on a pick and choose basis are
1. Full text searching.
2. SSO Integration.
3. Workflow.
4. Email Notifications.
5. File Upload/Download to database BLOB columns.
6. SVG Charting.
Finally, though the product is available on the 10g Companion CD (available FOC from OTN). It is supported (and works just fine) from 9.2.0.3 onwards - so you don't need to migrate a production database to take advantage of it.
0 Comments:
Post a Comment
