CYPEX is CYBERTEC’s PostgreSQL Application Platform: the schema drives the API,
access model, and application UI. This section gets you from a fresh deployment
to a first working app. Follow the path below — first-run admin setup, then
sample applications.
Info
Upgrading an existing deployment? Use the
Upgrade to v2.0.0
operator guide instead of a fresh install.
1. First-run setup
After the first login, configure the administration panel: organizations,
access, and the steps that lead to launching an application.
After this brief introduction, it’s time to create your first sample applications. We’ll show you a set of basic apps which will guide you through the process. Every application will allow you to dive deeper into CYPEX and to learn more about its features.
Let’s dive headlong into the first CYPEX application. The goal is to create a form, as well as a dashboard showing a report.
Step 1: Creating an SQL model
The first step is to create an SQL model. In our example, we’ll create a “sales” schema with couple of tables, initially populated with some of sample data:
