Version 0.7 of restSQL, an open-source persistence framework, was released on September 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.
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.