Facilitating the spread of knowledge and innovation in professional software development



Choose your language

InfoQ Homepage News Espresso Logic DBaaS Now Wraps SQL Stored Procedures in RESTful APIs

Espresso Logic DBaaS Now Wraps SQL Stored Procedures in RESTful APIs


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):

the output being:

  "@metadata": {
    "href": ""
  "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.

We need your feedback

How might we improve InfoQ for you

Thank you for being an InfoQ reader.

Each year, we seek feedback from our readers to help us improve InfoQ. Would you mind spending 2 minutes to share your feedback in our short survey? Your feedback will directly help us continually evolve how we support you.

Take the Survey

Rate this Article


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.

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

Community comments

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

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


Is your profile up-to-date? Please take a moment to review and update.

Note: If updating/changing your email, a validation request will be sent

Company name:
Company role:
Company size:
You will be sent an email to validate the new email address. This pop-up will close itself in a few moments.