restSQL
Written by Kay Ewbank   
Thursday, 29 September 2011

restSQL, a new version of an open-source ultra-lightweight data access layer has just been released with better management of user roles.

One of the drawbacks of writing applications that need to use data is that as soon as you add in data management, you get into memory-hungry, heavyweight technology. A new version of an open-source ultra-lightweight data access layer has just been released with better management of user roles.

 

 

restsql

 

 

 

 

restSQL is aimed at applications that need relatively simple data access; so long as your app doesn't want to do anything more than create/read/update/delete (CRUD), restSQL has the facilities you need. It acts as a persistence framework in the middle tier of the standard three tier architecture of client, application server and database, and can also be embedded in any middle-tier as a Java library.

The thinking behind restSQL is that for many apps, conventional ORM (object relational-mapping tools) are overkill, with objects and classes for all possible occasions and situations, whereas in most cases the requirements are pretty limited.

restSQL is just a SQL generator with Java and HTTP APIs. It uses a simple RESTful HTTP API with XML or JSON serialization, and gives you either flat or hierarchical views of relational database tables. Access is managed through database views called SQL Resources that you can query and update. It doesn't do any object-relational mapping, and there’s no object query language.

You can either have your client app connect directly to the restSQL engine using the HTTP API, or have services that use a Java API.

The new release adds resource authorization so that users of your apps are limited to the SQL resources and methods for which their roles have authorized access. You provide the user credentials and role assignments using a standard Realm plug in. This can be RDBMS-based, LDAP-based, or file-based.

You can find out more at http://restsql.org, where you’ll find an overview, documentation, and can download the framework and SDK.

 

restsqllogo

 

To be informed about new articles on I Programmer, subscribe to the RSS feed, follow us on Twitter or Facebook or sign up for our weekly newsletter.

Banner


Arduino And More Comes To MoMA
09/11/2014

Does an Arduino, even if we think it is cool, belong as a MoMA exhibit? Is there more art in technology than we think?



EF7 Drops XML Modeling Favors Code First
27/10/2014

Microsoft is dropping some ways of modeling data in the next version of Entity Framework (EF) to make the database tool more lightweight.


More News

Last Updated ( Thursday, 29 September 2011 )
 
 

   
RSS feed of news items only
I Programmer News
Copyright © 2014 i-programmer.info. All Rights Reserved.
Joomla! is Free Software released under the GNU/GPL License.