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.