Top.Mail.Ru
PGConf.Russia 2022 | PGConf.Russia

title

text

PGConf.Russia 2022

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

Thems

  • PostgreSQL technology frontiers for highest workloads, huge databases, mission-critical applications
  • PostgreSQL scalability for transactional and analytical workloads
  • New features in PostgreSQL and around: PostgreSQL and its ecosystem development
  • PostgreSQL for business software applications: system architecture, migration issues and operating experience
  • PostgreSQL specific features and their applications: JSON(b), (geo)Spatial data, Full text search
  • more than
    0 participants
  • 0 speakers
  • 0
    minutes of conversation
  • 35 talks
  • hybrid
    format

Talks

Talks archive

PGConf.Russia 2022
  • Oleg Bartunov
    Oleg Bartunov PostgresPro
    Nikita Glukhov
    Nikita Glukhov PostgresPro

    In this presentation, we'll talk about the newest SQL/JSON features committed to PostgreSQL 15. We'll explain how to use them, where they can help and why they make a difference. Is PostgreSQL JSON implementation fully compliant with SQL:2016? In the meantime, the next generation of the SQL standard is being developed. What will the new standard include, and how will Postgres respond to it?

  • Alexey Fadeev
    Alexey Fadeev Sibedge

    The plv8 extension is very underestimated, though it can help simplify development for a variety of tasks. It's been a year since we started using this extension in our projects. The main reason for its low popularity is the complexity of building. Moreover, building plv8 requires a lot of traffic and disc space for temporary files. That's why we decided to build plv8 and provide ready-made binaries freely to anyone interested, not just as an offering for our customers. First, we made the binaries available on GitHub. Then we created a Docker image for Postgres with pre-installed plv8 based on Debian. It looked too heavy to us, and we decided to check Alpine, however, building it for Alpine appeared to be more complicated than we expected. I'll explain what difficulties we faced and how we managed to overcome them. I will also list the tasks that can be solved with plv8 and provide advice on how to make the development process more convenient. I will also share the links to our Docker images for the latest Postgres 13 and Postgres 14 releases, that are compact and can be used for any types of tasks.

  • Alexander Liubushkin
    Alexander Liubushkin LLC "FORS Telecom"
    Rustam Abdrakhimov
    Rustam Abdrakhimov

    The talk covers the use of PostgreSQL, LUI and LUI4ORA2PG for building an analytical reporting system.

    The talk tackles the following topics:

    • migration from an Oracle environment;
    • application of JSON functions;
    • how the temporary tables helped us;
    • our own means for load testing and bottlenecks detection;
    • how to make beautiful GeoJSON format maps to display diagrams on them;
    • installation and testing of the system on an "Elbrus" computer;
    • what became an obstacle or was missing when using PostgreSQL.

    The history of growth of the Live Universal Interface (LUI) web application development tool and the LUI4ORA2PG migration tool can be found in our previous presentations at PGConf conferences:

    https://pgconf.ru/2019/118109 ;

    https://pgconf.ru/201911/264095 ;

    https://pgconf.ru/2020/262456 ;

    https://pgconf.ru/2021/288310 .

  • A
    Alexander Bychkov Elbrus-2000 LLC
    Н
    Николай Глазков Elbrus-2000 LLC

    This talk covers the Oracle-to-Postgres Pro migration project for the billing system of the Federal State Unitary Enterprise “State Air Traffic Management Corporation of the Russian Federation” employed to collect the air navigation charges for the use of airspace.

All talks

Partners

PGConf.Russia 2022

Informational

Partner