Teodor Sigaev
Teodor Sigaev Postgres Professional
Anton Doroshkevich
Anton Doroshkevich ИнфоСофт
14:30 04 February
45 мин

"The world 1C" waiting for PostgreSQL

One of the most widespread branches of PostgreSQL distribution in Russia is 1C. In the report I would like to share thoughts about what is missing in PostgreSQL according to 1C



Другие доклады

  • Ivan Panchenko
    Ivan Panchenko Postgres Professional
    90 мин

    JSON use cases

    In this tutorial, we will solve several programming problems using JSON functionality that extends SQL capabilities and virtually turns a relational database into an almost ready-to-use application server. :)
    We will learn how to use aggregates, both standard and custom, as well as review possible benefits of JSON recursive structure.

  • Teodor Sigaev
    Teodor Sigaev Postgres Professional

    Postgres Pro Enterprise features

    Postgres Pro Enterprise features description from the developers.

  • Pavel Stehule
    Pavel Stehule freelancer
    90 мин

    The possibilities of profiling plpgsql code - available tools

    I like stored procedures - it is great technology. But like any other technologies it allows to write not well optimized code. It is not easy to write optimized code, sql statements in complex large applications. On second hand, there are some tools, that can be used very easily, that can help. Postgres has built-in tracking functions possibility. There are PLProfiler and plpgsql_check. With these tools is easy work to detect slow part of applications.With this knowledge, the fix of performance issue is less magic.

  • Александр Чирков
    Александр Чирков Барс Груп
    Александр Кварацхелия
    Александр Кварацхелия БАРС Груп
    45 мин

    Migration from Oracle to PostgreSQL using an automatic converter

    In the report, we want to talk about the experience of migrating one large system from Oracle to PostgreSQL. The system itself was built on the PHP + Oracle stack; its distinguishing feature was that all business logic was implemented in PL / SQL code. In a DBMS, there are more than 3000 packages with 4-10 functions (procedures) in each. In PHP - more than 10,000 forms with inserts of anonymous blocks used to receive data, process and save results in Oracle.

    To solve this extremely voluminous work, we took ANTLR4 (a powerful parser generator for reading, processing, executing, or translating structured text), PL/SQL grammar, and created an automatic converter that allows you to convert all objects in the schema and our system from Oracle to working code for PostgreSQL.