Beginner's Guide to PostgreSQL Development
Jim has more than 20 years of experience developing data intensive applications and infrastructure. Prior to joining AWS, Jim was CTO at OpenSCG and CEO at StormDB, a Postgres-XC scalable public cloud solution. While at StormDB, Jim envisioned the offering and was responsible for all product development. Prior to StormDB, Jim was chief architect at EnterpriseDB, leading the firm’s technology direction, including its early cloud offerings and other product lines. Jim also very active in the PostgreSQL community, co-founding both the New York and Philadelphia PostgreSQL Meetup groups, co-organizing the largest PostgreSQL conferences, and serving on the Board of the PostgreSQL Foundation. Jim also speaks regularly at PostgreSQL and other open sources conferences.
When developing against a PostgreSQL database, many times you will use SQL from your applications, but sometimes you need more. You might need to run some of your logic on the database server for performance or you may want to just create some server side functions to simplify your application development. There are an infinite number of reasons why you would want to write some code that runs on the PostgreSQL server and PostgreSQL has a rich set of options when you want to do that, but most times, you will use PL/pgSQL. The primary objective of this tutorial is to introduce you to the PostgreSQL PL/pgSQL programming language and to give you the practical skills to be a productive developer working with PostgreSQL databases.
In the course you will be introduced to variety of fundamental PL/pgSQL functions like:
- How to declare and use PL/SQL Variables
- How to create functions and procedures
- How to write triggers
- Handle run time errors
- And much more...
- 2019 March 19 13:00 EDT
- 3 h
- Murray Hill
- Postgres Conference