Conference Schedule - PGConf.EU 2014


PostgreSQL and Java

Date: Oct. 21, 2014
Time: 13:30 - 17:00
Room: Medici III
Level: Intermediate

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, advanced JDBC, and to be introduced to MyBatis and jOOQ, software frameworks that allow you to use the full power of SQL and PostgreSQL's advanced query features, while avoiding all the boilerplate code. This tutorial is very practical: a significant part of the time will be dedicated to learn through code samples.

This tutorial 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.
  • Introduction to MyBatis, a great mapper for PostgreSQL. Code demo.
  • Introduction to jOOQ, get back in control of your SQL. Code demo.


Alvaro Hernandez