title

text

Ivan Panchenko
Ivan Panchenko Postgres Professional
12:00 03 February
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.

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

Слайды

Видео

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

  • Алексей Лесовский
    Алексей Лесовский PostgreSQL Consulting LLC
    45 мин

    PostgreSQL Scaling Usecases

    Today no one is surprised by cloud infrastructure anymore, but not all its components are easy to deploy in cloud. For example, the database is always very demanding in terms of performance and resources. Scaling and fault tolerance are the most acute problems, that's why we have been observing rapid development of alternative DBMS in the recent years. However, traditional relational DBMS have already accumulated a lot of various features, so they often remain the first choice. Besides, they are constantly evolving and offer a wide variety of scaling tools. I will mainly speak about PostgreSQL, when you should consider scaling, and how to do it right.

    We will touch upon the following topics:
    - Streaming replication and balancing read/write workloads
    - Logical replication and data sharding
    - High availability and fault tolerance

    This talk should be interesting to DBAs, system administrators, team leads, infrastructure architects, as well as wider audience dealing with PostgreSQL.

  • Pavel Luzanov
    Pavel Luzanov Postgres Professional
    45 мин

    PostgreSQL Certification Program: questions and answers.

    In May 2019 «Postgres Professional» launched the PostgreSQL Certification Program. Now you can not only get training in our courses, but also confirm your knowledge by passing an appropriate set of tests.

    In this presentation, I will share the results of the first months of the program and answer the most frequently asked questions:

    Where can I get information about the certification program?
    PostgreSQL or Postgres Pro certification?
    Certificates for PostgreSQL version 10. When will you upgrade to the current version?
    Do I have to attend training centers?
    Can I pass the test remotely? Not in Moscow?
    Is it possible to take several tests at once in one day?
    How to prepare for the test? Are there any examples of training questions?
    During the test I got an incorrect question, what should I do?
    How to find out exactly which questions the answers were not correct?
    When can I retake after an unsuccessful attempt?
    How to appeal the test results? 
    

  • Dmitry Ursegov
    Dmitry Ursegov Postgres Professional
    22 мин

    Working with external data in Greenplum, examples of Kafka and ClickHouse connectors development

    Greenplum is a horizontal scalable database based on PostgreSQL core. It is used for OLAP workloads and a standard task is to quickly load or unload large amounts of data. The external data resources are usually another distributed systems. In this talk I will show how Greenplum can work with external data. What is the architecture and performance of external and foreign tables and how to handle streaming data. What will be changed in the next version. The examples of Kafka and ClickHouse connectors development.

  • Christopher Travers
    Christopher Travers DeliveryHero SE
    45 мин

    Introducing Bagger: Massive Application Log Management on PostgreSQL

    This talk discusses the open source components we use at Adjust to manage a massive number (5+PB) of application log messages on PostgreSQL in a massively multi-parallel way. It provides both a use case for PostgreSQL in a big data (high volume/velocity/variety) environment, and can be used to show the power of PostgreSQL with JSONB, GIN, and more.

    This talk covers the capabilities of the components in depth, sufficient to inspire similar solutions.