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-pipelinedbThen just build and run the app with your favourite way (e.g. java -jar or IDE).
To package the application into jar file:
./gradlew shadowJarTo build the application docker image:
docker-compose buildTo run in Docker with PostgreSQL database:
docker-compose up -dTo stop the application and PostgreSQL database:
docker-compose down --volumes