PgConf.Russia 2017

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

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

VIDEO

When working with a complex business logic, you often have to implement a workflow - a sequence of several processing steps, with each step implementing a separate part of the business logic. This is usually done with specialized queues, but if there are high reliability demands, it makes sense to do everything on PostgreSQL.

I will describe the tasks that require a workflow implementation, offer a solution, compare it with other options, and tell you about the implementation traps and pitfalls.