PGConf.Russia 2018

Lomonosov Moscow State University, Moscow, Russia

Talks
Photo

PGConf.Russia 2018

PGConf.Russia is a leading Russian PostgreSQL international conference, annually taking together more than 500 PostgreSQL professionals from Russia and other countries — core and software developers, DBAs and IT-managers. The 3-day program includes training workshops presented by leading PostgreSQL experts, more than 40 talks, panel discussions and a lightning talk session.

Thems

PostgreSQL at the cutting edge of technology: big data, internet of things, blockchain
New features in PostgreSQL and around: PostgreSQL ecosystem development
PostgreSQL in business software applications: system architecture, migration issues and operating experience
Integration of PostgreSQL to 1C, GIS and other software application systems.

more than
0 participants
0 speakers
0
minutes of conversation
54 talks
offline
format

Alex Lustin SilverBulleters, LLC
Docker, PostgreSQL, Production ....

I would like to share experience in runing PostgreSQL in dockerized environments, describe the specific issues and tools you will need to solve them.
- Which problems could be solved by Docker for PostgreSQL, e.g. PostgreSQLPro.9.6
- Work of IT team with Docker in development, testing and production environments
  - Using image repository and build servers for image testing
- Issues in production environment:
  - With network activity
  - With persistent repositories for Docker
  - With additional services
  - With load balancing and fail-safety
- Running PostgreSQL-base applications, such as:
  - SonarQube
  - Gitlab
  - 1С platform
Presentation materials
Olivier Courtin DataPink
Tutorial: Advanced spatial analysis with PostgreSQL, PostGIS and Python
- Spatial and advanced spatial analysis with pure PostGIS (including cutting edge PostGIS functions available)
- How could we mix and tied efficiently PostgreSQL and Python data types (as NumPy ndarray, and Pandas DataFrames)
- Tools to improve our data manipulation environment (Jupyter tricks, easy dataviz...)
- How to go further throught GeoDataScience, with Python libs and framework tied with PostgreSQL/PostGIS (including Machine and DeepLearning)
Presentation materials
Максим Милютин Wildberries

Dmitry Ivanov PostgresPro

Vanilla and external partitioning in PostgreSQL

Presentation materials
Kamil Islamov Stickeroid Ai

PostgreSQL and MQTT as IoT data processing solution

MQTT is an effective data exchange protocol for IOT devices. Based on own modified EMQTT plug-in, the IoT project architecture uses PostgreSQL as a central processing and storing system for data coming from sensors in real time. The report will provide an example of the IoT hardware and software platform solution, based up on the MQTT protocol, where PostgreSQL is responsible for key functionality, providing processing, collecting and storage of data from a distributed network of IoT devices.

Presentation materials