Watch, Follow, &
Connect with Us

For forums, blogs and more please visit our
Developer Tools Community.


Welcome, Guest
Guest Settings
Help

Thread: ANN: Open Source SynDBRemote for SQL execution via HTTP remote access



Permlink Replies: 0
Arnaud BOUCHEZ

Posts: 143
Registered: 2/17/02
ANN: Open Source SynDBRemote for SQL execution via HTTP remote access
Click to report abuse...   Click to reply to this thread Reply
  Posted: Nov 18, 2014 9:24 AM
The newly introduced Open Source SynDBRemote.pas unit allows you to create database applications that perform SQL operations on a remote HTTP server, instead of a database server.

Note that even if this is part of our mORMot framework, this feature is implemented outside the ORM/SOA scope, in a stand-alone unit, only tied to our SynDB.pas direct RDBMS access layer.
For instance, you can change any local SQLite3 instance into a client-server RDBMS, in one line of code, or using our SynDBExplorer tool.
Or leverage an existing Delphi rich client application to use HTTP instead of direct DB connection for executing its SQL statements.

The transmission protocol uses an optimized binary format, which is compressed and digitally signed on both ends, and the remote user authentication will be performed via a challenge validation scheme.
It can by-pass DB.pas and DBExpress/FireDAC, for even further performance (with direct ODBC, OleDB, Oracle or ZDBC access).
At writing, it supports array binding, for bulk insert. At reading, data is compressed and optionally directly put into TDataset binary buffers.
You can also publish your server over HTTPS, if needed.

Works with Delphi 6 up to XE7 - Unicode even before Delphi 2009.
Under Win32/Win64 the HTTP server is the very stable http.sys API in kernel mode.
Compiles and run also with FPC, on both Windows and Linux.

Take a look at this blog article
http://blog.synopse.info/post/2014/11/18/HTTP-remote-access-for-SynDB-SQL-execution

The high-level documentation is available at
http://synopse.info/files/html/Synopse%20mORMot%20Framework%20SAD%201.18.html#TITL_131
and the API at http://synopse.info/files/html/api-1.18/SynDBRemote.html

And the forum post is http://synopse.info/forum/viewtopic.php?id=2178

Feedback is welcome!
Legend
Helpful Answer (5 pts)
Correct Answer (10 pts)

Server Response from: ETNAJIVE02