Sammlung von Newsfeeds

Ryan Booz: The 2024 State of the Database Landscape Survey

Neues vom PostgreSQL Planet - 2. September 2024 - 16:43
Redgate's State of the Database Landscape Survey is back again in 2024 and ready for your feedback! The 2023 survey gathered insights from nearly 4,000 data professionals about evolving database complexities and skill demands. The 2024 survey will focus on learning, AI, cloud, and security. Participate for insights and a chance to win Amazon vouchers.

Andreas 'ads' Scherbaum: Amul Sul

Neues vom PostgreSQL Planet - 2. September 2024 - 16:00
PostgreSQL Person of the Week Interview with Amul Sul: I am Amul Sul, and I grew up and completed my university studies in Mumbai. I did my master’s in computer application from VJTI, Mumbai. In 2012, NTT DATA brought me on board through campus placement. For three years, I dived deep into PostgreSQL, working on NTT DATA’s internal PostgreSQL project.

Shayon Mukherjee: pg_easy_replicate Supports Schema Change Tracking During Logical Replication

Neues vom PostgreSQL Planet - 31. August 2024 - 18:19
I have been meaning to support common DDLs (Data Definition Language) for pg_easy_replicate for quite some time now and I am super stoked that it is now finally out. This new capability addresses one of the limitations of PostgreSQL’s native logical replication, bringing more flexibility to database migrations and replication through pg_easy_replicate. What is pg_easy_replicate? For those new to the project, pg_easy_replicate is a CLI orchestrator tool that simplifies the process of setting up and managing logical replication between PostgreSQL databases.

Shayon Mukherjee: pg_easy_replicate Now Supports Tracking Schema Changes in PostgreSQL

Neues vom PostgreSQL Planet - 31. August 2024 - 18:19
I have been meaning to support common DDLs (Data Definition Language) for pg_easy_replicate for quite some time now and I am super stoked that it is now finally out. This new capability addresses one of the limitations of PostgreSQL’s native logical replication, bringing more flexibility to database migrations and replication through pg_easy_replicate. What is pg_easy_replicate? For those new to the project, pg_easy_replicate is a CLI orchestrator tool that simplifies the process of setting up and managing logical replication between PostgreSQL databases.

Tomas Vondra: Office hours experiment

Neues vom PostgreSQL Planet - 31. August 2024 - 12:00
I’ve decided to experiment a little bit and do regular “office hours.” I’ll be available to chat about almost anything related to Postgres. It might be a technical discussion about a patch you’re working on, or a topic about the community etc. This is not an entirely new thing. I’ve been telling people to just ping me if they want to discuss something off-list, or have a call and chat about it.

Deepak Mahto: Exploring PostgreSQL 17: A Developer’s Guide to New Features – Part 6: Login Event Trigger

Neues vom PostgreSQL Planet - 31. August 2024 - 3:27

Welcome to Part 6 of our series exploring the exciting new features anticipated in the official PostgreSQL 17 release. In this series, we delve into newly added features and discuss how they can benefit database developers and migration engineers transitioning to PostgreSQL 17 in future.

In case you missed the earlier parts:

Jimmy Angelakos: Contributions of w/c 2024-08-19 (week 34)

Neues vom PostgreSQL Planet - 30. August 2024 - 13:34

The annual PgUS membership meeting was prepared and conducted by: * Stacey Haysler (President) * Mark Wong (Treasurer & Expo Committee) * Michael Brewer (Secretary) * Jonathan S.

Greg Sabino Mullane: Understanding the Postgres Hackers Mailing List Language

Neues vom PostgreSQL Planet - 29. August 2024 - 21:30

The Postgres hackers mailing list (pgsql-hackers@postgresql.org) is an invaluable resource for anyone wanting to contribute to the PostgreSQL code. The Postgres project does not use PRs (pull requests) or GitHub issues. So if you want to contribute an idea, or help with code reviews, the hackers mailing list is the canonical way to do so.

semab tariq: A Beginner’s Guide to Sharding PostgreSQL with Citus

Neues vom PostgreSQL Planet - 29. August 2024 - 7:29

PostgreSQL is a powerful and open-source relational database system known for its reliability, flexibility, and advanced features. It handles complex queries, ensures data integrity, and can be extended to meet various needs, making it a popular choice for many applications. However, as your data grows and the number of transactions increases, scaling PostgreSQL can be challenging.

LDAP

PostgresqlHelp - 29. August 2024 - 7:22

Introduction to LDAP

Purpose

The Lightweight Directory Access Protocol (LDAP) is a directory service protocol that runs on a layer above the TCP/IP stack. It provides a mechanism used to connect to, search, and modify Internet directories.

How directory service works?

The LDAP directory service is based on a client-server model.

LDAP stores data in tree structure. When LDAP client connects to an LDAP server and requests information or performs an operation, the server performs the operation or provides the information.

Directory Entries

Andreas Scherbaum: PostgreSQL Hacking Workshop - August 2024

Neues vom PostgreSQL Planet - 29. August 2024 - 0:00

On August 8th and August 15th, the first two “PostgreSQL Hacking Workshops” took place. Robert Haas previously asked on Discord for topics, and the highest vote was for “PostgreSQL Optimizer Methodology”. The invited attendees are expected to watch the video before, and bring questions to the workshop.

Keith Fiske: Announcing an Open Source Monitoring Extension for Postgres with pgMonitor

Neues vom PostgreSQL Planet - 27. August 2024 - 16:00

Crunchy Data is pleased to announce a new open source pgMonitor Extension. Crunchy Data has worked on a pgMonitor tool for several years as part of our Kubernetes and self-managed Postgres deployments and recently we’ve added an extension to the tool set.

Two primary scenarios motivated the creation of the pgMonitor extension :

Umair Shahid: PostgreSQL is a viable alternative to Oracle – here is why…

Neues vom PostgreSQL Planet - 27. August 2024 - 13:23

Why pay $100,000 for something you can achieve in $5,000? That’s the main question. Oracle is a long-standing giant in the DBMS world, offering a feature-rich platform but at a steep price, often catering to large enterprises with extensive budgets. PostgreSQL, on the other hand, is open source with a liberal license and zero licensing fees.

Tomas Vondra: [PATCH IDEA] Using COPY for postgres_fdw INSERT batching

Neues vom PostgreSQL Planet - 27. August 2024 - 12:00

In an earlier post I mentioned I plan to share a couple patch ideas, suitable for new contributors. This is the first one, about using COPY protocol for postgres_fdw batching. This would replace the current implementation, based on prepared statements. Let me share a couple thoughts on the motivation and how it might be implemented.

Tudor Golubenco: Postgres webhooks with pgstream

Neues vom PostgreSQL Planet - 27. August 2024 - 2:00
A simple tutorial for calling webhooks on Postgres data and schema changes using pgstream.

Deepak Mahto: Exploring PostgreSQL 17: A Developer’s Guide to New Features – Part 5 : Correlated IN Clause Transformation

Neues vom PostgreSQL Planet - 26. August 2024 - 23:36

Welcome to Part 5 of our series exploring the exciting new features anticipated in the official PostgreSQL 17 release. In this series, we delve into newly features and discuss how they can benefit database developers and migration engineers transitioning to the latest version of PostgreSQL.

Grant Fritchey: AWS RDS PostgreSQL Restore to a Point in Time

Neues vom PostgreSQL Planet - 26. August 2024 - 18:05

One of the single biggest reasons to go with a Platform as a Service (PaaS) offering like AWS RDS are the things it does for you, like making it really easy to restore to a point in time. Let’s take a look at it. Restore to a Point in Time When connect up to the […]

The post AWS RDS PostgreSQL Restore to a Point in Time appeared first on Grant Fritchey.

Gabriele Bartolini: CNPG Recipe 12 - Exposing Postgres outside Kubernetes with Service Templates

Neues vom PostgreSQL Planet - 26. August 2024 - 9:38

In this article, I’ll introduce you to the new service template feature in CloudNativePG 1.24, which greatly simplifies the creation of services such as LoadBalancer to expose PostgreSQL outside of your Kubernetes cluster - particularly useful for streamlining Database-as-a-Service (DBaaS) deployments. I’ll walk you through setting up this feature on your laptop using kind and cloud-provider-kind, ensuring you can easily test and implement these capabilities in your own environment.

Radim Marek: Beyond Simple Upserts with MERGE in PostgreSQL

Neues vom PostgreSQL Planet - 25. August 2024 - 2:00

Understanding how comfortable someone is with databases and SQL often comes down to the features they use. In PostgreSQL, one such feature that distinguishes more advanced users is the MERGE command, introduced in version 15 and expanded in version 17 (in beta at the time of writing this article). Before MERGE, developers typically relied on INSERT ... ON CONFLICT DO UPDATE for upserts—a method introduced in PostgreSQL 9.5 that has since become a staple in many developers' toolkits.

Radim Marek: Beyond Simple Upserts with MERGE in PostgreSQL

Neues vom PostgreSQL Planet - 25. August 2024 - 2:00

Understanding how comfortable someone is with databases and SQL often comes down to the features they use. In PostgreSQL, one such feature that distinguishes more advanced users is the MERGE command, introduced in version 15. Before MERGE, developers typically relied on INSERT ... ON CONFLICT DO UPDATE for upserts—a method introduced in PostgreSQL 9.5 that has since become a staple in many developers' toolkits.

Seiten