Building scalable, real-time analytics applications with Azure Database for PostgreSQL
Presented by:
Samay Sharma
No video of the event yet, sorry!
In this hands-on tutorial, we will cover many of the capabilities that make Postgres the world’s most advanced open source relational database. Specifically, we'll dive deep on how to build scalable, real-time analytics applications using Postgres in the cloud. To do this, we’ll go hands-on and use Azure Database for PostgreSQL including Hyperscale (Citus).
Topics include:
- Why more & more teams are choosing Postgres
- The Postgres features that matter most to real-time analytics
- Schema designs for ingesting large amounts of data
- Compare & contrast approaches for rolling up data
- Walk through sample real-time analytics dashboard queries
- How to use HyperLogLog (HLL) for fast approximations
- Using pg_cron to periodically expire older data & reduce costs
- How to use Hyperscale (Citus) to scale out Postgres horizontally and deliver real-time analytics at even greater scale
- How to build a complete real-time analytics pipeline in the cloud using Azure Database for PostgreSQL
- Date:
- 2019 September 18 09:00 PDT
- Duration:
- 3 h
- Room:
- Winchester (2)
- Conference:
- Silicon Valley 2019
- Language:
- Track:
- Data
- Difficulty:
- Medium
- Requires Registration:
- Yes (Registered: 8)