Up and running with TimescaleDB

I've been getting into time-series databases over the past few months. I got into playing with TimescaleDB and was super impressed with its capabilities. One of the important things to understand is that TimescaleDB is just Postgres at its core which means technically TimescaleDB is an extension. Following is my usual MO to quickly run an instance of TimescaleDB.

Getting a docker container up:

docker run -d --name timescaledb -p 5434:5434 -e POSTGRES_PASSWORD=password timescale/timescaledb:latest-pg11

Connecting to said docker container:

docker exec -it timescaledb psql -U postgres

Creating your database:

CREATE database tstutorial;

Connecting to your new database:

\c tstutorial

Adding the TimescaleDB extension:

CREATE EXTENSION IF NOT EXISTS timescaledb CASCADE;

That's it! Now you have a dockerized TimescaleDB instance up and running.

Comments

[Hassan Mehmood]

Good read! and a quick way to start with TimescaleDB.