Skip to content

PostgreSQL + PostGIS + TimescaleDB for telematics & telemetry

Notifications You must be signed in to change notification settings

binakot/PgConf-2019-Moscow-Demo

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

6 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

🐘🐘🐘 PgConf.Russia 2019 🐘🐘🐘

Demo Project

This is the demo for my presentation on PgConf.Russia 2019 in Moscow.

Here is the announcement of my speech: https://pgconf.ru/2019/242909.

The slides are on speakerdeck or slideshare

The database contains a schema for demonstration of the idea to work with telematics and telemetry via PostgeSQL.

Getting Started

To run this demo you need Docker with docker-compose.

Just type the command docker-compose up -d from this folder. After all type the docker-compose down to stop the demo.

Content

There are the stack of two applications via docker-compose yaml file with:

  • Postgres 11.1 + PostGIS 2.5.1 + TimescaleDB 1.1.1

  • PgAdmin 4 (admin@pgconf.ru / admin on http://localhost:5433)

To get access from pgAdmin4 you need to use next connection settings:

Host: postgres
Port: 5432
MaintenanceDB: postgres
Username: postgres
Password: postgres