Boriss Mejias

You heard that PostgreSQL also supports the JSON data type, and you wanted to enjoy the dynamics of schema freedom mixed with the benefits of a relational database. You wanted a flexible data type combined with columns with strong types, with relationships between tables, and with constraints to guarantee data integrity.

Good technical ideas, solutions, and projects get lost when they are not well communicated. Think about losing track of a presentation because you don't know where it is going, or a software feature request where the developers reject it because they don't know why it is needed or which problem it solves.

What if downtime means unanswered emergency calls and lives at risk? This is the reality for a geo-redundant emergency system operating across island datacenters with spotty connectivity.

Data structures and their relationships are key to software design. For most, how data is organized is even more important than the application code itself, because the code, the flowcharts and the processes will be derived and become straightforward from the data structure and their relationships.

Lack of awareness around Mental Health issues has always been a problem in IT circles, leading to stress, burnout and difficulties in workplace and community relationships. This often results in employee turnover and strained dynamics within open source projects, and creates barriers for achieving a diverse contributor base.

When you create, update or delete a row in PostgreSQL, you are actually creating a new version of the row, hence, each row in PostgreSQL may have multiple versions during its life, sometimes many versions concurrently. These multiple versions are the key to different transaction isolation levels, consistent snapshots, and everything around concurrency control.

Logical replication in PostgreSQL is great for multiple use cases such major upgrades with nearly-zero downtime, consolidation of multiple databases into a warehouse, and more recently, bi-directional replication for geo-redundancy, with the promise of an active-active architecture. All these possibilities are evidence that logical replication is far richer than physical replication.

A series of short talks, each a maximum of 5 minutes long: Don Goodman: A cognitive theory of community Floor Drees and Boriss Mejías: Using Postgres to find your next karaoke song Ants Aasma: Chasing tails Chris Ellis & Nick Bluth: Announcing: PostgreSQL Independent Network Chris Ellis: UUIDs Are...

With the improvements in logical replication released in PostgreSQL 16, there is an increasing interest in active-active clusters in PostgreSQL. We have observed new blog posts and conference talks on the subject discussing possible architectural configurations.

In our experience, when developers create partitioned tables, they will create a few partitions to cover the first year, create a few more after the year and finally forget about them.

PostgreSQL provides great support for JSON objects and every developer working with this data type should learn how to take advantage of it. Instead of going through the documentation on how to use JSON in PostgreSQL, in this talk we will use a case study to learn by example.

When a table gets too large, performance and maintenance is heavily affected. That's why you want to split the table into multiple partitions before the problem hits you.

PostgreSQL provides great support for JSON objects and every developer working with this data type should learn how to take advantage of it. Instead of going through the documentation on how to use JSON in PostgreSQL, in this talk we will use a case study to learn by example.

Have you ever had the need to write SQL queries to analyze data that would need to simultaneously query data from a flat file, MySQL,MongoDB, Oracle, Hadoop, a Python script and one or more different PostgreSQL nodes? It isn’t hard to imagine as modern day businesses tend to use specialized products and data stores for their special needs.

Identifying database security breach points is the first step towards improving your infrastructure so that you don't become a victim of malicious attack due to preventable vulnerabilities. This training course will show how to improve security on a PostgreSQL server in the following areas: