restSQL
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


Learning Android Online
24/08/2016

With Android clearly the dominant app market there's obvious interest in learning about it, both on the part of beginners and those who already program in one of more languages. Joining a MOOC seems a [ ... ]



Chrome Apps No Longer On Windows,Mac And Linux
24/08/2016

Google has just announced that Chrome apps are no longer going to be supported on Windows, Mac or Linux. This is a source of some confusion, but it doesn't mean the end of Chrome apps running in Chrom [ ... ]


More News

Last Updated ( Thursday, 29 September 2011 )
 
 

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