BT
x Your opinion matters! Please fill in the InfoQ Survey about your reading habits!

Espresso Logic DBaaS Now Wraps SQL Stored Procedures in RESTful APIs

by Abel Avram on Mar 14, 2014 |

Espresso Logic has added RESTful endpoints for SQL stored procedures to their DBaaS service.

Espresso Logic provides for enterprises a SQL DBaaS service as a RESTful API by analyzing the database’s schema and creating REST endpoints for each table, offering filtering, sorting, authentication, pagination, optimistic locking, etc. Espresso has recently announced the ability to automatically generate APIs for database’s stored procedures, exposing procedures as REST resources, the output of such a call being provided as JSON. Interaction with the DBaaS is done via Espresso Designer (account required), which enables role-based secured access to all resources. To work with the database, developers can avoid using SQL queries, writing instead business logic using JavaScript in a reactive programming environment.

Getting the details of the get_employee stored procedure is done using GET on the following URL (example):

http://houston.d.espressologic.com/rest/abl/demo/v1/@procedures/get_employee

the output being:

{
  "@metadata": {
    "href": "http://houston.d.espressologic.com/rest/abl/demo/v1/@procedures/get_employee"
  },
  "name": "get_employee",
  "remarks": "given an employee id and a number 'plus_one', adds one to the number and returns the employee info as well as picture, voice and icon",
  "args": [
    {
      "name": "given_employee_id",
      "type": "BIGINT",
      "direction": "IN"
    },
    {
      "name": "plus_one",
      "type": "BIGINT",
      "direction": "IN_OUT"
    }
  ]
}

According to R. Paul Singh, Espresso CEO and co-founder, Espresso Logic provides its service for the following database configurations:

  • We connect to user's own database in their premise. In order to do this, our users generally use reverse SSH tunnel for security reasons
  • We connect to various cloud database services including Amazon RDS (MySQL, SQL Server and Oracle) and Azure SQL using the appropriate APIs
  • For users that want us to spin a new database for them, we can offer MySQL as that option in AWS today with more options being added in the near future. However, this feature is currently in beta and not offered in the designer.

The Espresso service resides on AWS but the company is “planning to add other cloud services in the near future with Microsoft Azure as the next one under development,“ said Singh. They also offer an appliance for enterprises that want to run the service on their own premises.

Hello stranger!

You need to Register an InfoQ account or or login to post comments. But there's so much more behind being registered.

Get the most out of the InfoQ experience.

Tell us what you think

Allowed html: a,b,br,blockquote,i,li,pre,u,ul,p

Email me replies to any of my messages in this thread
Community comments

Allowed html: a,b,br,blockquote,i,li,pre,u,ul,p

Email me replies to any of my messages in this thread

Allowed html: a,b,br,blockquote,i,li,pre,u,ul,p

Email me replies to any of my messages in this thread

Discuss

Educational Content

General Feedback
Bugs
Advertising
Editorial
InfoQ.com and all content copyright © 2006-2014 C4Media Inc. InfoQ.com hosted at Contegix, the best ISP we've ever worked with.
Privacy policy
BT