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!
-
A former member
1 · March 20, 2014
-
-
-
78 went
More
Help support your Meetup
Chip inWe're about:
People in this
Meetup are also in:
-
SQL NYC, The NoSQL & NewSQL Database Meetup
17,447 Data Enthusiasts
-
NYC Nodejs
5,244 Nodesters
-
NYC Tech Talks
3,208 NYC Techies
-
The New York Python Meetup Group
10,412 Python Programmers and Users
-
NY Tech Meetup
55,483 NYC Technologists
-
NYC Open Data
5,503 Data Scientists and Open Data-er
Hey Everyone,
Was great to see you all at the meetup yesterday, and looking forward to catching up at PGConf.
I've also uploaded the presentation to SlideShare, feel free to check it out at: http://www.slideshare.net/robertsosinski/plpgsql-presentation
You can also download all of the code examples at: http://www.reactive.io/downloads/presentations/postgresql/plpgsql/plpgsql-examples.zip
Thanks again,
-Robert