Docs‎ > ‎Logic Designer‎ > ‎Database‎ > ‎

Codenvy DataSource

<<< Under Construction - please ignore >>>

Espresso Logic is the fastest, easiest way to connect your application to SQL database, specifically a RESTful service with JSON encoding.  Supported databases include MySql, Sql/Server and Oracle, on-premise or in the cloud.

RESTful services can be accessed in any Codenvy language.  There is a growing list of samples you can explore across multiple languages.  

This page provides a brief summary of Espresso, and guides you through how to use it - from sign-up, to API creation, to accessing the API.

What is Espresso

Like Codenvy, Espresso is a service - you don't have to install or configure anything.  The service is provided automatically when you sign up.  As summarized in this short tour, use the Espresso Logic Designer in your Browser to define your API, declare business logic applied to POST, PUT and DELETE requests, and define row/column level security.

In this quick start, we'll provide a brief overview of Creating your API.  The Live Demo is a great start - you'll be introduced to Reactive Logic in solving a real problem in just 10 minutes.  For more information, including how to define Logic and Security, see the Getting Started Guide.  


Signup

Click here to create an Espresso Account.  Or, you can run the Live Demo, which enables you to explore a complete small system in a separately launched Codeenvy workspace. 

There are three types of services but most likely you have chosen one of the following alternatives:
  1. Evaluation – This is a free, shared version and only provides partial JavaScript logic

  2. Developer – This is a paying version with dedicated hardware. It has no limitation on the use of JavaScript logic


Creating an Espresso Datasource API

To creating your RESTful API, you Create a Project (which defines your URL), Register your Database (creates a default API with a REST resource for each Base Table), and optionally define a Custom Multi-table API with joins, projections etc.  These are shown below.

Creating a Project

After you sign up for Espresso, you can access the Logic Designer, shown below.  To create a project:
  1. Access the Home screen (if you're not already there)

  2. Click Create New Project

  3. Specify the Project Name



Registering your database

You will then see a screen like this, where you provide your database URL:


When you successfully complete this step, your API is ready:
  1. All of your Base Tables are available as REST resources (per Security)

  2. Your REST APIs are described here

  3. Use the REST Lab to test and verify your API.

Optionally, Define a Custom API

You can create a multi-table API that joins desired data by defining a REST Resource as described here.


Using the Espresso Datasource API

The Logic Designer provides a quick reference for your API.

Logic and Security

This quick reference has focused on how to create an API you can use from your Codenvy application.  Much of the value of Espresso lies in simple and powerful techniques for defining Logic and Security that add semantics to your API.