PostgreSQL Design Patterns

PostgreSQL has a bewildering array of features, many 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.