Blog‎ > ‎

Little ODBC SQL JSON RPC web service

posted Dec 13, 2011, 9:49 AM by Sami Lehtinen   [ updated Dec 13, 2011, 9:54 AM ]
I had a little problem, I had to transfer some data frequently from proprietary ODBC / SQL database to another application. Solution? Extremely light SQL / JSON Web Service RPC module.

Now I can just send authenticated HTTPS request containing SQL query to server and I'll get results back in one JSON message. Service could be developed further to provide writing to database and transactions. Currently all actions except SELECT are purposefully prevented.

Getting everything done took about half an hour.