Sammlung von Newsfeeds

Luca Ferrari: Changing a Column from Integer to Boolean in One Transaction

Neues vom PostgreSQL Planet - 5. Februar 2024 - 1:00

A way to fix some oddity that comes from other databases.

Changing a Column from Integer to Boolean in One Transaction

I was migrating a database from SQLite3 to PostgreSQL, not because the former isn’t good, rather because the latter shines!

Henrietta Dombrovskaya: Tuning Parameters vs Tuning Queries: presentation and recording

Neues vom PostgreSQL Planet - 4. Februar 2024 - 18:15

The presentation I gave for Chicago PUG in January was a reserved talk for FOSDEM, so I hold of with sharing until after the conference. Now that the conference is over, here is it!

Jeremy Schneider: UUID Benchmark War

Neues vom PostgreSQL Planet - 4. Februar 2024 - 0:54

This month’s PGSQL Phriday #015 topic is about UUIDs, hosted by Lætitia Avrot. Lætitia has called for a debate. No, no, no. I say let’s have an all-out war. A benchmark war.

I have decided to orchestrate a benchmark war between four different methods of storing a primary key:

Dan Langille: could not open certificate file “/root/.postgresql/postgresql.crt”: Permission denied

Neues vom PostgreSQL Planet - 3. Februar 2024 - 23:33
I went to work on a brilliant new idea for a FreshPorts feature and I immediately hit a snag on my dev system. I noticed that the package importing system had not run anything recently. The reason why was in the logs: In this post: FreeBSD 14.0 PostgresQL 16.1 py39-psycopg2-2.9.9 Python 3.9.18 First, why did […]

Lætitia AVROT: PGSQL Phriday #015: Primary keys: UUID, CUID, or TSID?

Neues vom PostgreSQL Planet - 3. Februar 2024 - 13:02
This month’s PGSQLPhriday event is about UUId thanks to my post calling for a fight debate on the topic. I will answer a question a friend developer asked me: “What is the best when we need a primary key? UUID, CUID, or TSID?” TL;DR: please don’t The answer is: “It depends!” Yes, it’s a running joke amongst consultants: you can always answer all customers' questions with an “it depends”. The reason for that is simple: if the answer was obvious, you wouldn’t need the consultant!

Pavlo Golub: Postgres.AI bot interview for PGSQL Phriday #015

Neues vom PostgreSQL Planet - 2. Februar 2024 - 19:00

This month, we have an invitation from Lætitia to talk about UUIDs. UUIDs are a hot topic, and Cybertec wrote several posts earlier.

Francesco Tisiot: How to load JSON data in PostgreSQL with the the COPY command

Neues vom PostgreSQL Planet - 2. Februar 2024 - 14:00

You have a JSON dataset that you want to upload to a PostgreSQL table containing properly formatted rows and columns... How do you do it?

All the main sources like my own blog and others tell you to load the JSON in a dedicated temporary table containing a unique JSON column, then parse it and load into the target table. However there could be another way, avoiding the temp table!

Jagadeesh Panuganti: Data Navigation with PostgreSQL Cursors – Part II

Neues vom PostgreSQL Planet - 1. Februar 2024 - 17:21

Welcome back to the second article in our series exploring PostgreSQL cursors. In the first part of this series, we explored the fundamentals of scrollable cursors. In this article, we’ll shift our focus to non-scrollable cursors and explore how they can enhance your data navigation experience with PostgreSQL Cursors. Understanding Non-Scrollable Cursors Non-scrollable cursors in […]

David Wheeler: Contemplating Decentralized Extension Publishing

Neues vom PostgreSQL Planet - 1. Februar 2024 - 16:50
TL;DR

As I think through the future of the Postgres extension ecosystem as a key part of the new job, I wanted to understand how Go decentralized publishing works. In this post I work it out, and think through how we might do something similar for Postgres extension publishing.

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.

Seiten