Category: Database, Microsoft

PostgreSQL database startup Timescale has introduced some new SQL functions to make PostgreSQL developers more productive. Timescale introduced TimescaleDB hyperfunctions, which are pre-built functions for the most common — and often most difficult — queries that developers write today, said Joshua Lockerman, a software engineer at Timescale who co-developed the new hyperfunctions.

Just as we made the decision to build TimescaleDB on top of PostgreSQL, we built hyperfunctions using existing SQL syntax with new functions so that developers can continue to use all the tools and frameworks they already know and be productive immediately,” said Ajay Kulkarni, CEO and co-founder of Timescale.

This announcement seems to be around new library functions, callable from SQL, that make it easier to do time-series calculations in SQL queries and scripts,” he said.

That is why Timescale chose to create new SQL functions for time-series analysis and manipulation rather than to try to improve the developer experience by introducing new SQL syntax.

Related Articles