Product Updates
An Incremental Materialized View on Steroids: How We Made Continuous Aggregates Even Better
A continuous aggregate is similar to a PostgreSQL materialized view, speeding up queries. But rolling up (or downsampling) previously rolled up data can increase calculation speed while decreasing storage needs. Say hi to continuous aggregates on continuous aggregates, courtesy of TimescaleDB 2.9.
Docs
Want to learn how to use TimescaleDB?
Visit our comprehensive docs with API reference, user guides, tutorials, and much more.
Dev Q&A
How Newtrax Is Using TimescaleDB and Hypertables to Save Lives in Mines While Optimizing Profitability
Bringing the digital world to a conservative industry isn’t easy, but Newtrax is successfully doing it by using hypertables in TimescaleDB to prevent human and machine collisions in mines while optimizing profitability.
General
Year of the Tiger: 12 (and Then Some) Timescale Highlights of 2022
Join us in celebrating 12 highlights of 2022 (and then some), including launches like one-click forking and replicas, our consumption-based, bottomless object store in Timescale Cloud, and the return of in-person events (great to see you!).
PostgreSQL, Blog
12 Days of PostgreSQL Tools and Projects
Developers are busy creatures who don’t always have the time to find helpful, productive tools for PostgreSQL. So, even if you don’t celebrate Christmas, we have a little present up our sleeve: 12 Days of PostgreSQL, a.k.a. 12 PostgreSQL projects you should know. Enjoy!
Observability
How to Turn Timescale Cloud Into an Observability Backend With Promscale
Learn everything you need to know about how to integrate Timescale Cloud and Promscale with a Kubernetes-based system, including how to optimally configure Prometheus, OpenTelemetry, Grafana, and Jaeger, and how you can use SQL to analyze your metrics and traces.
Cloud
How to Design a Better Developer Experience for Time-Series Data: Our Journey With Timescale's Cloud UI
Designing a delightful, user-centered UI is a huge part of building a seamless developer experience for time-series data. Join us on a journey through the evolution of the Timescale Cloud UI, as we share our latest upgrade and all the lessons we learned.
Cloud
Timescale Cloud vs. Amazon RDS PostgreSQL: Up to 350x Faster Queries, 44 % Faster Ingest, 95 % Storage Savings for Time-Series Data
Why are developers migrating from Amazon RDS for PostgreSQL to Timescale Cloud to handle their time-series data workloads? Our benchmark (and an array of Timescale Cloud's features) answer the question: faster queries, faster ingest, and 95 % storage savings for time-series data.
Cloud
Do More on AWS With Timescale Cloud: 8 Services to Build Time-Series Apps Faster
Timescale Cloud integrates seamlessly into the AWS ecosystem of tools and services. Learn about the most popular AWS tools that Timescale customers incorporate into their data architectures to speed up development time.
PostgreSQL
Read Before You Upgrade: Best Practices for Choosing Your PostgreSQL Version
PostgreSQL upgrades have been known to be a bit of a controversial issue in the community. In this article, we will take the mystery out of the question of when an upgrade is appropriate and how Timescale Cloud allows you to do it as swiftly as possible.
Cloud
Database Management: Behind-the-Scenes Lessons From a Data Architect
If you’re a technologist (or a data architect, like myself) who does not miss freezing data centers or jumping through the loops of database management, these lessons are for you. Here’s what you need to think about when running your database in production, and why there may be a better way.