title

text

Ivan Panchenko
Ivan Panchenko Postgres Professional
11:00 15 March
90 мин

JSON, JSONB, JSQuery

This tutorial is about various applied JSON usage patterns and the related PostgreSQL functionality. We will discuss data storage in the JSON format, retrieving, changing, and searching such data, JSON features for simple SQL queries, as well as using JSON in stored procedures in different languages. You’ll get hands-on experience with some of the discussed problems on the provided virtual machines.

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

Слайды

Видео

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

  • Dmitry Cremer
    Dmitry Cremer МИА "Россия Сегодня"
    22 мин

    Building PostgreSQL from sources for system administrators

    • why we build PostgreSQL from sources?
    • choice build options
    • dependencies
    • creation system environment
    • how to customise Linux for work with PostgreSQL
    • extra soft for PostgreSQL DBA

    VIDEO

  • Andrey Borodin
    Andrey Borodin Яндекс
    45 мин

    GiST speedup: patches, hacks and tweaks

    This report overviews some ideas and implementations to speedup different parts of generalized search trees (GiST): 1. Intrapage indexing 2. Fractal tree technology 3. Modern algorithms for spatial indexing (RR*-tree) 4.. Possible advancements of GiST API

    VIDEO

  • Alvaro Hernandez
    Alvaro Hernandez 8Kdata
    180 мин

    PostgreSQL & Java Tutorial

    Java is one of the most used languages when programming with PostgreSQL databases. Join this tutorial to learn or review the techniques to connect to postgres, best programming practices with JDBC, and to explore jOOQ, a mapper software that allows you to use the full power of SQL and postgres advanced query features while avoiding all the boilerplate code.

    This tutorial is very practical: most of the time will be dedicated to iterate through code samples. It will cover:

    • Introduction to Java and PostgreSQL
    • Ways of connecting to PostgreSQL from Java (not only JDBC!)
    • Introduction to JDBC. JDBC types. PostgreSQL JDBC
    • Code demo: JDBC with PostgreSQL. From Java 1.4 to Java 8, best practices and code samples
    • Code demo: jOOQ, a great mapper for PostgreSQL
    • Java inside PostgreSQL
    • The future of Java and PostgreSQL

    About two-thirds of the tutorial will be dedicated to iterate over code samples and demos. All the code would be available from public open-source repositories and built with maven, so that any attendee may download it and build easily to play with it during the tutorial (although not required).

    VIDEO

    Part 1

    Part 2

    Part 3

    Part 4

  • Peter Gribanov
    Peter Gribanov
    22 мин

    1C:Enterprise business platform: working with PostgreSQL

    "1C:Enterprise" is the most popular in Russia/Eastern Europe business applications development framework supports PostgreSQL for 10+ years. We'll review some cases and pecularities of 1C and PostgreSQL tandem.