Neues vom PostgreSQL Planet
Ryan Booz: PostgreSQL Patch of Interest (to me): Transaction Timeout
Pavlo Golub: ER diagrams with SQL and Mermaid
An Entity Relationship (ER) diagram is one of the most important tools for database design. It helps you visualize the relationships between different entities and how they interact with each other. Many GUI tools have their own tools to build ER diagrams, e.g. pgAdmin IV, DBeaver, etc.
Luca Ferrari: PgTraining online webinar on 2023-04-14 (Italian)
Yet another online event organized by PgTraining!
PgTraining online webinar on 2023-04-14 (Italian)
PgTraining, the amazin italian group of people that spread the word about PostgreSQL and that I joined in the last years, is organizing another online event (webinar) on next 14th April 2023.
Following the success of the previous edition(s), we decided to provide another afternoon full of PostgreSQL talks, in the hope to improve the adoption of this great database.
Andreas 'ads' Scherbaum: Frits Hoogland
Magnus Hagander: PGDay/MED 2023 - Schedule published and registration open
We are pleased to announce that we have finalized the schedule for PGDay/MED 2023! We were fortunate enough to get a large number of submissions, and the program committee is proud of the line-up that we’re featuring for this first-ever Mediterranean PGDay.
Registration is open for the conference and we hope that you’ll be able to join us in St. Julian’s, Malta, on April 13. You can secure your ticket here.
We look forward to seeing you in April!
Henrietta Dombrovskaya: I have a question again – a different one
On February 15, we had one more live meetup of the Chicago PostgreSQL User Group. I am very happy with how it went, except for one thing.
David E. Wheeler: Hello Mastodon 🐘
Hey all you Postgres people out there! Just wanted to make a quick post regarding the PGXN twitter bot. In light of the recent announcements by Twitter to charge for API use, I udpated PGXN Manager to also post to Mastodon! If youre have joined the exodus to the Fediverse, give it a follow:
Greg Sabino Mullane: PostgreSQL Unlogged Tables - Look Ma, No WAL!
While supporting customers at Crunchy Data, I sometimes see users add unlogged tables. In this post, I'm going to review some of the specifics about this.
Unlogged tables in Postgresql are a way of preventing specific tables from generating WAL (Write Ahead Log) information by adding the unlogged keyword to a create table command:
CREATE UNLOGGED TABLE foobar (id int);You can also change existing tables to unlogged, and switch them back again:
Christophe Pettus: UUIDs vs serials for keys
This topic pops up very frequently: “Should we use UUIDs or bigints as primary keys?”
One of the reasons that the question gets so many conflicting answers is that there are really two different questions being asked:
- “Should our keys be random or sequential?”
- “Should our keys be 64 bits, or larger?”
Let’s take them independently.
Should our keys be random or sequential?There are strong reasons for either one. The case for random keys is:
Oliver Rice: Type Constraints in 65 lines of SQL
Christophe Pettus: “Database Patterns and How to Find Them” at SCaLE 2023
I’ll be speaking on Database Antipatterns and How to Find Them at SCaLE 2023, March 9-12, 2023 in Pasadena, CA.
Christophe Pettus: “Extreme PostgreSQL” at PgDay/MED
I’m very happy that I’ll be presenting “Extreme PostgreSQL” at PgDay/MED in Malta (yay, Malta!) on 13 April 2023.
Andreas Scherbaum: PostgreSQL 95
Someone at FOSDEM 2023 asked the question: "What happens when PostgreSQL rolls over the version number to 95? Will this cause problems like back then in Windows?"
Ryan Booz: PostgreSQL Patch of Interest (to me): Using the System CA Pool for Certificate Verification
Pavlo Golub: Go & PostgreSQL: FOSDEM 2023 talk
On the 5th of February 2023, I had the privilege of giving a talk at the PostgreSQL devroom during FOSDEM 2023 titled “When it all GOes right.” My talk focused on the process of creating programs in the Go language using a PostgreSQL database. It was an incredible opportunity to share my insights and experiences with fellow open-source enthusiasts from around the world, and to discuss the latest trends and developments in this rapidly evolving field.
Deepak Mahto: Get the most out of PostgreSQL using psql with must known features.
If you’re a PostgreSQL user, you’re likely familiar with psql – the interactive terminal that connects you to your Postgresql databases. psql tool is more than just a basic utility. In fact, I consider it to be an essential asset for anyone working with PostgreSQL databases. With an impressive range of features, tips, and tricks, psql is go to tool to talk with PostgreSQL. It never fails to impress and surprise you with its incredible capabilities.
Lukas Fittl: Waiting for Postgres 16: Cumulative I/O statistics with pg_stat_io
Hans-Juergen Schoenig: PostgreSQL: Finding the current timestamp
PostgreSQL provides all kinds of time-related functions. But time is not as easy as it seems. One question many people keep asking: How can I find the current timestamp? What time is it?
While this seems like an easy question the answer isn’t as clear-cut as you might expect. Basically, there are three functions we might use to figure out what time it is: