Avthar Sewrathan

How to Write Better Queries for Time-Series Data Analysis With Custom SQL Functions

23 Jun 2022 16 min read

As time-series data becomes more and more ubiquitous, there is a better way to explore it and analyze it with PostgreSQL: hyperfunctions. Learn how to ease your workload with faster and simpler time-series data analysis using TimescaleDB.

Analyze millions of NFT sales on OpenSea using PostgreSQL and TimescaleDB

29 Oct 2021 11 min read

Introducing the Timescale NFT Starter Kit, a step-by-step guide to get up and running with collecting, storing, analyzing and visualizing NFT data from OpenSea. And the Time Travel Tigers NFT Collection!

Massive Scale for Time-Series Workloads: Introducing Continuous Aggregates for Distributed Hypertables in TimescaleDB 2.5

28 Oct 2021 13 min read

With this release, we introduce continuous aggregates in multi-node TimescaleDB, support for Postgres 14, and support for time zones in time_bucket_ng (under experimental).

Grow Worry-Free: Storage Autoscaling on Timescale Cloud

7 Oct 2021 6 min read

Available today in Timescale Cloud: Automatically increase database storage as your application grows, while instituting cost constraints to make sure you stay within budget.

TimescaleDB 2.3: Improving Columnar Compression for Time-Series on PostgreSQL

26 May 2021 9 min read

TimescaleDB 2.3 makes built-in columnar compression even better by enabling inserts directly into compressed hypertables, as well as automated compression policies on distributed hypertables.

How to store time-series data in MongoDB, and why that’s a bad idea

17 Dec 2020 19 min read

260% higher insert performance, up to 54x faster queries, and simpler implementation when using TimescaleDB vs. MongoDB for time-series data.

Speed up Grafana by auto-switching between different aggregations, using PostgreSQL

11 Aug 2020 7 min read

Learn how (and why) to use PostgreSQL and TimescaleDB to speed up your Grafana drill downs: step-by-step guide to enable "auto-switching" between aggregations, depending on the time interval.

How to visualize timeshifts to compare metrics over time in Grafana using PostgreSQL

6 Aug 2020 8 min read

Learn how (and why) to combine PostgreSQL, TimescaleDB, and Grafana to visualize timeshifts and compare how your time-series metrics change over time.

TimescaleDB vs. InfluxDB: Purpose Built Differently for Time-Series Data

3 Aug 2020 26 min read

An in-depth look into how two leading time-series databases stack up in terms of data model, query language, reliability, performance, ecosystem, operational management, and company/community support.

9 Reasons to Choose Timescale vs. Influx and AWS Timestream

2 Jul 2020 3 min read

Why should you choose TimescaleDB over InfluxDB or AWS Timestream as your time-series database of choice? Let us count the ways (9 to be exact).

[New Webinar] Grafana 101 Part III: Interactivity, Templating and Sharing

11 Jun 2020 3 min read

Take your dashboards to the next level with step-by-step demos, queries, and pro tips that’ll get you creating interactive, reusable, and shareable Grafana dashboards in less time.

“Grafana 101: Getting Started with Alerting” Recap and Resources

3 Jun 2020 9 min read

Get step-by-step demos and learn how to define 3 different alert rules and send notifications through channels like Slack, PagerDuty and OpsGenie

[New Webinar] Grafana 101 Part II: Getting Started with Alerts

8 May 2020 3 min read

Jumpstart your monitoring journey with step-by-step demos, queries, and pro tips that'll get you set up with custom notifications for incidents in your systems, so you can take action immediately.

“Guide to Grafana 101: Creating Awesome Visualizations” Recap and Resources

30 Apr 2020 9 min read

Get step-by-step demos and learn how to create 6 different visuals for DevOps, IoT, geospatial, and public data scenarios (and beyond).

How to use Grafana variables to make more interactive dashboard visualizations (aka a lot less boring, a lot more useful)

20 Apr 2020 8 min read

Learn how to add features that allow you, your teammates, and your stakeholders to drill into specific details, see all results, and quickly get the info you need.

How to Build More Accurate Grafana Trend Lines: Plot Two Variables with Series-Override

How to Write Better Queries for Time-Series Data Analysis With Custom SQL Functions

Analyze millions of NFT sales on OpenSea using PostgreSQL and TimescaleDB

Massive Scale for Time-Series Workloads: Introducing Continuous Aggregates for Distributed Hypertables in TimescaleDB 2.5

TimescaleDB 2.3: Improving Columnar Compression for Time-Series on PostgreSQL

How to store time-series data in MongoDB, and why that’s a bad idea

Top 5 PostgreSQL Extensions

Speed up Grafana by auto-switching between different aggregations, using PostgreSQL

How to visualize timeshifts to compare metrics over time in Grafana using PostgreSQL

TimescaleDB vs. InfluxDB: Purpose Built Differently for Time-Series Data

9 Reasons to Choose Timescale vs. Influx and AWS Timestream

[New Webinar] Grafana 101 Part III: Interactivity, Templating and Sharing

“Grafana 101: Getting Started with Alerting” Recap and Resources

[New Webinar] Grafana 101 Part II: Getting Started with Alerts

“Guide to Grafana 101: Creating Awesome Visualizations” Recap and Resources

How to use Grafana variables to make more interactive dashboard visualizations (aka a lot less boring, a lot more useful)

How to Build More Accurate Grafana Trend Lines: Plot Two Variables with Series-Override

[New Webinar] Guide to Grafana 101: Getting started with (awesome) visualizations

“How to Analyze Your Prometheus Data in SQL” Recap and Resources

[New Webinar]: How to analyze your Prometheus data in SQL: 3 queries you need to know

Devopsdays NYC 2020 demo, open space recap & more

Charting the Spread of COVID-19 Using Data

“Time-Series for Developers: What the Heck is Time-Series” Recap and Resources

[New Webinar] Time-Series for Developers: WTH is Time-Series?