Sammlung von Newsfeeds

David Wheeler: PGXN Tools v1.4

Neues vom PostgreSQL Planet - 31. Januar 2024 - 18:13

Over on the PGXN Blog I’ve posted a brief update on recent bug fixes and improvements to the pgxn-tools Docker image, which is used fairly widely these days to test, bundle, and release Postgres extensions to PGXN. This fix is especially important for Git repositories:

David E. Wheeler: PGXN Tools Docker Image Updated

Neues vom PostgreSQL Planet - 31. Januar 2024 - 17:52

Just a quick note to highlight some bug fixes and improvements in the pgxn/pgxn-tools Docker image in the last few weeks.

Francesco Tisiot: Load StackOverflow's StackExchange data in Postgresql®

Neues vom PostgreSQL Planet - 31. Januar 2024 - 11:00

I recently found about the StackOverflow dataset in Kaggle, which points to the StackExchange link to download the entire data. In this blog I'll show a (maybe not 100% polished) way to upload the data to several tables in a PostgreSQL database!

Ryan Lambert: UUID in Postgres: PgSQLPhriday #015

Neues vom PostgreSQL Planet - 31. Januar 2024 - 6:01

This month's PgSQLPhriday #015 topic is about UUIDs. Lætitia Avrot is this month's host, see her post for the full challenge text. The topic is described as a debate between the Database People and Developers. I'm not sure there's such a clean divide on people's opinions on the topic, as I know plenty of Database People that have settled on using UUIDs as their default. Similarly, I know even more developer types that have followed the arguably more conventional choice of using an auto-incrementing ID.

Elizabeth Garrett Christensen: JSON and SVG from PostGIS into Google Sheets

Neues vom PostgreSQL Planet - 30. Januar 2024 - 14:00

At PostGIS Day 2023, one of our speakers showed off a really cool demo for getting JSON and SVGs in and out of Postgres / PostGIS and into Google Sheets. Brian Timoney put together several open source projects in such a cool way that I just had to try it myself. If you want to see his demo video, it is on YouTube.

David Wheeler: PGXN Challenges

Neues vom PostgreSQL Planet - 30. Januar 2024 - 1:11

Last week, I informally shared Extension Ecosystem: Jobs and Tools with colleagues in the #extensions channel on the Postgres Slack.

Robert Haas: Who Contributed to PostgreSQL Development in 2023?

Neues vom PostgreSQL Planet - 29. Januar 2024 - 17:40

As in previous years, I've pulled together a few statistics on code contributions to PostgreSQL. See previous posts in this series for methodology and caveats. I calculate that, in 2023, there were 221 people who were the principal author of at least one PostgreSQL commit. 66% of the new lines of code were contributed by one of 18 people, and 90% of the new lines of code were contributed by one of 50 people. Here they are. Asterisks indicate non-committers.

Luca Ferrari: 'generated always as identity' columns do not have default values (or do they?)

Neues vom PostgreSQL Planet - 29. Januar 2024 - 1:00

Something strange I discovered while using DBIx::Class and DBI.

‘generated always as identity’ columns do not have default values (or do they?)

PostgreSQL has two ways of defining what other databases call an auto-increment column:

Ryan Booz: PGSQL Phriday #015

Neues vom PostgreSQL Planet - 27. Januar 2024 - 21:28

Invitation from Lætitia Avrot

Lætitia is hosting for the second time, and the topic is sure to get a great discussion going – just like the first time she hosted and the conversation really Triggered some healthy debate.

Nikolay Samokhvalov: Postgres.AI Bot. Towards LLM OS for Postgres

Neues vom PostgreSQL Planet - 27. Januar 2024 - 20:30

I'm happy to present our new product, Postgres.AI Bot. It is powered by OpenAI's GPT-4 Turbo and is designed to help engineers improve their experience when working with PostgreSQL. This bot has a vast knowledge base with over 110,000 entries, including documentation, source code for different PostgreSQL versions, and related software like PgBouncer, Patroni, and pgvector. It also integrates expert articles and blogs.

Lætitia AVROT: PGSQL Phriday #015: UUID: let's fight!

Neues vom PostgreSQL Planet - 27. Januar 2024 - 11:32
Today, I’m very proud and honored to host for the second time the great monthly PGSQL Phriday event! It’s sometimes difficult to find a great topic and I like the kind of topics where there is no consensus. This one is a little particular: in my humble opinion, the database community has a consensus, it’s that developers don’t agree.` Let’s organize a debate between database people and developers! I hope this will lead to great conversation and better understanding between those two groups!

Luca Ferrari: Learn PostgreSQL - second edition - Tech Bits

Neues vom PostgreSQL Planet - 27. Januar 2024 - 1:00

Me and Enrico talk about out latest book on Doug’s Tech Bit show!

Learn PostgreSQL - second edition - Tech Bits

I’m really glad that me and Enrico were hosted on the great Doug’s Tech Bits show. You can see the podcast on YouTube:

I would like to thank Doug Ortiz for his excellent work.

cary huang: A Comprehensive Overview of PostgreSQL Query Processing Stages

Neues vom PostgreSQL Planet - 26. Januar 2024 - 23:28
Introduction

When you send a query to PostgreSQL, it will undergo several processing stages in the backend. Each of these stages has different responsibilities to ensure that you receive correct responses in shortest amount of time possible. Yes, they can be quite large and complex to fully understand but I believe it is important for PostgreSQL developer like you to at least understand their roles in handling a query. In this blog, I will give an overview of each query processing stage, their roles and significance in PostgreSQL architecture.

Pavlo Golub: GSoC 2024 calls for aid! And Postgres will answer!

Neues vom PostgreSQL Planet - 26. Januar 2024 - 14:00

Google Summer of Code is back for 2024! Please review this announcement blog post.

And please make yourself familiar with the GSoC 2024 timeline!

Adrien Nayrat: GROUP BY reordering

Neues vom PostgreSQL Planet - 26. Januar 2024 - 12:00

A commit caught my attention during my technical watch:

Adam Hendel: How we built our customer data warehouse all on Postgres

Neues vom PostgreSQL Planet - 25. Januar 2024 - 13:00

At Tembo (like every aaS provider), we wanted to have a customer data warehouse to track and understand customer usage and behavior. We wanted to quickly answer questions like "How many Postgres instances have we deployed?", "Who is our most active customer?" and "How many signups do we have by time?". In order to do this, we needed to bring data from several sources into a single location and keep it up-to-date so we could build the dashboards.

Umair Shahid: “But how much does a PostgreSQL license actually cost?” A Frequently Asked Question from Oracle users considering PostgreSQL

Neues vom PostgreSQL Planet - 25. Januar 2024 - 12:57

Unraveling the Mystery: Why PostgreSQL Costs You Nothing  Each time I mention that PostgreSQL comes with zero licensing fees, I’m met with skeptical looks and a barrage of “Really? But how much does the license actually cost?”. It has happened enough times that I decided to write a blog explaining this, keeping in mind especially […]

Andrew Atkinson: What’s ‘Rows Removed By Filter’ in PostgreSQL Query Plans all about?

Neues vom PostgreSQL Planet - 25. Januar 2024 - 1:00

I was recently conducting a training session on the query planner, looking at the bits of information, and we discussed the “Rows Removed by Filter.”

I was seeing a value of one less than the total row count, which made sense, since the query had a LIMIT of 1.

However, as I changed the query parameter, the value from “Rows Removed by Filter” returned different values. I realized I didn’t fully understand the behavior, so I wanted to take that opportunity to strengthen my understanding of what was happening.

Rigoudy Perik: Extensions for PostgreSQL, how we participate at Adjust?

Neues vom PostgreSQL Planet - 24. Januar 2024 - 11:00
PostgreSQL is an open-source relational database management system. A large number of PostgreSQL functions are available as standard, and documentation for these can be found in the official documentation. However, it is possible to create your own extensions for specific needs. You can check PGXN, the PostgreSQL Extension network. This is a central distribution system for open-source PostgreSQL extensions. In this blog post I’m going to talk about the different PostgreSQL extensions developed by Adjust.

Andreas Scherbaum: PostgreSQL @ FOSDEM 2024

Neues vom PostgreSQL Planet - 24. Januar 2024 - 10:42

The PostgreSQL Project is present with a booth at FOSDEM ever since 2007. And ever since 2008 we organize a Devroom, starting 2013 we also have our own PGDay on the Friday before FOSDEM. This year it’s the 10th FOSDEM PGDay, skipping 2021 and 2022 for obvious reasons.

This blog post provides useful information for visitors of the PGDay, the booth and the PostgreSQL Devroom at FOSDEM.

Seiten