Neues vom PostgreSQL Planet

Neues vom PostgreSQL Planet Feed abonnieren
Planet PostgreSQL
Aktualisiert: vor 2 Stunden 58 Minuten

Bob Pacheco: CI/CD with Crunchy Postgres for Kubernetes and Argo

7. Juni 2023 - 15:00

Continuous Integration / Continuous Delivery (CI/CD) is an automated approach in which incremental code changes are made, built, tested and delivered. Organizations want to get their software solutions to market as quickly as possible without sacrificing quality or stability. While CI/CD is often associated with application code, it can also be beneficial for managing changes to PostgreSQL database clusters.

Dian Fay: PGSQL Phriday #009 Roundup

7. Juni 2023 - 2:00

Another Phriday in the books, and it's time to see what all happened:

Kaarel Moppel: TIL - Filling prepared statement placeholders automatically with pgbadger

6. Juni 2023 - 23:00
Hey Postgres friends! Thought I’ll try out a new shorter broadcasting format as seems finding some hours for proper blog posts is getting increasingly harder and harder. So here a first “Today I learned” type of post on a very useful feature of pgbadger that I just discovered for myself...

Tristen Raab: Using NGINX as a PostgreSQL Reverse Proxy and Load Balancer

6. Juni 2023 - 22:44

This blog will go over the use cases of setting up NGINX (Engine X) as both a reverse proxy and load balancer for PostgreSQL. NGINX is an excellent feature-rich and open-source project that can help make an application more cohesive. It does this by exposing a single port to the user and proxy requests to different applications in a project based on the URI. This can make it appear as though our entire application is hosted on a single node while in reality it can be distributed anywhere around the globe.

Hans-Juergen Schoenig: What is a schema in PostgreSQL?

6. Juni 2023 - 10:00

One way to organize data in PostgreSQL is to make use of schemas. What is a schema in PostgreSQL? And more importantly: What is the purpose of a schema and how can schemas be used to make your life easier? Let’s dive in and find out.

The purpose of a schema

Before you figure out how to use schemas, you need to know what the purpose of a schema is in the first place. To understand that, first take a look at how PostgreSQL is structured: