In this chapter, we will show how to create a data source for your business application.
Data source can be a relational database table or REST service.
Here's the diagram of relationship between basic components of a simple one table, one CRUD form, and one grid business application.
So, let's go ahead and create a table.
this
-- Our DDL for this guideCREATE TABLE x_person(person_id integer NOT NULL, -- sequential primary keyname character varying(50) NOT NULL,surname character varying(50) NOT NULL,age integer,CONSTRAINT pk_person PRIMARY KEY (person_id) -- primary key definition);CREATE sequence seq_x_person;
here: Pull Table from Database
You have created your database table for your application!
We will use JSONPlaceholder for this guide. See https://jsonplaceholder.typicode.com/ for more detail.
You have configured a REST service!
Next we will build user interface for our application.