Demystifying PL/PGSQL - PostgreSQL's Powerful Secret

When you start tackling complex high-volume data problems, SQL might not be enough. When your logic needs to be close to your data, Postgres has a secret weapon, PL/PGSQL.

An imperative language that extends SQL, PL/PGSQL lets you execute complex read and write logic directly on the database. The benefits include increased speed and concurrency, ability to share logic among many applications, strong consistency guarantees, and greater query flexibility.

Robert Sosinski (http://www.robertsosinski.com), Founder and Technical Fellow at Reactive.IO (http://www.reactive.io) will demonstrate what PL/PGSQL is as a language and provide examples where it can help benefit you as a developer.

He will then show you how PL/PGSQL functions can speed up your indexes, accelerate complex queries, activate custom triggers on data changes, and handle complex write situations. You will then be able to take control of your data directly at the source, PostgreSQL itself!