jpruittsql

We Built a Production, Slack-Native Agent and Open-Sourced It

Posted by jpruittsql on Friday October 31, 2025 @10:05AM
from the tigerdata.com dept.

https://www.tigerdata.com/blog/we-built-production-agent-open-sourced-everything-we-learned

Re:Function pipelines: Building functional programming into PostgreSQL on Tuesday October 19, 2021 @05:44PM (#28924178)

CTEs are wonderful for readability, but until recent versions of PostgreSQL they were always "materialized" which can have performance implications vs. subqueries. The NOT MATERIALIZED option to CTEs was added in PostgreSQL 12. (Timescale Engineer)