title

text

March 15 – 17 , 2017

Postrelease

  • more than
    0 participants
  • 0 speakers
  • 0
    minutes of conversation
  • 63 talks
  • offline
    format

Talks

Talks archive

PgConf.Russia 2017
  • Alvaro Hernandez
    Alvaro Hernandez 8Kdata

    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

  • Marco Slot
    Marco Slot Citus Data

    Citus allows you to distribute postgres tables across many servers. It extends postgres to transparently delegate or parallelise work across a set of worker nodes, enabling you to scale out the CPU and memory available for queries.

    One year ago, we began a long journey to allow Citus to scale out another dimension: write throughput. With writes being routed through a single postgres node, write throughput in Citus was ultimately bottlenecked on the CPUs of a single node. Citus MX is a new edition of Citus which allows distributed tables to be used from from any of the nodes, enabling NoSQL-like write-scalability.

  • Igor Chizhevskiy
    Igor Chizhevskiy SRC "Voshod"
    Sergey Korolev
    Sergey Korolev MCST
    Dmitry Pogibenko
    Dmitry Pogibenko FGBU "NII Voskhod"
    Stanislav Merzlyakov
    Stanislav Merzlyakov Scientific Research Institute "Voskhod"
    Илья Космодемьянский
    Илья Космодемьянский Data Egret
    Иван Богданов
    Иван Богданов SRC "Voshod"

    Practical experience of carrying out import substitution with using PostgreSQL in government information system including not only the free software, but also the Russian hardware (Elbrus servers and other).

    VIDEO

  • Andreas Scherbaum
    Andreas Scherbaum Pivotal Ltd

    Overview of the architecture of Greenplum MPP (Massively Parallel Processing) database. Explain the internals of GPDB. Show how to configure and setup GPDB. How to distribute data effectively for MPP

    VIDEO

All talks