Latest News¶
HTSQL 2.2.1 is released¶
Published by cce on 2011-12-15
The final release for 2.2 series is now available. This release was focused on usability improvements, metadata functionality gaps, and better Python integration. In this release we include:
- support for configuration files and plugin parameters
- a web-based query editor with highlighting & auto-completion (tweak.shell)
- a meta database for querying tables, columns and links (tweak.meta)
- integration with Django and SQLAlchemy (tweak.django, tweak.sqlalchemy)
- an API for making parameterized queries from Python applications
- improved database introspection, error messages, and usability fixes
- binary packages for Debian and RHEL
We also added a tweak.override plugin to provide granular control over the introspected database catalog; this plugin allows you to:
- restrict access to particular tables and columns
- provide missing unique and foreign key constraints
- change table, column and link labels
- define calculated fields and table methods
HTSQL 2.2.0rc1 is released¶
Published by xi on 2011-11-22
The first release candidate for the 2.2 release is now available. The primary change from the last beta is the introduction of a new tweak.override addon which provides detailed control over the database metadata:
- restrict access to particular tables and columns
- configure missing unique and foreign keys
- change table, column and link labels
- define calculated fields
The other major change is auto completion of table, column and link names in the htsql-ctl shell and the web-based editor. We also added a @ scope reset operator. Finally, we now have binary packages for Debian and RedHat GNU/Linux systems.
Discussion of JSON/CSV Headers¶
Published by cce on 2011-10-01
In recent months, we’ve added hierarchical headers to the text formatter, the HTML formatter and the custom table formatter found in the HTSQL command shell. What lags behind is the JSON formatter. This is a discussion of what sort of headers we wish for JSON/CSV outputs.
Discussion on Location¶
Published by cce on 2011-08-28
In htsql, we would like a short-hand notation to locate a given row in a table without having to mention the primary key columns. This is especially important for insert, update and delete operations.
HTSQL 2.2.0b1 is released¶
Published by cce on 2011-09-20
The first beta of the 2.2 release is now available.
The new release brings two major features:
- a mechanism to query HTSQL’s system catalog
- a query editor for the web /w syntax highlighting
HTSQL 2.2 Roadmap¶
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.
HTSQL 2.1.1 is released¶
Published by cce on 2011-08-30
This is the final release of HTSQL 2.1 aka “Query Power”. This release focuses on supporting analytical queries with projections and calculated attributes.