1. Espresso Logic Launches New Support to Create RESTful APIs from Stored Procedures to Build Mobile Apps
3/12/2014 11:36:04 AM
Espresso Logic Launches New Support to Create RESTful APIs from Stored Procedures to Build Mobile Apps
RESTful API, Espresso Logic, backend as a service, BaaS, SQL data, SaaS, REST interface
App Developer Magazine

Espresso Logic Launches New Support to Create RESTful APIs from Stored Procedures to Build Mobile Apps

Wednesday, March 12, 2014

Stuart Parkerson Stuart Parkerson

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.

Launched in November 2013, Espresso made available its reactive logic programming-based database backend as a service to enable creation of enterprise class RESTful APIs to databases for use in mobile and web application development. The service provides the flexibility of server side JavaScript along with the expressive power of Reactive Programming to reduce development backlog for enterprise apps.

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/

Subscribe to App Developer Magazine

Become a subscriber of App Developer Magazine for just $5.99 a month and take advantage of all these perks.


  • - 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

    Subscribe here