SQL

Postgres 12 CTE Enhancements

The Good/Automatic, The Bad/Manual, The Ugly/Refactoring

When we started work on our custom TMS in 2015, we looked around at the landscape for a database that met the following requirements: Fast and easy dev environment setup. This almost instantly ruled out Microsoft SQL Server at the time. There was no good way to programatically (read Docker/Vagrant) stand up a replica/dev database, and their licensing was beyond our budget at the time. Support for Common Table Expressions (CTEs).