Neues vom PostgreSQL Planet
Andrew Dunstan: Announcing Release 18 of the PostgreSQL Buildfarm client
I have pushed Release 18 of the PostgreSQL Buildfarm client
In addition to numerous minor tweaks and bug fixes, the following changes are made:
Robert Haas: Why pg_dump Is Amazing
I wrote a blog post a couple of weeks ago entitled Is pg_dump a Backup Tool?. In that post, I argued in the affirmative, but also said that it's probably shouldn't be your primary backup mechanism. For that, you probably shouldn't directly use anything that is included in PostgreSQL itself, but rather a well-maintained third-party backup tool such as barman or pgbackrest.
semab tariq: Offline PostgreSQL Installation on RHEL 9: Solving the No Internet Challenge
PostgreSQL is one of the most loved databases, especially by developers, for its simplicity, easy configurations, and massive community support. It's an open-source powerhouse known for handling everything from small projects to large-scale applications.
While major cloud providers, like AWS, Google, and Microsoft offer robust solutions for hosting databases on the cloud, not all businesses can or want to go this route
Jimmy Angelakos: Contributions for the week of 2024-10-21 (Week 43 overview)
- On October 22nd the Extensions Ecosystem Summit took place, as an unofficial side event of PGConf EU in Athens. Supported by Tembo](https://tembo.io/), Percona, Xata, and Timescale, 5 speakers shared their (experience working on) extensions, followed by an open space / contribution fest meant to attract new contributors to the projects.
Christophe Pettus: An Interlude: Why you do not want to use C/POSIX locale.
(A quick interlude in our series on locales and character encodings in PostgreSQL.)
C/POSIX locale is only useful if you know that you will never have characters in your strings other than 7-bit ASCII, or you are 100% sure that you are never going to have mixed client encodings. If you do have non-7-bit-ASCII characters with mixed client encodings, zaniness can result:
Stefanie Janine: PostgreSQL in The Big Apple
For the first time we have a guest writer, Emma Saroyan.
Discovering PostgreSQL - My JourneyI recently traveled from Armenia to New York City to speak at PGConf NYC 2024, organized by PgUS. PostgreSQL, originally called Postgres, is the #1 open source relational database in the world. I gave a talk about my journey into discovering Postgres, and it was an inspiring experience engaging with the PostgreSQL community, sharing insights, and learning about the latest advancements in the field.
David Wheeler: PGConf & Extension Ecosystem Summit EU 2024
Last week I MCed the first Extension Ecosystem Summit EU and attended my first at PGConf EU in Athens, Greece. Despite my former career as an archaeologist — with a focus on Mediterranean cultures, no less! — this was my first visit to Greece.
Jimmy Angelakos: Contributions for the week of 2024-10-14 (Week 42 overview)
- On October 15th, Paul Jungwirth presented temporal INSERT at the Chicago PostgreSQL User Group (PUG) meetup. You can find the recording and write-up here.
Christopher Winslett: 4 Ways to Create Date Bins in Postgres: interval, date_trunc, extract, and to_char
You followed all the best practices, your sales dates are stored in perfect timestamp format …. but now you need to get reports by day, week, quarters, and months. You need to bin, bucket, and roll up sales data in easy to view reports. Do you need a BI tool? Not yet actually. Your Postgres database has hundreds of functions that let you query data analytics by date. By using some good old fashioned SQL - you have powerful analysis and business intelligence with date details on any data set.
Shayon Mukherjee: Using CTID Based Pagination for Data Cleanups in PostgreSQL
Hubert 'depesz' Lubaczewski: New way to search PostgreSQL documentation
Hubert 'depesz' Lubaczewski: Case study: optimization of weirdly picked bad plan
Umair Shahid: Transitioning from Oracle to PostgreSQL: PL/SQL vs PL/pgSQL
Structured Query Language (SQL) is the standard language for managing and manipulating relational databases. It serves as the core mechanism for interacting with databases, enabling users to perform tasks such as querying data, updating records, and managing database structures. SQL’s declarative nature makes it ideal for retrieving and modifying data, but it has limitations when it comes to implementing complex business logic directly within the database.
Gülçin Yıldırım Jelínek: Prague PostgreSQL Meetup on October 29th
Stefanie Janine: Recap pgconf.eu 2024
This years conference took place in Athens, Greece from October 22nd until October 25th.
It has been the biggest European PostgreSQL conference so far with more than 780 attendees.
I am very proud that my company, ProOpenSource OÜ, has sponsored each PostgreSQL Europe Conference since the company has been founded.
Christophe Pettus: Speaking in Tongues: PostgreSQL and Character Encodings
This is the second installment in our discussion of locales, character encodings, and collations in PostgreSQL. In this installment, we’ll talk about character encodings as they relate to PostgreSQL.
A quick reminder!A character encoding is a mapping between code points (that is, numbers) and glyphs (what us programmers usually call characters). There are lots, and lots, and lots of different character encodings, most of them some superset of good old 7-bit ASCII.
Christophe Pettus: “Gentlemen, this is a 🏈”: Glyphs, Encodings, Collations, and Locales
If you are not familiar with the quote.
This is part one of a series on PostgreSQL and collations, and how to use them without tears. This is an introduction to the general concepts of glyphs, character encodings, collations, and locales.
GlyphsThere is (as always in things involving real human behavior) some controversy over what is a gylph and what isn’t, but as a first approximation, we can use this definition:
Robert Haas: PostgreSQL Hacking Workshop - November 2024
Next month, I'll be hosting a discussion of a talk by Andy Pavlo, given for his Intro to Database Systems course at CMU. The title of the talk is "Memory & Disk I/O Management and the video link is https://www.youtube.com/watch?v=aoewwZwVmv4. As usual, we have will have three sessions, and you can sign up to participate in one of them using this form.
Andrew Farries: pgroll 0.7.0 update
Henrietta Dombrovskaya: Chicago PUG October 15 recording
As many of my followers may recall, we had the pleasure of Paul Jungwirth presenting at the Chicago PUG meetup on October 15. I have high hopes for having true temporal data support in Postgres 18, and I wanted to know all the details of what to expect. I believe I can speak on behalf of everyone who watched and was present on October 15, either in person or virtually – it was an exceptional talk! I do not recall any other meetups where so many people asked me about the recording – and it is finally here!
Enjoy!