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.
Getting the details of the
get_employee stored procedure is done using
GET on the following URL (example):
the output being:
"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",
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.