.NET Data Community Standup: Temporal tables and constraints in SQL Server and PostgreSQL 18

From the creator

In this session we'll take a deep look at temporal tables and constraints in database. The recently-released PostgreSQL 18 contains new temporal constraint functionality that superficially looks similar to SQL Server's temporal tables, but the two are in reality quite different. We'll dive into the details, compare the two and discuss two completely different concepts of what it means to store temporal data in databases. ⌚ Chapters: 00:00 Countdown 02:49 Welcome and Intros 03:35 What's new in EF Core Preview 5 07:00 On today's stream - Temporal Table Support or Temporality in Databases 10:40 Intro to Temporal tables in SQL Server 18:33 Querying the table 26:39 Recap 27:12 Intro Postgres Ranges 36:01 Intro Temporal Tables in Postgres 37:02 How it looks in PostgresSQL 18 57:00 Recap 57:27 How the feature works in EF Core 58:46 Q&A 01:04:12 Wrap 🎙️ Featuring: Shay Rojansky, Jiri Cincura #ef #efcore #data #temporal #sqlserver #postgres

Published 2026-06-26 · Watch on YouTube ↗
Availability and playback restrictions are controlled by the original channel.