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.