We're sorry but this page doesn't work properly without JavaScript enabled. Please enable it to continue.
Feedback

Let's Build a Complex, Real-Time Data Management Application

Formal Metadata

Title
Let's Build a Complex, Real-Time Data Management Application
Subtitle
...before the training session ends!
Title of Series
Number of Parts
37
Author
License
CC Attribution 3.0 Unported:
You are free to use, adapt and copy, distribute and transmit the work or content in adapted or unchanged form for any legal purpose as long as the work is attributed to the author in the manner specified by the author or licensor.
Identifiers
Publisher
Release Date
Language

Content Metadata

Subject Area
Genre
Abstract
Congratulations: you've been selected to build an application that will manage whether or not the rooms for PGCon are being occupied by a session! On the surface, this sounds simple, but we will be managing the rooms of PGCon, 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 PGCon website checking to see what availability each of the PGCon rooms has. To do this, we will explore the following PostgreSQL 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 PGCon attendees made possible by the innovation of PostgreSQL!