Espresso Logic Launches New Support to Create RESTful APIs from Stored Procedures to Build Mobile Apps
Wednesday, March 12, 2014
Espresso Logic has announced new features that enable developers to quickly create secure RESTful APIs for stored procedures. Using the new functionality, developers can create mobile applications that leverage a company’s investment in stored procedures.
The Espresso Designer service exposes stored procedures as REST/JSON resources while the supporting infrastructure is handled by the Espresso service. Developers decide which stored procedures to expose along with access control rules for the APIs on a role-oriented basis.
Espresso provides fast RESTful API to databases along with role-based row and column security and logic, and is available in the cloud or on-premise. The Espresso platform is a complete scalable middle-tier for mobile applications and enables developers to connect to SQL data and virtually any other database SaaS or computing application via a standard REST interface.
New Feature Overview
The new stored procedure support is virtually automatic. Stored procedures are cataloged when Espresso introspects the schema. Security is overlaid on the stored procedures just as they are on tables and other REST endpoints.
New features include the ability to call stored procedures with any number or type of parameters (input and output) including multiple result sets and REF CURSORs. Espresso now supports SQL Server 2005 or above, Oracle Database version 10.2 and higher, MySQL Database version 5.0 and higher and Windows Azure SQL. Also, results are now returned in a discoverable JSON structure.
Version 1.2 of Espresso with support for stored procedures and many usability enhancements is available now as a shared server version for free, with dedicated server starting at $50 per month. Registration is available here.
Read more: http://www.espressologic.com/features-rest-api/
Become a subscriber of App Developer Magazine for just $5.99 a month and take advantage of all these perks.
MEMBERS GET ACCESS TO
- - Exclusive content from leaders in the industry
- - Q&A articles from industry leaders
- - Tips and tricks from the most successful developers weekly
- - Monthly issues, including all 90+ back-issues since 2012
- - Event discounts and early-bird signups
- - Gain insight from top achievers in the app store
- - Learn what tools to use, what SDK's to use, and more