Managing PostgreSQL stored procedures as application code

By:	Wieger Opmeer (‎a6502‎) from Berlin.pm
Date:	Thursday, 16 August 2018 14:50
Duration:	20 minutes
Target audience:	Intermediate
Language:	English

You can find more information on the speaker's site:

Talk: https://a6502.github.io/msp-tpc-2018/msp-tpc-2018.html

Database stored procedures can be a powerful and useful tool, but managing them in combination with the code base that uses them isn't easy. I will talk about the tooling we developed to do version control of the stored procedures for the JobCenter project (see my other talk proposal).

This tooling allows us to version control the stored procedures as if it were application code, manage the database schema and keep code and schema in sync. The tooling currently is a bit project specific but could be
generalized.