valhuber avatar image
valhuber posted

Criteria for Selecting Your REST Services Platform

In the first two blogs in this series, we tackled the issue of how REST is a solution to a connected enterprise followed by discussions on What is REST. Then we discussed why use REST for database access. The last blog in this series addressed the following two key issues:

In this blog, we summarize the criteria for selecting your REST services platform ? the criteria that was developed in the last blog. We also present how Espresso Logic meets this criteria and this document should serve as a template for you as you embark on vendor selection for REST services platform for your backend for mobile and web applications.

Requirements for REST Platform Espresso Logic Other Vendors
Implementation Services
REST service & database in the cloud Can connect to your database or provide a cloud database
REST service in the cloud, database on the premise Recommend a reverse SSH tunnel
REST service and database on the premise Offered as a VM Ware appliance
Database Services mapped to REST
Tables Yes
Views Yes
Stored Procedures Yes
Databases Supported MySQL, SQL Server, Azure, Oracle
Support for all REST functions
POST/PUT/DELETE for all operations Yes
Built-in Enterprise Class Features
Automatic pagination Yes
Filtering and ordering Yes
Optimistic locking Yes
Custom REST endpoints
Aliasing column names Yes
Automated SQL handling Yes
Projection ? selecting fields to display Yes
Build resource endpoints from external services Yes
Security and Access Control
Default table level security Yes
Role based security derived from your Authentication Yes
Assign privileges by REST endpoints Yes
Row and column level access Yes
API Logic
JavaScript object model Yes
Reactive Rules Yes
Built-in testing and debugging
Interactive REST Lab Yes
Ability to log logic execution Yes
Interactive debugger Yes
Other Service Integration
Able to call any web service Yes
10 |600

Up to 8 attachments (including images) can be used with a maximum of 1.0 MiB each and 10.0 MiB total.



valhuber contributed to this article