Sammlung von Newsfeeds

Christoph Berg: The Debian Conference 2025 in Brest

Neues vom PostgreSQL Planet - 29. Juli 2025 - 8:00

It's Sunday and I'm now sitting in the train from Brest to Paris where I will be changing to Germany, on the way back from the annual Debian conference. A full week of presentations, discussions, talks and socializing is laying behind me and my head is still spinning from the intensity.

Pollito and the gang of DebConf mascots wearing their conference badges (photo: Christoph Berg)

Table of Contents

Dave Stokes: PostgreSQL, Ollama, and the DBeaver AI Assistant

Neues vom PostgreSQL Planet - 28. Juli 2025 - 17:01

Ollama is an open-source project that simplifies running large language models (LLMs). It runs locally on your machine, and you can choose from multiple LLMs. Keeping all the data on your machine should provide a security bonus.   

DBeaver is a universal database tool with an AI Assistant. This assistant provides an extra layer of security by allowing you to lock down what is shared, with the default being metadata only, no data.

Andreas 'ads' Scherbaum: Polina Bungina

Neues vom PostgreSQL Planet - 28. Juli 2025 - 16:00
PostgreSQL Person of the Week Interview with Polina Bungina: I am Polina, a PostgreSQL database engineer at Zalando, located in Berlin, Germany. However I am originally from St. Petersburg, Russia.

Sergey Solovev: pg_dphyp: teach PostgreSQL to JOIN tables in a different way

Neues vom PostgreSQL Planet - 28. Juli 2025 - 11:15

Greetings!

I work in Tantor Labs as a database developer and naturally I am fond of databases. Once during reading the red book I have decided to study planner deeply. Main part of relational database planner is join ordering and I came across DPhyp algorithm that is used in most modern (and not so much) databases. I wonder - is there is anything in PostgreSQL? Surprisingly, nothing. Well, if something does not exist, you need to create it yourself.

Nikolay Samokhvalov: Self-driving Postgres

Neues vom PostgreSQL Planet - 25. Juli 2025 - 18:57

I'm excited to announce that Postgres AI has started work on a new project – open-source Self-Driving Postgres (SDP).

In the AI era, Postgres is the natural choice for AI builders. With fast-growing database clusters, the highest level of automation is essential. AI-driven growth demands efficient, proactive, and intelligent database management. Our goal is to reduce manual interventions as much as possible to achieve the highest level of operational efficiency and reliability.

How can we define levels of automation?

Nikolay Samokhvalov: Introducing Postgres how-tos: practical guides for real-world database challenges

Neues vom PostgreSQL Planet - 24. Juli 2025 - 22:48

Today, as part of our Launch Week (Day 4), we're excited to announce the release of our Postgres how-to guides collection – a comprehensive set of dozens of practical guides covering real-world PostgreSQL challenges.

Dave Stokes: Writing Queries In English to Create An Address Book On A PostgreSQL Instance

Neues vom PostgreSQL Planet - 24. Juli 2025 - 15:00

 Structured Query Language, or SQL, is my favorite programming language, but its quirky syntax can sometimes be frustrating. Many have professed a need to bypass SQL and query databases in English (another quirky language. Is it possible to have an Artificial Intelligence take a request in English and translate it into SQL on my behalf?

I am using the AI Chat Feature of DBeaver Enterprise to test. 

Nikolay Samokhvalov: Postgres AI Checkup service: expert-led, AI-assisted comprehensive database health assessment

Neues vom PostgreSQL Planet - 23. Juli 2025 - 22:00

Postgres AI Checkup service: expert-led, AI-assisted comprehensive database health assessment

This is Day 3 of Postgres AI launch week

It starts innocently enough.

You choose Postgres – solid, reliable, battle-tested. You pick a managed service like RDS or CloudSQL. They handle backups, high availability, disaster recovery. You can focus on building your product. Life is good.

Dave Stokes: Write PostgreSQL Queries in English?

Neues vom PostgreSQL Planet - 23. Juli 2025 - 15:53

 If you've ever wanted to skip SQL and its quirks and write queries in English, I am happy to report that you can do it with an AI of your choice and DBeaver. I have a webinar on July 24th that shows you how to do just that.  

Henrietta Dombrovskaya: July PUG recording!

Neues vom PostgreSQL Planet - 23. Juli 2025 - 4:12

If you missed Prairie PUG meetup, here is the recording!

There will be no meetup in August – we will see you on September 10. Please keep an eye on announcements!

Claire Giordano: Bits of wisdom from a year of Talking Postgres

Neues vom PostgreSQL Planet - 22. Juli 2025 - 18:21

A year ago we renamed the Talking Postgres podcast—and just published our 29th episode. Since it’s a monthly thing, that means 13 new conversations in the past year. So this feels like a good moment to pause, reflect, and share a few highlights.

Boriss Mejias: Contributions for the week of 2025-07-14 (Week 29)

Neues vom PostgreSQL Planet - 22. Juli 2025 - 14:40

Three events published their schedule. Here are the Program Committees behind that work. Registrations are open for these three events.

PgDay Austria

Laurenz Albe: Who are the PGDG?

Neues vom PostgreSQL Planet - 22. Juli 2025 - 8:00


© Laurenz Albe 2025

You may have encountered the abbreviation PGDG or the long version “PostgreSQL Global Development Group” in the PostgreSQL license text, the name of installation packages and elsewhere. But have you ever stopped to think who this mysterious organization is? Have you ever wondered how one becomes a member? Then read on.

Andreas 'ads' Scherbaum: Peter Zaitsev

Neues vom PostgreSQL Planet - 21. Juli 2025 - 16:00
PostgreSQL Person of the Week Interview with Peter Zaitsev: I was born and raised in Moscow, Russia, graduated from Moscow State University and had my first startup there. In 2004 I moved to the US while working at MySQL AB.

Ashutosh Bapat: Perks of speaking at PostgreSQL conferences

Neues vom PostgreSQL Planet - 21. Juli 2025 - 4:29

 A couple weeks back, I received my speaker's gift from POSETTE: An Event for Postgres

Bruce Momjian: Presentation Updates

Neues vom PostgreSQL Planet - 20. Juli 2025 - 8:15

I regularly update my slides to reflect improvements, corrections, and changes to Postgres. Recently I have made changes to two of my slide decks that I would like to highlight. First, my talk Postgres Scaling Opportunities is a rarely-presented deck about the ways Postgres can be scaled. One thing I always felt diminished the usefulness of that presentation was a clear explanation of why scaling databases is so complex.

Regina Obe: PostGIS 3.6.0beta1

Neues vom PostgreSQL Planet - 20. Juli 2025 - 2:00

The PostGIS Team is pleased to release PostGIS 3.6.0beta1! Best Served with PostgreSQL 18 Beta2 and soon to be released GEOS 3.14.

This version requires PostgreSQL 12 - 18beta2, GEOS 3.8 or higher, and Proj 6.1+. To take advantage of all features, GEOS 3.14+ is needed. To take advantage of all SFCGAL features, SFCGAL 2.2.0+ is needed.

Ashutosh Bapat:

Neues vom PostgreSQL Planet - 19. Juli 2025 - 15:58

 A couple weeks back, I received my speaker's gift from POSETTE: An Event for Postgres

Gülçin Yıldırım Jelínek: pgroll is on a roll! We hit 5k stars on Github

Neues vom PostgreSQL Planet - 18. Juli 2025 - 16:15
Pgroll is an open-source, zero-downtime, reversible schema migration tool built exclusively for Postgres. We’ve reached 5k stars on GitHub!

Henrietta Dombrovskaya: July Prairie Postgres PUG

Neues vom PostgreSQL Planet - 18. Juli 2025 - 4:24

I am very thankful to everyone who attended yesterday’s meetup! I must be completely honest: I am always pleasantly surprised when people attend our summer meetups. There are so many better things you can do in Chicago in summer!

I am especially thankful to our speaker, Robert Ismo, who delivered a very interactive presentation about AI and Postgres and kept the audience engaged. In fact, the lively discussion lasted until I had to go to catch my train and asked people to relocate to continue their discussion, so I can’t even tell how long it lasted :).

Seiten