We've developped an Open Source Client AND Server RESTfull framework, using JSON for the data exchange.
You've got a whole ORM framework, with remote or local direct access, accessible through HTTP/1.1, named pipes or Windows GDI messages.
The remote database is accessed via an automated RESTful mechanism, and you can easily implement additional Server-side REST-compatible services, if the direct database REST URI are not sufficient for your purpose.
It compiles from Delphi 6 up to Delphi XE.
It's fully Unicode compliant on all these platforms (it uses UTF-8 encoding internaly).
The Synopse SQLite3 database Framework was designed in accordance with Fielding's REST architectural style without using HTTP and without interacting with the World Wide Web. Such Systems which follow REST principles are often referred to as "RESTful". Optionaly, the Framework is able to serve standard HTTP/1.1 pages over the Internet (by using the SQLite3Http unit and the TSQLite3HttpServer and TSQLite3HttpClient classes), in an embedded low resource and fast HTTP server.
The standard RESTful methods are implemented:
- GET to list the members of the collection;
- PUT to update a member of the collection;
- POST to create a new entry in the collection;
- DELETE to delete a member of the collection.
The following methods were added to the standard REST definition, for locking individual records and for handling database transactions (which speed up database process):
- LOCK to lock a member of the collection;
- UNLOCK to unlock a member of the collection;
- BEGIN to initiate a transaction;
- END to commit a transaction;
- ABORT to rollback a transaction.
About our REST implementation, see http://synopse.info/forum/viewtopic.php?pid=16#p16