Distributed workflow specifics in PostrgeSQL
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.
Слайды
20170317H3_Delgyado-1.odpДругие доклады
-
Yury Zhukovets ЗАО Дилжитал-Дизайн
Migrating DocsVision EDMS from MS SQL to Postgres
This talk is about migrating an electronic document management system from MS SQL to PostgreSQL 9.5 or higher as part of the import phaseout initiative. We will touch upon architecture specifics, as well as describe the problems we encountered when migrating T-SQL code to pgsql, and how we resolved them.
Learn more at https://pgconf.ru/news/94168
VIDEO
-
Ivan Frolkov Postgres Professional
Relocatable tables in PostgresPro
With big data threads, even the upload of data to a database can often be problematic – apart from the data upload itself, you need to create indexes, perform VACUUM after the upload for correct Index-only scans, etc. From this talk, you will learn how to avoid most of such problems (if not all of them).
VIDEO
-
Alvaro Hernandez 8Kdata
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
-
Dmitry Lebedev BestPlace
Researching GIS data with PostGIS and adjacent toolset
Nowadays one can make a decent urban research based simply on public datasets, making interesting and unexpected insights. In the presentation, I'll show examples of these calculations in PostGIS, the industry standard de-facto.
But just PostGIS is not enough. You need tools to import, verify and visualize the data. It's critically important to visualize the data live, to debug your calculations and shorten iterations. I'll describe all these steps:
- Collecting the data: public API, OpenStreetMap; direct user input.
- 3rd party APIs for calculations.
- Visualization of GIS and other sorts of data: QGIS, Matplotlib, Zeppelin integrated with PostGIS.
- Debugging the calculations: live visualization (Arc, QGIS, NextGIS Web)
- Scripting and minimizing the chores: Makefile, Gulp