NanoTDB: A lightweight, append-only time-series database for resource-constrained IoT hardware with built-in automatic rollups
By
aymanhs72
Crisp on the outside, thoughtful on the inside. A keeper.
Summary
NanoTDB is a tiny, embedded, append-only time-series database designed for resource-constrained hardware like Raspberry Pi, edge nodes, and IoT gateways. It has no external runtime dependencies and stores all data in plain files under a single root directory. A key differentiator is its built-in support for automatic aggregates and rollups, which maintain summary data for higher-level time buckets during ingestion, improving query performance for long-range or downsampled queries.
Key quotes
· 4 pulledA small, embedded time-series database designed for resource-constrained hosts (Raspberry Pi, edge nodes, IoT gateways).
No external dependencies at runtime.
When you ingest time-series samples, the engine can automatically maintain aggregate summaries for higher-level time buckets, reducing query cost and improving query performance for long-range or downsampled queries.
This behavior is built into the storage engine and is one of the core differentiators of NanoTDB.
You might also wanna read
SQLite as a Viable Alternative for Durable Workflow Execution
The article argues that SQLite can replace complex orchestration systems for durable workflow execution in many cases. It builds on DBOS's a
M5Stack PaperColor: A 4-inch color E Ink dev board with ESP32-S3 and audio I/O
M5Stack has released the PaperColor, a developer-ready gadget featuring a 4-inch color E Ink display (Spectra 6 panel), ESP32-S3 microcontro
Product Hunt·17d ago
Honker: A SQLite extension adding Postgres-style pub/sub, queues, and event streams
Honker is a SQLite loadable extension that adds PostgreSQL-style NOTIFY/LISTEN semantics to SQLite, enabling durable pub/sub messaging, task
honker.dev·1mo ago
Actian VectorAI DB: A portable vector database for local AI deployment across edge, on-prem, and hybrid systems
Actian VectorAI DB is a portable vector database designed for AI applications that can run locally across embedded, edge, on-prem, and hybri
Product Hunt·2mo ago
Fostrom IoT Cloud Platform: Features for Device Fleet Management
Fostrom is an IoT cloud platform that provides tools for managing fleets of connected devices. Key features include typed payloads with sche
fostrom.io·3mo ago
ESPectre: Wi-Fi CSI-Based Motion Detection System with Home Assistant Integration
ESPectre is an open-source motion detection system that uses Wi-Fi Channel State Information (CSI) analysis to detect movement without camer
github.com·6mo ago