Dev Q&A
How Flowkey Scaled Its AWS Redshift Data Warehouse With Timescale
To scale their business, the leading app for piano lessons, flowkey, migrated from Amazon Redshift to TimescaleDB. The result? An optimized user experience as they analyze millions of user events per day swiftly and efficiently.
PostgreSQL
A PostgreSQL Developer’s Perspective: Five Interesting Patches From January’s Commitfest
In this recap of January’s Commitfest, our PostgreSQL developer Chris Travers shares his thoughts on improvements to psql, software development with infinite values, transaction ID wraparound problems, and more.
Dev Q&A
How Ndustrial Is Providing Fast Real-Time Queries and Safely Storing Client Data With 97 % Compression
Read how Ndustrial is helping its clients save energy and money by collecting and connecting production and energy data to quickly answer real-time queries—all while using TimescaleDB to store and compress data up to 97 percent.
General
Downsampling in the Database: How Data Locality Can Improve Data Analysis
Learn why data locality can be crucial to downsampling data faster and more efficiently, accelerating the work of both devs and businesses. To test this new approach, we benchmarked the LTTB downsampling algorithm in Ruby and compared it with the Timescale Toolkit lttb ().
Dev Q&A
How Everactive Powers a Dense Sensor Network With Virtually No Power at All
Read how Everactive consolidated its storage solution and benefited from more predictable pricing by moving its metadata from Amazon RDS to Timescale—all while expanding its cloud analytics platform powered by battery-free sensors to developers building their own solutions and services.
Dev Q&A
How Octave Achieves a High Compression Ratio and Speedy Queries on Historical Data While Revolutionizing the Battery Market
Read how Octave migrated from AWS Timestream to Timescale in search of a more scalable database and is revolutionizing the second-life battery market by collecting, analyzing, and storing large volumes of time-series data.
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, and the return of in-person events (great to see you!).
Observability
How to Turn Timescale 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
Timescale 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 to handle their time-series data workloads? Our benchmark answers the question: faster queries, faster ingest, and 95 % storage savings for time-series data.
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 allows you to do it as swiftly as possible.
