BT

New Early adopter or innovator? InfoQ has been working on some new features for you. Learn more

Espresso Logic DBaaS Now Wraps SQL Stored Procedures in RESTful APIs

| by Abel Avram on Mar 14, 2014. Estimated reading time: 1 minute |

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.

Rate this Article

Adoption Stage
Style

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

Login to InfoQ to interact with what matters most to you.


Recover your password...

Follow

Follow your favorite topics and editors

Quick overview of most important highlights in the industry and on the site.

Like

More signal, less noise

Build your own feed by choosing topics you want to read about and editors you want to hear from.

Notifications

Stay up-to-date

Set up your notifications and dont miss out on content that matters to you

BT