Millions of readings. One database. Full control.

TopoDB is a high-performance time series database for measurement data, continuously developed since 1993. It stores values with fine-grained attribution and permanently retains raw data in parallel with verified editing levels (qualities). It is flanked by a master data and a geo database. In our benchmarks it is faster than InfluxDB and on par with QuestDB.

TopoFlix is our flexible interface: SQL for queries across the time series, master data and geo databases, a REST interface for data ingestion, and a command-line interface for scripting and automation. TopoCast additionally serves applications in the browser.

TopoFlix speaks SQL – tailored to time series. Results come as JSON, ASCII table or HTML table, callable via REST (e.g. wget/curl), from your own programs or through the command-line interface:

SELECT * FROM ser_catalog WHERE Ort="3001005" AND Parameter="Abfluss"

SELECT * FROM
  SELECT zrid FROM ser_catalog WHERE Ort="3001005" AND Parameter="Wasserstand"
WHERE time BETWEEN "1.1.2009 0:00" AND "1.1.2009 2:00"

let zrid = SELECT zrid FROM ser_catalog WHERE Ort="3001005" AND Parameter="Wasserstand"
SELECT AVG,1d   FROM zrid WHERE time BETWEEN "1.1.2009" AND "10.1.2009"
SELECT MAX,1mon FROM zrid WHERE time BETWEEN "1.1.2009" AND "1.1.2010"

The Callisto service retrieves measurement data on schedule from FTP and HTTP(S) servers, process control systems, modems and TCP/IP protocols and stores it directly in the time series database. Your own systems feed in data via the TopoFlix REST interface.

Pulsaro exports time series and reports automatically: freely configurable which data is sent when, in which format (e.g. Delft-PI, UVF) and where to (mail, FTP, file folders) – for example to forecasting models, portals or to fulfil reporting obligations.

Yes. A live demo of TopoDesk runs directly in the browser at topodesk.de – served by our TopoCast web server, no installation required.

Generic time series databases store values – TopoDB understands measurement data. In detail:

Storage: TopoDB stores values in binary files with chained blocks whose size adapts dynamically to the amount of data; an index enables very fast read and write access. A time series with 2.3 million value pairs occupies 18.5 MB – in QuestDB it is 320 MB (17×), while InfluxDB keeps the data in RAM and uses Apache Parquet, which directly affects write performance (see benchmarks).

Raw data and qualities: TopoDB stores changes in higher editing levels without touching the raw data – and only where they occur. On reading, the levels are merged automatically. In InfluxDB or QuestDB you would need parallel tables and move all the management into the application.

Attributes instead of schema conventions: Every time series carries its own attribute set (unit, measured quantity, station, aggregation, sub-location …). With InfluxDB and QuestDB the application has to mix such information in itself.

Time series instead of value pairs: TopoDB manages time series, not just value pairs. Via TopoFlix you can directly query whether daily temperature means exist or only daily maxima – without relying on the application's naming conventions.

For everyone who needs to manage, analyse, process or distribute large volumes of measurement data as time series: water management (gauges, groundwater, precipitation, water quality), energy and agriculture, industrial monitoring, environmental networks and research. Authorities and associations in Germany, Austria and Switzerland have been using our software in production for decades.