3.4.1 CYPEX Database Section - Workflow Overview | CYBERTEC PostgreSQL Rapid App Dev

A workflow is a description of a process made up of states and the transitions between those states. A state is a valid entry in a table. In CYPEX, we only allow column entries that correspond to valid states. The same is true for state changes (transitions). PostgreSQL uses triggers as gatekeepers. The triggers allow only UPDATE statements that satisfy the workflow to get through. This guarantees that data cannot escape the workflow in any way.

Limiting UPDATE statements according to the workflow ensures data integrity as well as data quality at all levels.

CYPEX associates state changes with roles. Why is that important? Let’s take a look at a practical example: Suppose person A applies for a job. Technically this means that this person can INSERT his application. It will then be in state “pending”. In case pending can have a state change from “pending” to “pending” we generally call it “edit”. Some other person might then approve the application or not.

GUI prediction:

When CYPEX generates/ predicts the GUI, it takes existing permissions and translates them to pages. Depending on who you are, you will see a different type of application based on the very same data model.

This kind of behavior is important: Just imagine a web shop. The backend application is totally different from the frontend side (which might just use the API and not utilize the CYPEX GUI builder all together). | Get started developing your own low-code apps with CYPEX. Build scalable, secure enterprise apps with flexible features. Respond instantly to customer feedback, easily adjust to changes.

CYPEX Academy: https://www.cybertec-postgresql.com/en/our-products/cypex-online-academy/

Find out more about CYPEX: https://www.cybertec-postgresql.com/en/products/cypex/

Download the CYPEX product folder: https://www.cybertec-postgresql.com/wp-content/uploads/2020/11/CYBERTEC-Prototyping-Express.pdf

Migrate to CYPEX? https://www.cybertec-postgresql.com/en/migrate-to-cypex/

Follow us on social media:
Linkedin: https://www.linkedin.com/company/cybertec-postgresql
Twitter: http://www.twitter.com/PostgresSupport
Facebook: http://www.facebook.com/cybertec.postgresql