Neues vom PostgreSQL Planet
Claire Giordano: Calling Postgres speakers, POSETTE CFP is open until Apr 7th 2024
The tl;dr of this post is that the CFP is open until April 7th 2024 for POSETTE: An Event for Postgres, the free & virtual developer event brought to you with 🧡 by our Postgres team at Microsoft. Formerly called Citus Con.
Shaun M. Thomas: PG Phriday: Why Postgres is the Best Database Engine
Gabriele Bartolini: CloudNativePG Recipe 4 - Connecting to Your PostgreSQL Cluster with pgAdmin4
The article explores the deployment of pgAdmin4, a popular graphical user interface for PostgreSQL, within a CloudNativePG environment, primarily for evaluation and educational purposes. The process involves deploying pgAdmin4 to connect to a PostgreSQL cluster, navigating its interface, and utilizing SQL functionality. The article provides detailed deployment instructions and highlights the use of the --mode desktop option for seamless integration.
semab tariq: PostgreSQL Internals Part 2: Understanding Page Structure
Explore intricacies of PostgreSQL's internal page structure and how pages are organized, their default size, and more.
The post PostgreSQL Internals Part 2: Understanding Page Structure appeared first on Stormatics.
David Wheeler: RFC: PGXN Metadata Sketch
This post proposes a new metadata standard for extension packaging, distribution, and delivery, building on the PGXN Meta Spec to address its shortcomings and emerging use cases 12 years on. The goals include:
muhammad ali: Transitioning from Heroku PostgreSQL to AWS EC2: Step-by-Step Guide
The blog describes all the steps required to safely migrate your Heroku PostgreSQL database to self managed PostgreSQL on AWS EC2 instance using logshipping method.
The post Transitioning from Heroku PostgreSQL to AWS EC2: Step-by-Step Guide appeared first on Stormatics.
Luca Ferrari: pgagroal-cli minor bug fixes
A few changes to a part of pgagroal.
pgagroal-cli minor bug fixesIn the past days I pushed a few troophy patches to pgagroal-cli, the command line tool to administer a pgagroal connection pooler, in order to fix minor issues that produced unattended results.
The bug were all harmless, since they only affected what the pgagroal-cli was producing as output to the user, but could have been confusing for some use cases, hence the need to fix them.
Pavel Stehule: compiled win x64 dll of orafce-4.9.3 and plpgsql_check-2.7.4 for PostgreSQL 15 and 16
I compiled and uploaded zip files with latest orafce and plpgsql_check for PostgreSQL 15 and PostgreSQL 16.
Setup:
Aditya Surishetti: Connecting to PostgreSQL with Go using PGX
PostgreSQL has emerged as a reliable, feature-rich database used extensively across various industries. On the other hand, Go (Golang), known for its simplicity, efficiency, and strong standard libraries, has become increasingly preferred for modern backend development. In this article we will discuss PGX – a powerful, lightweight, and easy-to-use driver for accessing PostgreSQL databases in […]
Jonathan Katz: Will PostgreSQL ever change its license?
(Disclosure: I’m on the PostgreSQL Core Team, but what’s written in this post are my personal views and not official project statements…unless I link to something that’s an official project statement ;)
David Wheeler: Extension Registry Namespacing RFC
A few weeks ago I brainstormed about decentralized Postgres extension publishing, inspired in part by an examination of Go decentralized publishing.
Hubert 'depesz' Lubaczewski: Waiting for PostgreSQL 17 – Add RETURNING support to MERGE.
Paul Ramsey: Inside PostGIS: Calculating Distance
Calculating distance is a core feature of a spatial database, and the central function in many analytical queries.
David Wheeler: Building Trunk
This week, my fellow Tembonaut Ian Stanton will present the extension ecosystem mini-summit talk, “Building Trunk: A Postgres Extension Registry and CLI”.
Andreas 'ads' Scherbaum: Florent Jardin
Pierre Ducroquet: Look ma, I wrote a new JIT compiler for PostgreSQL
Sometimes, I don’t know why I do things. It’s one of these times. A few months ago, Python 3.13 got its JIT engine, built with a new JIT compiler construction methodology (copy-patch, cf. research paper). After reading the paper, I was sold and I just had to try it with PostgreSQL. And what a fun ride it’s been so far. This blog post will not cover everything, and I prefer other communication methods, but I would like to introduce pg-copyjit, the latest and shiniest way to destroy and segfault speed up your PostgreSQL server.
Hubert 'depesz' Lubaczewski: What the hell is transaction wraparound?
Adrien Nayrat: Back from pgDay Paris 2024.
I’m back from pgDay Paris. I really enjoyed this edition. I’d already come to the 2019 one, and I must say I wasn’t deceived. As a reminder, pgDay Paris is an international conference. Presentations are in English, attracting more English speakers and audiences.