Version 0.6 of restSQL, an open-source persistence framework, was released on July 15. 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.
See http://restsql.org for an overview, developer documentation and binary distributions of the framework and the SDK. The source code is licensed under MIT and hosted on github.
restSQL is a very unconventional, ultra-lightweight data access layer. For many applications, conventional ORM is heavyweight and inflexible, and conventional Web Services (WSDL/SOAP) are cumbersome. restSQL substantially lightens the middle-tier. It is targeted at the 80% of data access that is basic CRUD (Create-Read-Update-Delete), making it faster and simpler to develop distributed applications.
restSQL is not an object-oriented view of the database. It presents flat or hierarchical "views" of relational database tables. These views are query-able and updatable through a simple REST-based HTTP or Java API. The HTTP interface is based on REST principles, which use HTTP’s built-in features, rather than abstracting away from them.
restSQL - Trim your middle!
This post has been migrated from a previous version of the PostgreSQL website. We apologise for any formatting issues caused by the migration.