A little RESTful ODBC SQL JSON RPC bridge web service

Post date: Dec 13, 2011 5:49:05 PM

I had a little problem, I had to transfer some data frequently from proprietary ODBC / SQL database to another application and platform. Solution? Extremely light SQL / JSON Web Service RPC bridge module.

Now I can just send authenticated HTTPS request containing SQL query to the server and I'll get results back in one JSON formatted response. Service could be developed further to provide writing to database and transactions.

I got all this done in an half an hour, even if some others claimed it's hard to develop such RESTful Web API. Now I've got the necessary API which is very versatile and allows access whole database, all tables and all data. Of course within the limits of the permissions of the user account the queries are made under.