Function pipelines: Building functional programming into PostgreSQL using custom operators

Today, we are announcing function pipelines, a new capability that introduces functional programming concepts inside PostgreSQL (and SQL) using custom operators. Function pipelines radically improve the developer ergonomics of analyzing data in PostgreSQL and SQL, by applying principles from functional programming and popular tools like Python’s Pandas and PromQL. This allows developers to analyze data by composing multiple functions, leading to a simpler, cleaner way of expressing complex logic in PostgreSQL. The new capability is fully PostgreSQL compliant, meaning that any tool that speaks PostgreSQL will be able to support data analysis using function pipelines. Function pipelines are pre-loaded on each new database service on Timescale Cloud, available immediately, and can also be installed for free on existing PostgreSQL installations through the timescaledb_toolkit extension.

Use this post, company, and trend context to find content marketing opportunities, perform competitive analysis, or address product feature gaps via the Plushcap MCP server or the Plushcap API.