Post Content
Explore how PostgreSQL design patterns are used in practice. Chris Ellis (Nexteam) shares insights in his talk “PostgreSQL Design Patterns” at POSETTE: An Event for Postgres 2026. Abstract: PostgreSQL has a bewildering array of features, many of which can make an application developers life easier and reduce complexity in their application!
We’ll take a look at a range of use cases and some PostgreSQL Design Patterns which can be used to help solve those, all based on real problems I’ve run into over the years.
Covering patterns to simplify your application architecture, to build your application logic faster and to help prevent disasters from happening!
Taking a look at use cases:
– Event Scheduling and Booking
– Queuing and Task Execution
– Text Search and Fuzzy Matching
– Category and Tag Searching
– Geolocation
– Unknown data
And more!
This talk introduces a huge range of PostgreSQL features that are building blocks of patterns you can make use of. It’s very much showing the art of the possible, and letting you choose how to use it.
Chris Ellis (Nexteam) is a self-proclaimed computing and electronics geek, who loves working with Open Source software. He is a jack of all trades consultant usually spending his time engineering systems with PostgreSQL, Java and Linux. Now and then he gets time to design some electronics often involving ESP32s, Raspberry Pi CM4s and LED badges.
► Video chapters:
⏩ 00:00 Introduction & Postgres design patterns overview
⏩ 00:10 Creative engineering & real-world context
⏩ 02:14 Modelling physical events (time & venue)
⏩ 02:38 Range types for time overlaps
⏩ 04:19 Generated columns & exclusion constraints
⏩ 06:41 Age ranges, GDPR & smart filtering
⏩ 08:08 Arrays & JSON for flexible filtering
⏩ 11:16 Adding geolocation with PostGIS
⏩ 13:36 Distance queries & geo indexing
⏩ 16:06 Enforcing business rules with partial indexes
⏩ 18:19 Task queues, idempotency & safe payments
📕 Everything you need to know about POSETTE: An Event for Postgres can be found at: https://posetteconf.com
✅ Learn more: watch more POSETTE talks: https://aka.ms/posette-playlist
📌 Let’s connect:
LinkedIn: https://www.linkedin.com/company/posetteconf/
X – @PosetteConf, https://x.com/PosetteConf
Mastodon – @posetteconf, https://mastodon.social/@posetteconf
Bluesky – @posetteconf.com, https://aka.ms/posette-on-bluesky
#PosetteConf #PostgreSQL #database Read More Microsoft Developer
