CYPEX allows multiple developers to work on different applications for the same user Role to avoid conflicts in collaborative development. Since each application is tied to a specific role with access to particular database queries, developers can build separate applications independently.
The Merge Applications feature enables developers/administrators to combine multiple applications built for the same Role into a single, unified application. This process merges all app definitions and concatenates pages, reports, and menu items, ensuring that the final merged application includes all elements from the individual applications.
The CYPEX PDF Reporting Feature enables users to generate high-quality PDF reports directly from CYPEX applications. Users can choose between interactive reports, which mirror the live application view, and static reports, which use LaTeX for structured and large-scale data presentation. Reports can be saved locally or stored in the database for easy access through the Admin Panel.
After successfully creating this first application, it’s time to move forward and dive into workflows. The goal of the next application is to create a TODO list which can be modified by end users.
Here’s some sample data:
BEGIN;
CREATE ROLE todo_owner LOGIN;
GRANT todo_owner TO authenticator;
CREATE SCHEMA todo AUTHORIZATION todo_owner;
CREATE TABLE todo.t_todo
(
id serial PRIMARY KEY,
tstamp date DEFAULT now(),
todo_item text NOT NULL,
status text
);
INSERT INTO todo.t_todo (tstamp, todo_item, status)
VALUES
('2021-03-04',' Do the laundry', 'created'),
('2021-03-06',' Cut the grass', 'accepted'),
('2021-03-09',' Eat a steak', 'success'),
('2021-03-12',' Slaughter a chicken', 'rejected');
COMMIT;
For the sake of simplicity, the TODO list consists of just one table. What is noteworthy here is the last column: The status informs us about the state of an object. A task might have succeeded, failed or it might have been rejected.
CYPEX supports the integration of external images. Add an image element to your desired page and click on the element for configuration: You may add the desired link to the image, resize the element and define whether the picture can be resized or stretched.
CYPEX supports GIS (Geographical Information Systems) data. However, in order to use GIS data in CYPEX, there are some things which have to be taken into consideration.
Let’s take a look at a sample table:
cypex=# CREATE EXTENSION postgis;
CREATE EXTENSION
cypex=# CREATE TABLE t_area (
id serial PRIMARY KEY,
name text,
g geometry
);
CREATE TABLE
The keys to GIS data are the “geometry” and “geography” columns. These aren’t directly visible in a web frontend. Let’s take a look at how default queries are generated:
CYPEX is in charge of handling everything from rapid prototyping to full application development.
When building a full application, it can become necessary to schedule jobs. CYPEX offers the means to make that happen using pg_timetable, a job scheduler developed by CYBERTEC. It’s able to handle all kinds of job execution tasks.
CYPEX may be used to store highly critical data. In those cases, it’s necessary to track changes made to an entity. However, it’s not only about critical data - sometimes you simply want to debug an application and check what’s going on.
Enabling history tracking is easy: Go to the database setup page, and select the entity you want to track. Use the “Auditing” button to control this behavior.
CYPEX allows superusers to make immediate changes. The edit-mode is only accessible to superusers.
However, in some cases you might want to change the application without actually using it immediately. To achieve live editing without harming productive users currently working with the application, you’ll need to use release management. Before we dig into that, it’s worth pointing out that CYPEX actually allows you to revert to a previous version of your application.
