Timescaledb Simple Trial

Timescaledb is a sequential database that has been modified for PG

Installing Tests using Docker

Installation && operation

docker run -d --name timescaledb -p 5432:5432 timescale/timescaledbor 集成postgis  docker run -d --name timescaledb -p 5432:5432  timescale/timescaledb-postgis

Basic use

• Connection

  I use Visual Tools Postico
  

• Database management

-  创建数据库CREATE database dalong;-  切换登陆  可以使用可视化工具，或者命令行工具psql -U postgres -h localhost -d dalong-   创建表CREATE TABLE "public"."user" (    "id" serial,    "name" text,    PRIMARY KEY ("id"));

Create Hypertable

Timescaledb for PG management of the abstract processing, but also the kernel function, understand the basic similarity of memsql, just memsql more direct, do not need to
Correlation processing This step

• Create a basic table
  
• Data additions

Migrating from PG

From the simple use of the above we can not see those different, and the use of PG is basically the same

• Operation method

Mainly divided into the same instance, and different instances of the scene, the specific reference https://docs.timescale.com/v0.9/getting-started/migrating-data

操作比较简单，和普通的使用是一样的，只是有一个转换hypertable 的步骤

Resources

Https://docs.timescale.com/v0.9/faq
Https://docs.timescale.com/v0.9/introduction/timescaledb-vs-postgres

Timescaledb Simple Trial