Published by cce on 2011-08-31
The theme for HTSQL 2.2 is “Form Applications”. Our focus for this release will be on functionality gaps that hinder use of HTSQL by developers to create Javascript based “CRUD” applications.
This release will include plugin configuration, schema introspection, custom commands, CRUD operations, and general support for Javascript applications such as HTRAF Forms.
This roadmap has 5 milestones.
A secondary focus for this release, as time permits, will be adding usability improvements such as better error handling and adding new data types or functions.
The first milestone for HTSQL 2.2 will support configuration for plugins and a mechanism to obtain metadata from a Javascript application. This work is expected to enable the construction of a visual query builder and other complementary tools. The milestone includes several deliverables:
One immediate use of this deliverable will be a sample plugin to enable SQLAlchemy users to use their model configuration to specify primary and foreign key constraints.
This milestone create a way to define custom commands and introspect the structure of an HTSQL query. It is expected that this deliverable would enable client side Javascript to dynamically build a form based on a query.
This milestone is needed to build forms dynamically.
This milestone introduces a mechanism to identify individual records via primary key values without requiring the key column names be listed. This simplifies user interface construction and enables record-based commands to be added. This includes:
This milestone is a requirement for basic CRUD operations and enables single-record access.
This milestone will be an optional plugin with a full set of record-based operations for INSERT, UPDATE and DELETE. These additional commands will permit CRUD applications to be written on top of HTSQL that do more than query the database.
This first pass of CRUD operations will only be available to databases that support RETURNING.
This milestone will address how to pass nested data sets to the server and introduce ways to communicate between commands.
This milestone will enable sophisticated backend processing and master/detail forms.
This is the final milestone of the release and will fill gaps identified by users building applications using HTSQL. In particular, it may include support for custom catalog extensions so that form builders can augment meta-data with configured screen labels. It will probably also include query manipulation commands, such as stripping selectors or replacing a filter.
This deliverable will likely be modified heavily based on what’s needed to deliver HTRAF Forms.