Neues vom PostgreSQL Planet
Shayon Mukherjee: Use pg_easy_replicate for setting up Logical Replication and Switchover in PostgreSQL
Andrew Atkinson: SaaS on Rails on PostgreSQL — POSETTE 2024
In this talk attendees will learn how Ruby on Rails and PostgreSQL can be used to create scalable SaaS applications, focusing on schema and query design, and leveraging database capabilities.
We’ll define SaaS concepts, B2B, B2C, and multi-tenancy. Although Rails doesn’t natively support SaaS or multi-tenancy, solutions like Bullet Train and Jumpstart Rails can be used for common SaaS needs.
Christophe Pettus: Checking Your Privileges, 2
I turned the last blog post into a talk; you can get the slides here.
Umair Shahid: Guide to Auditing and Monitoring Access in PostgreSQL
In the data-driven world of today, maintaining the security and integrity of your database is paramount. Auditing and monitoring access to your database are critical components of an effective security strategy. These processes help ensure that only authorized users are accessing sensitive information and that any unauthorized access attempts are detected and addressed promptly.
Robert Haas: Mentoring Program Updates
Here are a few updates on the mentoring program that I announced in a previous blog post.
Gabriele Bartolini: CloudNativePG Recipe 9 - Inspecting the network and the storage in a CloudNativePG cluster
In this blog post, I delve into the crucial aspects of networking and storage within a CloudNativePG cluster deployed on Kubernetes. I explore how Kubernetes services manage external and internal communications for PostgreSQL clusters, ensuring high availability and seamless failover. Additionally, I examine the role of PersistentVolumeClaims in handling PostgreSQL data storage, offering insights into effective resource management.
Hans-Juergen Schoenig: Using AI to generate data structures for PostgreSQL
Artificial Intelligence is the motto of the day. Everybody is talking about it, everybody seems to know what it means and the insane number of buzzwords floating around on the internet is just mind-boggling. It seems that in some areas of the industry, the number of slides and marketing videos exceeds the number of real-world use cases and sometimes even the amount of code that actually exists.
Claire Giordano: Say hello to the Talking Postgres podcast
The TL;DR of this blog post is simple: the “Path To Citus Con” podcast for developers who love Postgres has been renamed—and the new name is Talking Postgres.
And if you’re just hearing about the Talking Postgres podcast for the first time, it is a monthly podcast for developers who love Postgres, with amazing guests from the Postgres world who talk about the human side of Postgres, databases, and open source.
Sergey Pronin: Automated Major Version Upgrades in Percona Operator for PostgreSQL
Umair Shahid: Access Controls in PostgreSQL
Secure your PostgreSQL database with effective access control. Learn role management, privileges, and Row-Level Security (RLS) techniques.
The post Access Controls in PostgreSQL appeared first on Stormatics.
Andreas 'ads' Scherbaum: Grant Zhou
Tomas Vondra: Basics of Tuning Checkpoints
Elizabeth Garrett Christensen: Parallel Queries in Postgres
Many folks are surprised to hear that Postgres has parallel queries out of the box. This was released in small batches across a half dozen versions of Postgres, so the major fanfare for having parallelism got a little bit lost.
Andrei Lepikhov: Why PostgreSQL prefers MergeJoin to HashJoin?
Today's post is sparked by a puzzling observation: users, especially those who use an abstraction layer like REST or ORM library to interact with databases, frequently disable the MergeJoin option across the entire database instance. They justify this action by citing numerous instances of performance degradation.
Radim Marek: Gentle Introduction to Window Functions in PostgreSQL
Understanding the relationship between data points is crucial. For instance, you might need to identify the most recent orders for each customer or track changes in sensor readings over time. Unlike aggregate functions, which summarise data into a single row, it is window functions that allow you to analyse data while preserving each row’s details. This is the core of the logic, but don’t worry if you struggle to imagine the difference, as we will cover all of it in this article.
Regina Obe: PostGIS 3.5.0alpha2
The PostGIS Team is pleased to release PostGIS 3.5.0alpha2! Best Served with PostgreSQL 17 Beta2 and GEOS 3.12.2.
Jimmy Angelakos: PGDay Lowlands and DBA Day 2024
Some great news: there's a new European PostgreSQL event in the Netherlands taking place in Amsterdam in September: PGDay Lowlands 2024!
Karen Jex: Database Troubleshooting for Developers at Brighton Ruby
This post contains the slides from the talk that I gave at Brighton Ruby last week, along with the transcript and other information.
I'll add the link to the video as soon as it's available.
Regina Obe: PostGIS 3.5.0alpha1
The PostGIS Team is pleased to release PostGIS 3.5.0alpha1! Best Served with PostgreSQL 17 Beta2 and GEOS 3.12.2.
This version requires PostgreSQL 12 - 17, GEOS 3.8 or higher, and Proj 6.1+. To take advantage of all features, GEOS 3.12+ is needed. To take advantage of all SFCGAL features, SFCGAL 1.5.0+ is needed.