This is the demo for my presentation on HighLoad++ Siberia 2019 in Novosibirsk about TimescaleDB and PipelineDB extensions for PostgreSQL.

Here is the announcement of my speech: https://www.highload.ru/siberia/2019/abstracts/5208.

The slides are on speakerdeck or slideshare

Required PostgreSQL running on port 5432 with database schema. It can be done with Docker container:

docker run \
    --name postgres \
    -e POSTGRES_DB="postgres" \
    -e POSTGRES_USER="postgres" \
    -e POSTGRES_PASSWORD="postgres" \
    -v postgres_data:/var/lib/postgresql/data \
    -v ${PWD}/src/main/resources/sql/init.sql:/docker-entrypoint-initdb.d/init.sql \
    -p 5432:5432 \
    -d binakot/postgresql-timescaledb-pipelinedb

Then just build and run the app with your favourite way (e.g. java -jar or IDE).

To package the application into jar file:

./gradlew shadowJar

To build the application docker image:

docker-compose build

To run in Docker with PostgreSQL database:

docker-compose up -d

To stop the application and PostgreSQL database:

docker-compose down --volumes