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

PGConf.Russia 2018

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

>500
participants

>50
talks

1440
minutes of networking

Selected talks

Nikolay Ryzhikov

Health Samurai

CTO

Talk

Database driven development with postgresql & clojure

If you honestly evaluate most of our business applications, you will see that they first collect and import the data into a database and then send the same data in the opposite direction.

What if we don't build an ORM wall between the application and the database, but try using the symbiosis of their strong points and special features instead?

I will tell you how we use PostgreSQL and Clojure for building data-intensive medical applications. We will cover the following topics:

functional relational programming
jsonb for modeling complex data domains
functional indexes and json-knife extension for jsonb search
graphql implementation on PostgreSQL
logical replication for building reactive integrations
asynchronous JDBC-free connector to PostgreSQL on netty

Slides

Egor Rogov

Postgres Professional

Expert

Tutorial

Tutorial: More indexes, good and various

"And telling GIN from SP-GIST was quite beyond his wit, we found", said the classic. Can you? This masterclass is about not-so-often used index types (compared to conventional B-tree) which however can do a great job for you. We will look into internal mechanics of these indexes and discuss cases where they can be successfully applied. Also we will talk about some peculiarities of PostgreSQL index access. To spend time efficiently, listeners are required to have basic knowledge of PostgreSQL and should be used to read plans of simple queries.

Materials of the master class

Backup copy of the database with demo data can be downloaded here:

Recovery with pg_restore (338 MB)

Slides

Program All talks

Recall the event

Main partners

Lomonosov Moscow State University

Economics Department of Moscow State University

National center for Digital Economy

Silver partners

Partners

Media partners

Get our latest news!
Subscribe to our news

Feedback