Billions of readings. One database.
Full control.

TSDB 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, accessed through TopoFlix, it is faster than InfluxDB and on par with QuestDB.

The TSDB time series database is part of TopoFlix. Two interfaces are always available: SQL for queries across the time series, master data and geo databases, and Line Protocol for ingestion – plus a command-line interface for scripting and automation. In addition, the system can be operated through a GUI in the browser (configure, visualise, export and import). Optionally, the TopoCast web server serves ready-made 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 Location="3001005" AND Channel="Discharge"

SELECT * FROM
  SELECT tsid FROM ser_catalog WHERE Location="3001005" AND Channel="water level"
WHERE time BETWEEN "2009-01-01Z00:00:00" AND "2009-01-01T02:00:00"

Let tsid = SELECT tsid FROM ser_catalog WHERE Location="3001005" AND Channel="water level"
SELECT AVG,1d   FROM tsid WHERE time BETWEEN "2009-01-01T00:00:00" AND "2009-01-10T00:00:00"
SELECT MAX,1mon FROM tsid WHERE time BETWEEN "2009-01-10T00:00:00" AND "2009-10-10T00:00:00"

The TopoRello 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 (SQL, JSON, Line Protocol).

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 carry out 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.

TopoWeb is a construction kit of ready-made applications that can be assembled into an application of your own. It does not run alongside our TopoCast web server but on it – just like our purpose-built applications, only assembled from building blocks instead of written from scratch.

Other time series databases store values – TopoFlix manages time series data. In detail:

Storage: TopoFlix 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 (about 3–5× slower in writing than TopoFlix, see benchmarks).

Raw data and qualities: TopoFlix stores changes in higher editing levels without touching the raw data – and only where the changes 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: TopoFlix deals with 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. Water Authorities and associations in water management in Germany, Austria and Switzerland have been using our software in production for decades.