This document summarizes a webinar about using Espresso Logic to create a reactive REST API for SQL database access. The webinar demonstrated how to build a RESTful API from database tables, test the API, add filtering and sorting, create multi-table endpoints, call the API from mobile and web clients, implement authentication and authorization with row- and column-level security. The total demonstration time was 15 minutes. Espresso Logic creates a complete middleware layer to connect mobile and web applications to backend SQL data through REST APIs.
1 of 11
Download to read offline
More Related Content
Webinar Building RESTful API for databases
1. Espresso Logic Webinar Series
Reactive Service for SQL Data
_________________________________________________________________________________________
2. The Problem Todays Reality
Sure a
few
weeks
We need a
simple mobile
app... spec is
only 1 page
Umm.. I was
thinking a
few hours
3. Agenda
Current situation
Espresso overview
Demo
Building RESTful API
Test API
Call API from clients
Security
Questions
際際滷 3
8. Recap this is what you just watched
Connected to a database to create RESTful API from tables
Tested the API with the REST Lab
Added parameters for filtering and sorting
Create multi-table REST endpoint by point and click
Showed iOS and JavaScript API calls to Espresso Server
Picked up roles from authentication system
Added row and column level security by role
---Page 8
>
Total time with discussion 15 minutes
9. Mobile to SQL Data with Espresso
RESTful
Espresso Server(s)
Espresso Server
Access Control
Business Logic