Database Explorer
This page offers a graphical interface for exploring the project's databases.
InfluxDB is a time series database designed for efficient management of timestamped data, such as sensor data, server logs, and performance metrics. To retrieve data from InfluxDB, one needs to execute queries, i.e., ask questions to the database with parameters indicating constraints on the desired data. These parameters can include specific time intervals, conditions on field values, and more. InfluxDB queries can be used to extract, filter, and aggregate data according to user needs, enabling analysis and visualization of meaningful information from stored data.
To download data, it is necessary to configure all the required fields within the page according to one's needs. The application will use these parameters to create queries that will then be submitted to the database.
As seen in Image A, the fields to fill in are:
Limit: the maximum number of rows to return. If the number of rows in the time interval exceeds this limit, only the first rows up to the limit will be returned;
Start Date: the initial instant of the time interval of interest;
End Date: the final instant of the time interval of interest;
Database: the name of the database to use for the query. It refers to the database within which to search for data;
Retention Policy: the retention policy used for the table of interest. It allows distinguishing among the various tables; in fact, depending on the selected policy, the tables to which it refers are suggested;
Measurement: the table from which to download the data.
After clicking the Get Data button, the query results will be displayed within the page in tabular form.
The data in the displayed table can be downloaded in .csv format via a dedicated button.