The Rube Goldberg Database - Introduction to Postgres functions and triggers (gpn20)

25:57
 
Teilen
 

Manage episode 329241827 series 48696
Von CCC media team entdeckt von Player FM und unserer Community - Das Urheberrecht hat der Herausgeber, nicht Player FM, und die Audiodaten werden direkt von ihren Servern gestreamt. Tippe auf Abonnieren um Updates in Player FM zu verfolgen oder füge die URL in andere Podcast Apps ein.
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. Slides: https://leftshift.github.io/postgres-functions-triggers/#/ about this event: https://cfp.gulas.ch/gpn20/talk/PHPHGW/

11513 Episoden