The Rube Goldberg Database - Introduction to Postgres functions and triggers


Playlists: 'gpn20' videos starting here / audio

Brief introduction to some neat and underappreciated Postgres features that let you do stuff within the database that you probably hadn't imagined was even possible.

Sounds complicated? Don't be daunted! If you know some SQL and a programming language, that should be enough to follow along.

Postgres gives you the power to write your own functions that run *in the database*. This talk will give an overview over *why* you might want to do that and demonstrate with some hands-on examples.
For even more magic, we will look at triggers, which let you automatically run functions when data is being modified.