Upcoming presentations
No upcoming presentations...
Past presentations
Functions are among the most underused and misused of PostgreSQL objects. Since all modern programming languages include user-defined functions, people often assume that database functions are cut from the same cloth and if you know how to write functions and when to write functions in an application programming language, you can apply this knowledge to PostgreSQL. This could not be further fro...
Some queries just can’t run in a fraction of a second, no matter how well written. This does not mean they can’t be optimized. Many practitioners hold that since analytical reports do not have strict response time requirements, it is not important how fast or slow they run. In extreme cases, report developers make no effort to make sure that reports are complete in a reasonable time, giving the...
Today, Chicago PUG is the third-largest in the Western Hemisphere, but it was not the case three years ago. It is easy to announce a new User Group, but how to keep it running and growing? Nobody expected new pandemic and the effect it will take on our lives. The Open Source communities, including Postgres community, which live and breath live discussions, were hit heavily. How did we manage? W...
Life without ORM - is it possible and how we can get there? In this talk, Hettie will present the approach developed and implemented at Braviant Holdings. NORM (No-ORM) allows building performant and scalable applications and is praised by developers for its ease of use.
There is no protection against bad queries. If a query is poorly written, it's execution can't be improved with any indexes, fast access path or other database advancements. What is the most common source of poorly written queries? Most of the time they do not come from humans; they are generated by applications that use ORMs to communicate with databases. What can we do to prevent it from happ...
Today, Chicago PUG is the third-largest in the Western Hemisphere, but it was not the case three years ago. It is easy to announce a new User Group, but how to keep it running and growing? Nobody expected new pandemic and the effect it will take on our lives. The Open Source communities, including Postgres community, which live and breath live discussions, were hit heavily. How did we manage? ...
The Ultimate Postgres Optimization: Going Beyond Docs and Textbooks
Think like a database
Abstract: Is it possible to teach somebody to optimize? Or is optimization a sort of magic, available only for the limited circle of wizards? We believe that it is entirely possible to become an optimization wizard, and we are going to prove it in the course of this training. We will provide the participants with the opportunity to look at the process of query writing “as a database engine”, a...
Connecting Galaxies
Information Exchange Techniques for Java/PostgreSQL Applications
Everything shall pass except Object-Relational Impedance Mismatch. Despite many years of research and development in this area, applications and databases still struggle with communication issues. An incompatibility of data models between object-oriented application code and a database engine causes multiple performance problems and triggers over-complicated application design.
In this talk,...
Using FDW Like Never Before
Remote Functions Calls Are Possible
At Braviant Holdings we consider foreign data wrappers to be the best thing even introduced in PostgreSQL. We use them virtually everywhere, both for our apps which interact with OLTP databases and for the ETL for our Data Warehouse.
One of the best things about using the FDW is that they allow you to map objects of various types. You can map tables, views, other foreign tables, you can use...