Sammlung von Newsfeeds
Luca Ferrari: pgenv gains a new command (and contributor!)
A new command in the pgenv script.
pgenv gains a new command (and contributor!)[pgenv](https://github.com/theory/pgenv){:target="_blank"} , the PostgreSQL binary manager written as a Bourne Again Shell script, has gained a new command: status.
Adrien Nayrat: Postgres again elected DBMS of the Year in 2023, but I'm worried
Once again, Postgres has been elected DBMS of the Year by DB-Engines. Although this is only a ranking, it gives a trend. It has also been recognized for several years in Stackoverflow surveys : Most popular Databases.
Ricardo Zavaleta: Pgvector vs Lantern part 2 - The one with parallel indexes
Three weeks ago, we wrote a blog comparing pg_vector and lantern on index creation and search speed, and also mentioned that this is a fast evolving space with great momentum.
Just last week, we saw the release of Pgvector v0.6.0, which contains improvements in HWSW build time thanks to the ability to build indexes in parallel.
Luca Ferrari: Changing a Column from Integer to Boolean in One Transaction
A way to fix some oddity that comes from other databases.
Changing a Column from Integer to Boolean in One TransactionI 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
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
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
Lætitia AVROT: PGSQL Phriday #015: Primary keys: UUID, CUID, or TSID?
Pavlo Golub: Postgres.AI bot interview for PGSQL Phriday #015
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
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
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
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
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
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®
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
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
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
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?
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.