I was recently tasked with writing a bit of code to find delivery route stops where nothing has to be unloaded. This code is intended to prevent a delivery driver from stopping at a store when there’s nothing in the truck for that customer that day. Read more on Finding Records that Don’t Exist in PostgreSQL…
postgres
An Introduction to PostgreSQL Materialized Views
Our team recently found itself in a situation where we needed to write a database query to:
- Union several tables together
- Filter out some rows
- Sort the unioned set different ways
This was going to be a very expensive and slow query. Read more on An Introduction to PostgreSQL Materialized Views…