PHP implements open source InfluxDB time series database

With the continuous development of Internet technology, data processing and management are becoming more and more important. Especially with the rise of the Internet of Things (IoT) and big data, time series data processing has become increasingly important. In this context, InfluxDB time series database has become the choice of more and more people.

InfluxDB is a distributed open source database specially designed to store and query time series data. It specifically solves the problem of writing and querying time series data, and also has powerful aggregation and visualization functions. Compared with relational databases, InfluxDB is more lightweight and efficient, and is especially suitable for large-scale real-time data processing scenarios. This article will introduce how to use PHP to implement InfluxDB time series database.

1. Overview of InfluxDB

InfluxDB is an open source distributed time series database that is efficient, scalable and easy to use. InfluxDB stores data in a schema-less data structure, allowing users to index or query data ad hoc on demand. InfluxDB supports high throughput writes and fast complex queries, making it the first choice in areas such as IoT, real-time analytics and monitoring.

The data structure of InfluxDB consists of time series and data points. A time series is a collection of data stored in chronological order. Each data point contains three parts: timestamp, tag and field. The timestamp is the unique identifier of the data point, the label is the metadata of the data point, used to describe the characteristics of the data point, such as sensor ID, location, etc., and the field is the actual data of the data point.

InfluxDB provides a variety of APIs and tools to easily write, query and visualize data.

2. Use PHP to access InfluxDB

Using PHP to access InfluxDB requires installing the influxdb-php extension, which can be installed using Composer. After installation, you can use InfluxDB related classes in PHP programs to interact with the database.

The following is a simple example that demonstrates how to use PHP to write data to InfluxDB:

<?php

require_once __DIR__ . '/vendor/autoload.php';

use InfluxDBClient;
use InfluxDBPoint;

$client = new Client([
    'host' => 'localhost',
    'port' => 8086,
    'username' => 'username',
    'password' => 'password',
    'database' => 'database'
]);

$point = new Point(
    'weather_temperature', // 表名
    30.0, // 温度
    ['location' => 'beijing'], // 标签
    ['unit' => 'celsius'], // 字段
    time() // 时间戳
);

$client->write([$point]);

The above code first creates an InfluxDB client and sets the connection parameters and database name. Then a data point object Point is created, and information such as table name, label, field and timestamp are set. Finally use the client object to write the data points to the database.

3. Use InfluxQL to query data

InfluxQL is the query language of InfluxDB. It is similar to SQL, but pays more attention to the processing and aggregation of time series data. The following is a simple InfluxQL query example to query the temperature data of a certain sensor within 10 minutes:

SELECT mean("temperature") FROM "sensors" WHERE "sensor_id" = '123' AND time > now() - 10m GROUP BY time(1m)

You can use the Query class in the influxdb-php extension to write and execute InfluxQL queries. The following is a simple example:

 'localhost',
    'port' => 8086,
    'username' => 'username',
    'password' => 'password',
    'database' => 'database'
]);

$query = new Query('SELECT mean("temperature") FROM "sensors" WHERE "sensor_id" = '123' AND time > now() - 10m GROUP BY time(1m)', 'database');
$results = $client->query($query);

print_r($results);

The above code first creates an InfluxDB client object, then creates a Query object and sets the query statement and database name. Finally, use client object query to execute the query and output the results.

4. InfluxDB data visualization

The data in InfluxDB can be visually displayed using data visualization tools such as Grafana. Grafana is an open source data visualization and monitoring platform that supports multiple databases such as InfluxDB and can easily build rich data dashboards through a web interface.

Using Grafana requires first installing and configuring the Grafana server. For specific installation steps, please refer to Grafana official documentation.

After installation, add the InfluxDB data source in Grafana, and then create a data dashboard to display the data in InfluxDB. Grafana supports a variety of different chart types and data display methods, which can be selected and configured as needed.

5. Summary

This article introduces the basic concepts and usage of InfluxDB time series database, and also introduces the related classes for PHP to access InfluxDB and the use of InfluxQL query language. InfluxDB's lightweight, efficient and easy-to-use features make it one of the first choices for time series data processing. I hope this article will be helpful to you in learning and using InfluxDB.

The above is the detailed content of PHP implements open source InfluxDB time series database. For more information, please follow other related articles on the PHP Chinese website!