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
Слайды
Другие доклады
-
45 мин
Илья Космодемьянский Data EgretLinux IO internals for PostgreSQL administrators
Input-output (IO) performance issues have been on DBAs’ agenda since the beginning of databases. The volume of data grows rapidly and time is of an essence when one needs to get necessary data fast from the disk and, more importantly, to the disk.
For most databases it is relatively easy to find checklist of recommended Linux settings to maximize IO throughput and, in most cases, this checklist is indeed good enough. It is however essential always to understand how the optimisation of those settings actually works, especially, if you run into corner cases.
-
45 мин
Dmitry Yuhtimovsky Gilev.ruDebugging 1С code in PostgreSQL DBMS
- 1C:Enterprise 8 and PostgreSQL 9 interoperability 1.1 Changes in new 1C platform versions 1.2 v81c_data and v81c_index schemas 1.3 Sending 1C queries to SQL 1.4 Using 1C technological log events for PostgreSQL diagnostics
- Analyzing queries that affect PostgreSQL performance 2.1 A free tool for automating log parsing 2.2 Pareto principle in action 2.3 Installation and configuration of the tool 2.4 A case study of query optimization 2.4.1 An issue in a PostgreSQL query 2.4.2 Finding non-optimal operations in a query 2.4.3 Resolving inefficiencies
- PostgreSQL statistics for performance diagnostics 3.1 Comparing Postgres with MS SQL Server 3.2 Troubleshooting locks 3.3 Operating load diagnostics 4 Case studies by the gilev.ru team
-
90 мин
Egor Rogov Postgres ProfessionalProBackup: fast, reliable, and incremental
Modern state of backup tools for PostgreSQL certainly leaves some room for improvements. Standard utilities provides only basic functionality, third-party tools solve some, but not all, problems. To take backups reliably, fast, and incrementally on page level, one needs not only a backup tool, but also some support from the database server. On this tutorial we will talk about our new backup and recovery manager ProBackup, and will show it in action.
Demonstration script:
-
45 мин
Darafei Praliaskouski JunoPostGIS for moving targets
PostGIS enables spatial processing in Postgres. Usually PostGIS is used for planar euclidean calculations, but real world adds time, ambiguity and uncertainty. We'll have a look on making a thousand of cars move smoothly in real time on OpenStreetMap base map.
VIDEO