Episode

Azure Cosmos DB for PostgreSQL Ep03: Extend the functionality of Azure Cosmos DB for PostgreSQL using extensions

with Srihareendra Bodduluri, Rick Heiges, Geraldine Caszo

Use PostgreSQL extensions to enhance and extend the functionality of Azure Cosmos DB for PostgreSQL. PostgreSQL allows you to extend the functionality of a database by using extensions. Extensions allow for bundling multiple related SQL objects together in a single package that can be loaded or removed from the database with a single command. After being loaded in the database, extensions can function like built-in features.

Learning objectives

  • Install different extensions available in Azure Cosmos DB for PostgreSQL
  • Extend the functionality of an Azure Cosmos DB for PostgreSQL database using extensions

Chapters

  • 00:00 - Introduction
  • 01:36 - Learning objectives
  • 03:27 - Scenario
  • 07:21 - What are PostgreSQL extensions?
  • 09:00 - What is Citus?
  • 12:27 - Exercise - Explore how Citus distributes tables
  • 33:09 - Apply PostgreSQL extensions
  • 48:03 - Understand the Azure Storage extension
  • 59:39 - Knowledge check
  • 01:06:33 - Summary and resources

Connect

Beginner
Developer
Azure
Azure Cosmos DB