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

Bruce Momjian

EnterpriseDB

Senior Database Architect

Tutorial

Exploring Common Table Expressions and Window Functions

Developers are often challenged to deliver results that are hard to implement using simple SQL queries. Fortunately, complex SQL capabilities exist in the SQL standards — common table expressions and window functions.

SQL is a declarative language, meaning the user submits an SQL command and the database determines the optimal execution. Common Table Expressions (CTEs) allow queries to be more imperative, allowing looping and processing hierarchical structures that are normally associated only with imperative languages.

Normal SQL queries return rows where each row is independent of the other returned rows. SQL window functions allow queries to return computed columns based on values in other rows in the result set.

This tutorial will help developers use CTE queries in their applications and allow operations that normally could only be done in application code to be done via SQL queries. It also explains the many window function facilities and how they can be used to produce useful SQL query results.

Video

Part I «Programming the SQL Way with CTE»

Part II «Postgres Window Magic»

Slides Slides

Ivan Panchenko

Postgres Professional

Deputy Director General

Tutorial

Full text search from A to Ω

Tutorial on Full Text Seach in PostgreSQL, containing all recent improvemets. All recipies necessary for building an application will be given: dictionary and parser configuration, faceted search, fuzzy search, multilanguage search, ranking etc. Participants will be provided with a test database for exercises.

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

Media partners

Get our latest news!
Subscribe to our updates

Feedback