When building any type of apps the most basic actions one should be able to do are CRUD operations. CRUD stands for Create, Read, Update, and Delete and the first and most basic function is the GET function which a an ability to display a list of records from the database. 

Listing records

Teseron STUDIO makes it super easy to do this by using the API URL that is generated for each table if the table hase API enabled. 

How to set up a GET function for Bubble.io: 

Filtering Records

When it comes to data manipulation one of the most basic concepts is data filtering. Here Teseron STUDIO again does a very good job by simplifying this process to the core. 

By using our API builder you can set up all sorts of filters and filter parameters are created for you directly in the API URL which means that in bubble.io example we can directly access this parameter an use it on the repeating group to filter the data. 

How to setup  a full text filter using the bubble.ios input field: 

Includes – relational database – display data from more tables in one API call

Most of the apps are leveraging relational database which means that the data can have relationships between each other. These relationships can have 3 forms:

• One – 2 – One
• One – 2 – Many
• Many – 2 – Many

In Teseron STUDIO it is very convenient not only to set up the database this way, but also to work with it via our API by using our “Include” function.

In the following example we are showcasing how to include to a list of books the names of authors and labels of genre associated with the list of displayed books. 

With Teseron STUDIO is very simple also to select which Data Fields we want to expose to each API which is a powerful way of optimizing for performance, but also from the security perspective.

How to include data from another table using the include function: