DEV Community

loading...
Cover image for Up and running with TimescaleDB

Up and running with TimescaleDB

Ali Raza
Lead Expectations Engineer. Dreamer and Builder of Software
・1 min read

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.

Discussion (1)

Collapse
hasanmehmood profile image
Hassan Mehmood

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

Forem Open with the Forem app