31 March – 01 April 2025
PGConf.Russia 2025
PGConf.Russia is the largest PostgreSQL conference in Russia and the CIS. The event offers technical sessions, hands-on demos of new DBMS features, master classes, networking opportunities, and knowledge exchange with top PostgreSQL community experts. Each year, hundreds of professionals participate, including DBAs, database architects, developers, QA engineers, and IT managers.
Agenda highlights
-
Latest news and updates from the PostgreSQL global community
-
Monitoring, high availability, and security
-
Streamlined migration from Oracle, Microsoft SQL Server, and other systems
-
Query optimization
-
Scalability, sharding and partitioning
-
AI applications in DBMS
-
PostgreSQL compatibility with other software
Talks
Talks archive
-
Karel van der Walt MentalArrowExperience Report addressing the manual migration of MS SQL Server Stored Procedures and Table-Valued Functions to PL/pgSQL. We chose a manual migration from T-SQL over using a PostgreSQL Extension with an automated translation. The motivation was that the T-SQL code contains non-trivial business logic for which we wanted idiomatic PL/pgSQL code.
The T-SQL Code used features like
-
Mix of Stored Procedures and Table-valued Functions
-
Table variables, (user-defined) table types
-
Recursive Common Table Expressions
-
Optional parameters
The migration required
-
Adopting naming conventions
-
Renaming parameters and local variables
-
Maping table types
-
Mapping table-valued parameters to arrays
-
Mapping table-valued return types to SETOF record
-
Translating between arrays and tables
In this session we will migrate a chain of dependend functions T-SQL functions to PL/pgSQL. We will work around quirks in both T-SQL functions and PL/pgSQL.
-
-
Вадим ВойтенкоGreenmask is an open-source utility for database anonymization and synthetic data generation. A common challenge in development is creating test environments that closely resemble production. In this talk, we will explore how to use Greenmask’s features to prepare a test environment with ease.
We will discuss its architecture, database subsets, types of transformations, the reasons for integrating with the PostgreSQL driver, and porting some pg libraries. Additionally, we will explain how our technology helps businesses solve problems faster, more efficiently, and securely.
-
Alexey Fadeev sibedgeTwo years ago, I spoke about data retrieval queries, where the LINQ to DB library offers almost limitless possibilities.
This talk is about data modification operations. LINQ to DB allows you to execute UPDATE + JOIN queries, INSERT FROM SELECT, supports the MERGE operator, row-level locking with SELECT FOR UPDATE, temporary table creation, and features a fast data insertion mechanism.
I will also discuss the linq2db. EntityFrameworkCore project — a solution for those who aren’t ready to leave EF Core but still want the capabilities of LINQ to DB. I’ll share our experience implementing LINQ to DB in a large-scale project.
-
Вячеслав Малютин ГНИВЦIn some cases, business logic is implemented directly within the database. It's well known that maintaining and developing business logic becomes much easier when it's covered by tests. However, backend tests often treat the database as an external resource and don’t always interact with a live database.
This talk will introduce an enhanced version of the pgTap library, designed not only to facilitate unit testing and CI for database code but also to accelerate the development process itself.
Photos
Photo archive