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:


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.


Attended by: Gianni Ceccarelli (‎dakkar‎), Joelle Maslak, H.Merijn Brand (‎Tux‎), Dagfinn Ilmari Mannsåker (‎ilmari‎), DrForr, Thomas Klausner (‎domm‎), Eitan Schuler, Ilya Chesnokov (‎ichesnokov‎), Andreea Hosu (‎Andreea‎), Jon André Hjellestad (‎Jonis‎), Nicholas Clark, Andreas Boesen (‎Happy‎), Andreas Koenig, Theo van Hoesel (‎vanHoesel‎), Matthew Chubb (‎mchubb‎), Johan Lindstrom, Patrick Ringl (‎pari‎), Felix Antonius Wilhelm Ostmann (‎Sadrak‎), Aaron Crane (‎arc‎), Max Maischein (‎Corion‎), Søren Lund (‎slu‎), Steve Rogerson, Paul Evans (‎LeoNerd‎), Erik Johansen (‎uniejo‎), scott, Andrew Nugged (nugged), Andreas Huber

Community Sponsors

Enlightened Perl Organisation Magnum Solutions Logo Perl6 Community Perl Weekly