workshop

From Sensor to Insight: Real-Time IIoT Analytics Built on Postgres

Date

Wednesday, November 18, 2026

Time

12:00 - 1:00 ET

Location

Virtual (link sent upon registration)

Register
From Sensor to Insight: Real-Time IIoT Analytics Built On Postgres (Nov 18)

IoT devices generate continuous streams of sensor data, and most databases weren't built for it. The volume grows, queries degrade, and teams end up on an optimization treadmill that buys time but doesn't change the trajectory. If you're evaluating time-series databases, hitting the limits of your current setup, or just want to see what's possible when you extend PostgreSQL with the right primitives, this is a good use of an hour.

In this hands-on workshop, you'll build a real IoT analytics pipeline from scratch using TimescaleDB on Tiger Cloud. You'll write actual SQL, ingest real sensor data, and leave with a working Tiger Cloud instance you built yourself. Along the way, we'll cover the core primitives: hypertables for fast time-series storage, Hypercore columnar compression that cuts storage by 10x without losing a single data point, and continuous aggregates that keep analytical queries fast as data volumes grow.

What you'll learn

  • How to create a hypertable and model IoT sensor data alongside relational metadata

  • How Hypercore columnar compression works and how to get 10x storage reduction while improving query performance

  • How to write time-series queries using time_bucket() and hyperfunctions like last()

  • How continuous aggregates give you self-updating materialized views for real-time dashboards

Not available November 18? Try Tiger Cloud free or explore the TimescaleDB IoT tutorial at your own pace.

Register free

You might also be interested in

Aggregate 2027

NYC

Livestream

Aggregate 2027

Tiger Data's free one-day event in NYC for the people building on time-series and Postgres — March 10, 2027.

Mar 10, 2027

New York

Aggregate 2027
IMTS 2026

in-person

Tiger Data: Real-Time Analytics for Manufacturing, Without the Tradeoff

Visit Tiger Data at IMTS to see how TimescaleDB powers industrial data on PostgreSQL.

Sep 14, 2026

Chicago | McCormick Place

IMTS 2026
ISA 2026

in-person

The PostgreSQL Database Built for Industrial Analytics

Explore modern data infrastructure for industrial automation and SCADA.

Sep 27, 2026

Orlando | Walt Disney World Swan and Dolphin

ISA 2026