Tutorial: Advanced spatial analysis with PostgreSQL, PostGIS and Python

PGConf.Russia 2018

February 05 – 07 |
Lomonosov Moscow State University, Moscow, Russia

What is PGConf.Russia 2018?

About

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.

i

When and Where

February 05 – 07, 2019
Lomonosov Moscow State University,
Faculty of Economics, Moscow, Russia, 1-46 Leninskiye Gory

Attendees

PostgreSQL DBAs
PostgreSQL core and extension developers
Application developers
System architects
IT-managers
Database migration engineers and managers.

Main topics

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.

>500
participants

>50
talks

1440
minutes of networking

Selected talks

Camille Islamov

Троник

Разработчик СУБД

Talk

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.

Slides

Alexander Korotkov

Postgres Pro

Chief developer

Talk

Credereum – blockchain-enabled Postgres

Bringing the provability and immutability of blockchain to performance and efficiency of traditional DBMS.

Blockchain technology has several unique properties including provability and immutability. Every blockchain transaction is signed by its author, and it could be verified by any blockchain network member. Also, once data is stored in blockchain, it can't be altered in the future. Many databases operating traditional DBMS would also benefit from provability and immutability properties. However, inclusion of all the transaction data in the public blockchain is very expensive.

Credereum is the platform, which allows creation and maintaining of databases, whose contents and history are provable and immutable without sacrifice the performance and efficiency of traditional DBMS. Thanks to Credereum, database owner can prove the validity of query results, while users can verify them. Database owner don't have to reveal the whole database contents or full history of transactions to provide the proof of database query results. Therefore, Credereum database may contain private sensitive information. Credereum utilized bleeding-edge technologies including, but not limited to decentralized cloud, public blockchain with sharding. Credereum is an emerging technology of trusted and private databases.

We will explain why PostgreSQL is suitable database for Credereum and what we need to develop in Postgres to support signed transactions and cryptographic storage.

Slides

Program All talks

Recall the previous event

Conference Organizer
Postgres Professional

Main partners

Lomonosov Moscow State University

Economics Department of Moscow State University

National center for Digital Economy

Silver partners

Partners

Souvenir

Сhocolate

Technical support

Media partners

Get our latest news!
Subscribe to our updates

Feedback