CYBERTEC PostgreSQL Logo

CYPEX Online Academy - Application Add-ons Section

8.1 Add-Ons

CYPEX add-ons are PostgreSQL extensions which contain ready-to-use fragments such as addresses, currency lists, models to store product data, unit conversion and a lot more. These extensions make our data models more consistent – and when you add them, the time it takes to produce an application significantly decreases. By integrating them, we support full version control as well as access to standard DevOps-related pipelines.

8.2 Create a repository application

First, create a directory for your new application. In this directory, you need an SQL file which contains the data model of your application. Keep in mind that the CYPEX role “authenticator” must have access to your tables, otherwise CYPEX has no permissions to manage the relations directly. The next thing you need is an “uninstall” script. When you deploy an application, you also have to figure out how to get rid of the application after it has fulfilled its purpose. The important part is that running the install and the uninstall script one after the other should leave you with an empty database.

Ideally you should split the model and the sample data into separate files. This is usually more convenient, since it’s easier to remove the test data later or to manage your repository in general.
Once this is done you can create a file called description.json. It will contain a lot of metadata CYPEX will need to manage your application nicely. The easiest way is to copy our sample files, and take it from there.

Finally, you can add your application to Git and easily deploy it using the graphical user interface provided by CYPEX.

< Application data API section | Academy overview | Application designer section >

CYBERTEC Logo white
CYBERTEC PostgreSQL International GmbH
Römerstraße 19
2752 Wöllersdorf
Austria

+43 (0) 2622 93022-0
office@cybertec.at

Get the newest PostgreSQL Info & Tools


    This site is protected by reCAPTCHA and the Google Privacy Policy & Terms of Service apply.

    ©
    2024
    CYBERTEC PostgreSQL International GmbH
    phone-handsetmagnifiercrosscross-circle
    linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram