addressalign-toparrow-leftarrow-rightbackbellblockcalendarcameraccwcheckchevron-downchevron-leftchevron-rightchevron-small-downchevron-small-leftchevron-small-rightchevron-small-upchevron-upcircle-with-checkcircle-with-crosscircle-with-pluscontroller-playcrossdots-three-verticaleditemptyheartexporteye-with-lineeyefacebookfolderfullheartglobegmailgooglegroupshelp-with-circleimageimagesinstagramFill 1light-bulblinklocation-pinm-swarmSearchmailmessagesminusmoremuplabelShape 3 + Rectangle 1ShapeoutlookpersonJoin Group on CardStartprice-ribbonprintShapeShapeShapeShapeImported LayersImported LayersImported Layersshieldstartickettrashtriangle-downtriangle-uptwitteruserwarningyahoo

Demystifying PL/PGSQL - PostgreSQL's Powerful Secret

  • Mar 19, 2014 · 6:30 PM

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, Founder and Technical Fellow at 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!



Join or login to comment.

Our Sponsors

People in this
Meetup are also in:

Sign up

Meetup members, Log in

By clicking "Sign up" or "Sign up using Facebook", you confirm that you accept our Terms of Service & Privacy Policy