World Congress 2026 Europe - Virtual Stage • Jul 2, 2026 • Session details

Tracking vehicles at scale

Thorsten Riess

Trackonix bypassed complex microservices to track fleets at massive scale. Pushing logic to PostgreSQL and leveraging client-side DuckDB-Wasm dropped their analytics server costs to absolute zero.

Pause
Mute Enter Fullscreen
#1 about 4 min

Managing fleet telemetry complexity at production scale

How a small team handles heterogeneous vehicle data and peak ingestion rates without over-engineering.

#2 about 3 min

Adopting a single source of truth architecture

Minimizing integration points and reconciliation overhead by keeping logic close to the primary data store.

#3 about 2 min

Running operations with single-purpose infrastructure tools

Using discrete HashiCorp binaries for infrastructure management to avoid the complexity of full orchestration platforms.

#4 about 3 min

Leveraging managed serverless databases for primary storage

Consolidating analytical and spatial workloads into a single transactional database with compute and storage separation.

#5 about 6 min

Implementing stateful streaming logic inside a database

Replacing external stream processors with recursive SQL functions to run Kalman filters directly on incoming telemetry.

#6 about 3 min

Real-time trip sessionization using database triggers

Generating continuous session aggregations from raw events without a message broker or consumer queue.

#7 about 6 min

Resolving temporal graph structures with relational tables

Enforcing conflict resolution and cycle detection for moving hierarchical relationships using standard SQL constraints.

#8 about 3 min

Querying cold storage directly from the browser

Offloading historical data access to object storage and client-side analytical engines to bypass backend query layers.

#9 about 4 min

Evaluating architectural tradeoffs and final system lessons

Assessing the costs of running heavy computation inside the database and defining guidelines for system scaling.

Matching moments

3:01 min

Time-series data management with PostgreSQL and TimescaleDB

Michele Giacobazzi Michele Giacobazzi · Europe 2026 Virtual

2:02 min

Data structures, unique identifiers, and platform scaling

Tonci Zilic · World Congress 2022

3:00 min

Inspecting a real-time fleet management telemetry dashboard

Dubravko Dolic +1 · World Congress 2021

3:42 min

Managing high-traffic infrastructure without chasing technology hype

Josip Stuhli Josip Stuhli · Coffee With Developers

2:11 min

Building a custom vehicle telemetry platform on AWS

Tonci Zilic · World Congress 2022

2:36 min

Modern application stacks and real-time data requirements

Tim Faulkes · LIVE