How to Persist YAWL BPMS on POSTGRES DBMS
Channel: YAWL User Group
Date: 2021-04-12

How to set up Postgres databases for YAWL, including user creation and Hibernate properties?
The state of a Business Process Management System must be persisted at all times, so that in case of a power failure, it can be recovered. The persistence layer in YAWL is a relational database. The standard file-based database is not well suited for productive environments.
Therefore it is important to switch to a Data Base Management System (DBMS) that can be backed up.

In this video, we‘ll install Postgres as the DBMS to work with YAWL. With YAWL, you can also use MySQL or Microsoft SQL Server, DB2 or Oracle. In the Postgres DBMS we‘ll set up two databases:
- One for the YAWL system itself
- The other for the application data
For a productive system, you would want the YAWL DB to reside in a DBMS where regular backups are performed by your database administrators.

This is Tutorial Number 27. You can find supplementary material on github:
https://github.com/ahense/YAWL
Click on "Code"/Download zip to get the whole package. The material for this tutorial is in the folder that corresponds to the tutorial number.

0:00 - Introduction
1:12 - Install Postgres
2:03 - Setup Users and Databases
4:27 - Install Database Drivers
5:11 - Adapt Hibernate Properties
6:04 - Conclusion