PostgreSQL
How to create (lots!) of sample time-series data with PostgreSQL generate_series()
Generating sample time-series data with the PostgreSQL generate_series() function is a useful skill to have when evaluating new database features, creating demonstrations, or testing insert and query patterns. Learn what PostgreSQL `generate_series()` is and how to use it for basic data generation.
Docs
Want to learn how to use TimescaleDB?
Visit our comprehensive docs with API reference, user guides, tutorials, and much more.
Prometheus
Simplified Prometheus monitoring for your entire organization with Promscale
We’re excited to announce multi-tenancy support in Promscale. We’ve built Promscale as a centralized store for metrics, and now developers can enjoy the same operational maturity and query flexibility when storing metrics across their entire organization.
Product & Engineering
How PostgreSQL aggregation works and how it inspired our hyperfunctions’ design
Get a primer on PostgreSQL aggregation, how PostgreSQL’s implementation inspired us as we built TimescaleDB hyperfunctions and its integrations with advanced TimescaleDB features – and what this means for developers.
Announcements & Releases
Move fast, but don’t break things: Introducing the experimental schema (with new experimental features) in TimescaleDB 2.4
To reinforce our commitment to moving fast and not breaking things, we are introducing a new experimental schema for TimescaleDB as part of our release of TimescaleDB 2.4. Read on for more about how Timescale resolves the tension between rapid innovation and stability.
General
Hacking NFL data with PostgreSQL, TimescaleDB, and SQL
Learn how to use time-series data provided by the NFL to uncover valuable insights into many player performance metrics – and ways to apply the same methods to improve your fantasy league team, or your knowledge of the game - all with PostgreSQL, SQL, and freely available extensions.
Always Be Launching
Introducing hyperfunctions: new SQL functions to simplify working with time-series data in PostgreSQL
TimescaleDB hyperfunctions are pre-built functions for the most common and difficult queries that developers write today in TimescaleDB and PostgreSQL. Hyperfunctions help developers measure what matters in time-series data, which generates massive, ever-growing streams of information.
Newsletter
Timescale Newsletter Roundup: June 2021
In this edition, we're sharing a blog post filled with advice and tips about how to start contributing to Postgres (or contribute more!), recordings of our talks from recent virtual events, and an assortment of our favorite tools, tips, and advice to help you do more with your time-series data.
Engineering
Save money and improve performance by carefully managing your time-series data
Time-series data is relentless. It grows at an ever-increasing rate and quickly becomes expensive and unwieldy to store and query. Timescale provides the tools you need to maintain storage and query performance and keep tight control over your costs.
Newsletter
Timescale Newsletter Roundup: May 2021
Get a digest of what's new from Team Timescale, including 12 launches in one month, courtesy of our #AlwaysBeLaunching initiative. We're sharing the highlights here, and rounding out the list with a few of our favorite resources and awesome technical content from community members.
Always Be Launching
Announcing automated disk management: Safely managing your cloud database
To close out our final week of “Always Be Launching” month, we are announcing “Automated Full Disk Management” for Timescale Forge, a new capability to ease operational overhead, protect against unforeseen overages, and keep your database up and running.
Always Be Launching
How I learned to stop worrying and love PostgreSQL on Kubernetes: continuous backup/restore validation on Timescale Forge
Building a resilient cloud-native database experience means doing the hard stuff for our users. Learn how Timescale Forge uses advanced techniques to ensure (and test for) reliability.
Always Be Launching
Promscale 0.4: Drawing inspiration from Cortex to rewrite support for Prometheus high-availability
Introducing Promscale 0.4 with new capabilities including better support for Prometheus high-availability, support for multi-tenancy, improved user permissions (using role-based access control), and more.
Always Be Launching
2021 State of Postgres survey results
Postgres is one of the most popular and loved databases in the world, even after 30+ years of development. Learn how developers use Postgres today, from the use cases they’re tackling and places they go to share and learn to opportunities for improvement in the Postgres community, and more.
