Events  Deals  Jobs  NFT NYC 2024 
    Sign in  
 
 
Thu, Dec 14, 2017 @ 06:30 PM   FREE   Work Bench, 110 Fifth Ave, 5th Fl
 
     
 
 
              

      
 
Sign up for our awesome New York
Tech Events weekly email newsletter.
   
LOCATION
EVENT DETAILS
Join the NYC PostgreSQL User Group for 3 Postgres related talks in one night!

Agenda:

6:30 - 7:00: Efficiently & Safely Propagate Data Changes Without Triggers! (Jonathan Katz)

Prior to PostgreSQL 9.4, the primary way to distribute data-driven changes across multiple tables was to use triggers. While triggers guarantee that these changes will be propagated, they can have a significant impact application performance, both technically & with development time (see: "debugging").

PostgreSQL 9.4 introduced logical decoding, which provides a way to stream all changes in a database to a consumer. Using a logical decoder, you can read all changes that are made in a table into your programming language of choice to perform many tasks: cache invalidation, data propagation, submitting changes to remote services, & more. Many PostgreSQL drivers, such as psycopg2 & JDBC support the logical replication protocol, which lets you easily stream your database changes to be manipulated using your favorite programming language.

This talk will demonstrate how you can setup logical decoding for your application, look at architecture strategies for working with a logical decoder, & look at a case-study that shows how using logical decoding led to a big performance boost over a similar trigger-based system.

7:00 - 7:30: Technical Architecture of Postgres Aurora (Kevin Jernigan)

Amazon Aurora is a cloud-optimized relational database that combines the speed & availability of high-end commercial databases with the simplicity & cost-effectiveness of open source databases. The recently announced PostgreSQL-compatibility, together with the original MySQL compatibility, are perfect for new application development & for migrations from overpriced, restrictive commercial databases. In this session, we'll do a deep dive into the new architectural model & distributed systems techniques behind Amazon Aurora, discuss best practices & configurations, look at migration options & share customer experience from the field.

7:30 - 8:20: The Power of Postgres Replication, Joshua (JD) Drake, Lead Consultant Command Prompt, Inc & Co-Chair PGConf!

With PostgreSQL v10 a new replication engine has come to town. Let's explore Postgres Logical Replication, how to use it, optimize it & let it best fit in with your organization. We will also discuss its interactions with external tools as well as Binary Replication & features such as Hot Standby.
 
 
 
 
© 2024 GarysGuide      About    Feedback    Press    Terms