Release History
Email notification of new releases (both feature and bug fixes): Subscribe
0.8.6 - March 5, 2013
The release fixes two defects (GitHub issue 32, issue 35) and adds a Framework Developer Quick Start.
0.8.5 - Dec 16, 2012
The release adds the ability to reload a SQL Resource definition on demand (/restsql/conf/reload/{resName}) without a webapp restart. It also adds a mechanism to retrieve the SQL Resource's definition (/restsql/conf/definition/{resName}) as well as the framework's understanding of it's metadata (/restsql/conf/metadata/{resName}). See the HTTP API Reference.
0.8.4 - Nov 4, 2012
The release restores support for Firefox, which was broken in release 0.8 with the JSON encoding enhancement. Firefox appends ;charset=UTF-8 to the Content-Type header when using XMLHttpRequest.setContentType() (GitHub issue 27).
0.8.3 - Oct 25, 2012
The release enables numeric, string and date column values matching a set of values in queries. See In Operator for more details. Additionally the release fixes a column aliasing (GitHub issue 24) and a JSON serialization issue (GitHub issue 25).
0.8.2 - Oct 9, 2012
The release enables provides configurability of the Cache-Control response header at a system level and per-SQL resource override. See HTTP Configuration for more details. Additionally the release fixes JSON encoding, removing the improper quoting for these numeric and boolean values (GitHub issue 18).
0.8.1 - Sep 29, 2012
The release enables <, <=, > and >= operators for numeric, string and date/time parameters on read requests. See Comparison Operators for an overview and the GET by Query reference for an example.
0.8 - July 17, 2012
The release enables JSON encoding for an HTTP API request and response entity (body). restSQL previously only supported XML encoding. See Media Types for an overview. All HTTP API reference documentation has also been updated to include JSON encoding instructions and examples.
The release also enables SQL functions in resource columns (MySQL only). Lastly it adds escaping for special characters values in XML encoding.
0.7.4 - Feb 19, 2012
The release fixes handling date, datetime, time and timestamp data types (GitHub issue 7). The SDK now includes example code using the Java API.
0.7.3 - Jan 16, 2012
SQL Resources in previous releases were constrained to a maximum of one parent and one child extension. 0.7.3 enables an SQL Resource to join an abitrary number of tables to create a flat or hierarchical application-specific view. See the release notes for more detail.
0.7.2 - Nov 19, 2011
SQL resource namespaces may be organized into arbitrary-depth directories. The directory path is converted into dotted notation, following the Java package concept.
0.7.1 - Oct 23, 2011
Aliases may be defined for SQL Resource parent and child tables. The alias instead of the table names appear as XML element names of request and response bodies.
0.7 - Sept 15, 2011
The release adds resource authorization capability, ensuring users only access the SQL Resources and methods appropriate to their assigned role(s). It uses standard HTTP Basic or Digest authentication and standard JEE web app declarative security mechanisms. Credentials and role assignments are provided by a standard Realm plugin, which could be file-, RDBMS- or LDAP-based. Role to SQL Resource and request type assignments are provided via a simple configuration file.
0.6 - July 15, 2011
The release extends database interoperability from MySQL to PostgreSQL. It also includes extension mechanisms to easily develop support for other database engines. The release additionally was tested with multiple application servers to ensure interoperability with any standard JEE container.