title

text

Andrey Hitrin
Andrey Hitrin RedSys
Alexander Fedorov
Alexander Fedorov dbeaver.com
12:15 06 February
45 мин

Open Source IDE for Postgres

DBeaver is the Universal Databases Manager. We creating DBeaver using Open Source Software model. We pay special attention to the PotgreSQL because of its capabilities, popularity and OSS nature. We will talk about DBeaver evolution and structure, will demonstrate the basic functionality. We are going to cover challenges of PostgreSQL client creation. Also we will discuss requirements management model and interaction with the PostgreSQL community. We will show in details how to debug the PL/pgSQL stored procedures interactively. We are going to introduce some new features of the nearest DBeaver release and to share our plans.

Материалы к докладу

Слайды

Видео

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

  • Alexander Korotkov
    Alexander Korotkov Postgres Professional
    45 мин

    Credereum – blockchain-enabled Postgres

    Bringing the provability and immutability of blockchain to performance and efficiency of traditional DBMS.

    Blockchain technology has several unique properties including provability and immutability. Every blockchain transaction is signed by its author, and it could be verified by any blockchain network member. Also, once data is stored in blockchain, it can't be altered in the future. Many databases operating traditional DBMS would also benefit from provability and immutability properties. However, inclusion of all the transaction data in the public blockchain is very expensive.

    Credereum is the platform, which allows creation and maintaining of databases, whose contents and history are provable and immutable without sacrifice the performance and efficiency of traditional DBMS. Thanks to Credereum, database owner can prove the validity of query results, while users can verify them. Database owner don't have to reveal the whole database contents or full history of transactions to provide the proof of database query results. Therefore, Credereum database may contain private sensitive information. Credereum utilized bleeding-edge technologies including, but not limited to decentralized cloud, public blockchain with sharding. Credereum is an emerging technology of trusted and private databases.

    We will explain why PostgreSQL is suitable database for Credereum and what we need to develop in Postgres to support signed transactions and cryptographic storage.

  • Konstantin Khomyakov
    Konstantin Khomyakov Кнопка
    Sergei Starikov
    Sergei Starikov Кнопка
    45 мин

    How to stop being afraid of stereotypes when choosing DBMS for 1C

    «KNOPKA» («The button»), the largest outsourcing of accounting, will tell you about your experience of transferring 500Gb of 1C Fresh databases to PostgreSQL. The report touches on the choice of DBMS and the fight against stereotypes, where we started and how developed the use of PostgreSQL, the approaches to backup and recovery of information security, our current performance of DBMS and 1C, a look into the future. Let us share why we believe that 1C + PostgreSQL is simple, reliable and fast.

  • Alex Lustin
    Alex Lustin SilverBulleters, LLC
    45 мин

    Docker, PostgreSQL, Production ....

    I would like to share experience in runing PostgreSQL in dockerized environments, describe the specific issues and tools you will need to solve them.

    • Which problems could be solved by Docker for PostgreSQL, e.g. PostgreSQLPro.9.6
    • Work of IT team with Docker in development, testing and production environments
      • Using image repository and build servers for image testing
    • Issues in production environment:
      • With network activity
      • With persistent repositories for Docker
      • With additional services
      • With load balancing and fail-safety
    • Running PostgreSQL-base applications, such as:
      • SonarQube
      • Gitlab
      • 1С platform

  • Sergei Kim
    Sergei Kim Ingram Micro Cloud
    Vadim Yatsenko
    Vadim Yatsenko Tantor Lab
    45 мин

    PostgreSQL High Availability cluster for Enterprise

    Lately, the PostgreSQL is more widely being used for Enterprise. Our company, Ingram Micro Cloud, is one of the first companies that did it. We have been using PostgreSQL for many years as the main DBMS for our products. In our report, we want to tell about the evolution of our High Availability (HA) PostgreSQL cluster. We will tell about how quickly we implemented the solution using pgpool-II, wrote failover scripts, tested Postgres-XL, and came up with unusual configurations of Stolon. We will also cover the problems of load balancing, pooling connections, and backups.