最近因为项目需要,接触了时序数据库:influxdb、TDengine
由于 influxdb 是单机开源,因此我在查资料的时候,看到挺多从 influxDB 转到 TDengine 的,以下是两者的对比。
docker-compose.yml
version: '2'
services:
tdengine:
image: tdengine/tdengine:2.2.0.5
container_name: tdengine
hostname: tdengine
ports:
- 6030:6030
- 6035:6035
- 6041:6041
- 6030-6040:6030-6040/udp
volumes:
- /etc/localtime:/etc/localtime:ro
- /etc/timezone:/etc/timezone:ro
- /data/volume/tdengine/lib:/var/lib/taos:Z
- /data/volume/tdengine/log:/var/log/taos:Z
restart: always
tty: true
进入容器:
docker exec -it tdengine /bin/bash
进入数据库,执行:
taos
体验 TDengine
CREATE DATABASE demo;
USE demo;
CREATE TABLE t (ts TIMESTAMP, speed INT);
INSERT INTO t VALUES('2019-07-15 00:00:00', 10);
INSERT INTO t VALUES('2019-07-15 01:00:00', 20);
SELECT * FROM t;