Schedule - Nordic PGDay 2026

PG Tricks

Date: 2026-03-24
Time: 13:10–14:00
Room: Vision 1
Level: Intermediate

PostgreSQL has a huge range of features, maybe too many. Making use of these features can often make application developer's lives easier, reducing the complexity of their application.

We'll take a look at some use cases I've ran into over the years and what features of PostgreSQL can be used to help solve those problems.

Where we can use PostgreSQL to simplify our application architecture, to simplify our application code and to help prevent things going wrong.

Taking a look at use cases such as:

Event scheduling & booking
Task execution
Text Search and Fuzzy Matching
Category and Tag Searching
Time Series
Geolocation
Unknown data

And more!

This talk covers a huge range of SQL features and patterns that you can make use off, as is very much about showing what you can do.

Speaker

Chris Ellis