Schedule - PGConf.EU 2018
Let's Build a Complex, Real-Time Data Management Application...before the session ends!
Date: 2018-10-25
Time: 09:30–10:20
Room: New York
Level: Intermediate
Congratulations: you've been selected to build an application that will manage whether or not the rooms for PGConf.EU are being occupied by a session!
On the surface, this sounds simple, but we will be managing the rooms of PGConf.EU, so we know that a lot of people will be accessing the system. Therefore, we need to ensure that the system can handle all of the eager users that will be flooding the PGConf.EU website checking to see what availability each of the PGConf.EU rooms has.
To do this, we will explore the following PGConf.EU features:
- Data types and their functionality, such as:
- Data/Time types
- Ranges
- Arrays
- Indexes such as:
- GiST
- SP-Gist
- Common Table Expressions and Recursion
- Set generating functions and LATERAL queries
- Functions and the PL/PGSQL
- Triggers
- Logical decoding and streaming
We will be writing our application primary with SQL, though we will sneak in a little bit of Python to demonstrate the power of logical decoding. This will be an interactive sessions and we will provide some containers to ensure you have everything you need to be up and running when the bell rings.
At the end of the session, we will have a working application, and you will be happy knowing that you provided a wonderful user experience for all PGConf.EU attendees made possible by the innovation of PGConf.EU!
Slides
The following slides have been made available for this session:
- https://goo.gl/a3pDkz
- https://www.slideshare.net/jkatz05/building-a-complex-realtime-data-management-application
