DEV Community

Cover image for SQL queries through REST available now!
Nicolas Penot for Siodb

Posted on

SQL queries through REST available now!

curl -X POST \
-d '[
      {
         "EMAIL" : "dwain.jonhson@gmail.com",
         "FIRST_NAME" : "Dwain",
         "LAST_NAME" : "Jonhson",
         "USERNAME" : "dwainjonhson"
      }
]' \
https://${USER}:${TOKEN}@localhost:50443/database/my_app/tables/users/rows
Enter fullscreen mode Exit fullscreen mode
curl https://${USER}:${TOKEN}@localhost:50443/query?q='select * from my_app.users;'
Enter fullscreen mode Exit fullscreen mode
{
   "status" : 200,
   "rows" : [
      {
         "TRID" : 1,
         "EMAIL" : "jason.statham@gmail.com",
         "FIRST_NAME" : "Jason",
         "LAST_NAME" : "Statham",
         "USERNAME" : "jasonstatham"
      },
      {
         "TRID" : 2,
         "EMAIL" : "dwain.jonhson@gmail.com",
         "FIRST_NAME" : "Dwain",
         "LAST_NAME" : "Jonhson",
         "USERNAME" : "dwainjonhson"
      }
   ]
}
Enter fullscreen mode Exit fullscreen mode
siocli> select * from my_app.users;

TRID   EMAIL                       FIRST_NAME     LAST_NAME     USERNAME
------ --------------------------- -------------- ------------- --------------
     1 jason.statham@gmail.com     Jason          Statham       jasonstatham
     2 dwain.jonhson@gmail.com     Dwain          Jonhson       dwainjonhson

Row(s): 2

Elapsed time: 15 ms.
Enter fullscreen mode Exit fullscreen mode

Available in the cloud => https://datahub.siodb.io

Start your next app with Siodb, 100% encrypted, 100% automated.
Implemented in few minutes through REST API.

P.S. Let me know your feedback :)

Discussion (0)