New episode of the #TalkingPotgres #podcast

In Ep27, Peter Farkas of @ferretdb shares how a Himalayan trek led to building an open source MongoDB alternative on top of #PostgreSQL (& the newly-open sourced DocumentDB extension from Microsoft)

Plus: FerretDB was NOT the original name. And how Trappist cheese now gets a footnote in database history.

Listen wherever you get your podcasts. And if you like the show PLEASE tell your friends so they can discover it too

#database #FerretDB #Postgres #OpenSource #Community #NoSQL #Microsoft

https://talkingpostgres.com/episodes/how-i-got-started-with-ferretdb-why-we-chose-postgres-with-peter-farkas
https://youtu.be/dQfD00bDMqo?feature=shared

Announcing the TechBash 2025 Workshops | Nov 4-7 | Kalahari Resorts, PA.

https://vlqh-zgph.campaign-view.com/ua/SharedView?od=3z5b1449310f71294fafc3d35955582e56a7fc9cec01fb440bc3cc8ba398aa18db&cno=11a2b0b1d5478b9&cd=1e7349b985605962&m=0

Y a-t-il des adeptes de #PostgreSQL dans le Fédiverse qui vivent à #Lille et sa périphérie ?

J’envisage de créer un compte Mastodon pour le Meetup éponyme de ma région, et varier les canaux de communication pour ne pas être enfermé sur LinkedIn.

Un repouet fait vivre la communauté et nourrit des pachydermes

Announcing the TechBash 2025 Workshops!

#csharp #cloud #containers #ai #messaging #postgresql #database

https://zc.vg/hb6wM?m=0

pgconf.de has started and talks are great. Gianni Ciolli presents The Well-Tempered Elephant #postgresql #pgconfde

Conference starts now! Valeria Kaplan will talk about #PostgreSQL community people and processes. #pgconfde

Waiting for Postgres 18: Accelerating Disk Reads with Asynchronous I/O

https://pganalyze.com/blog/postgres-18-async-io

I finally managed to get #pgBackRest running for my #PostgreSQL #Patroni cluster to make two independent local backups of both the primary and the replica database cluster. The important part is that pgbackrest running on the replica has to be able to connect to the primary.

To-do: figure out, how to restore a Patroni cluster with pgBackRest.

Also, does anyone know how to display the WAL files pushed into pgBackRest with the "archive_command"?

https://pgbackrest.org

Old comment on forum: Migrating from #postgres 9.5 to 11+ is painful.

Me, migrating from 9.4 to 17.2 for several weeks: Huh, I didn't think about it...

This week is pgconf.de
Next week is pgconf.dev

Week after?

This week is a LIVE recording of the next episode of the monthly #TalkingPostgres podcast

Guest: Peter Farkas
Ep27 topic: How I got started with FerretDB (& why we chose Postgres)

Where: Microsoft Open Source Discord
When: Wed May 7 @ 10am PDT

Boosts appreciated, pls tell your #PostgreSQL & #FerretDB friends

Calendar invite: https://aka.ms/TalkingPostgres-Ep27-cal

PostgreSQL, we've generally heard, is "good enough" for most intents and purposes.

We'd love to know what YOU think. What's stopped you from using #PostgreSQL in the past, and what solution did you choose instead? When have you opted for #Postgres where it turned out better than expected?

- https://postgresweekly.com/issues/598

PGlite 0.3: Postgres on WASM, Now Based on Postgres 17 —

PGlite is a WebAssembly-based build of Postgres that enables you to run an instance of Postgres wherever WebAssembly can be run (such as in the browser as in this demo).

v0.3 takes a big step forward in moving up to Postgres 17.4

- https://pglite.dev/
- https://github.com/electric-sql/pglite

Wishing everyone a great time at PGConf.BE by volunteers starting today in UCLL - Campus Proximus in #Haasrode (Leuven), #Belgium

Find out more on https://foss.events/2025/05-06-pgconf-be.html

Official hashtag(s): #postgresql

What's new with Postgres at Microsoft? The 2025 edition of our annual blog post is now live.

Over the past year, the team at Microsoft who work on Postgres has contributed across multiple fronts:

New features in Azure Database for PostgreSQL - Flexible Server
Code contributions to Postgres 18 (including async I/O!)
Open source work on the Citus extension
Contributions to the Postgres open source community—things like @posetteconf, helping make @pgconfdev happen, the Talking Postgres #podcast, and sponsoring #PostgreSQL conferences around the globe

This year's blog post includes a hand-made infographic that maps out the major workstreams—plus highlights, explanations, links, and shout-outs to some of the many people behind the work.

If you care about PostgreSQL—as a user, contributor, or fan—I hope you'll give it a read.

Read the full blog post on Microsoft Tech Community: https://techcommunity.microsoft.com/blog/adforpostgresql/whats-new-with-postgres-at-microsoft-2025-edition/4410710

I'm very impressed how easy it is to use #OpenStreetMap data locally:

1. Download a subset of OSM on https://download.geofabrik.de/ for your country.
2. Use Osmium to filter by tags and export into a TSV.
3. Import the TSV into #PostgreSQL using a single \copy command.
4. Create a btree_gist index for #PostGIS geospatial and ordinary queries.

In less than 5 min, you're ready to run queries like "nearest restaurants around me" locally & fast!

Kudos for making it so simple, which is not easy. =)

I am getting into writing PostgreSQL functions in the C language and I am particularly interested in ordered-set aggregate functions.

Is there anyone out here who can direct me in the right direction?

Deploy Java Like a Pro: Your First Quarkus App on OpenShift in Minutes
A fun, hands-on guide for Java developers to build a REST API with Quarkus, PostgreSQL, and deploy it to OpenShift Developer Sandbox
https://myfear.substack.com/p/quarkus-rest-api-openshift-postgresql-guide
#Quarkus #Java #OpenShift #PostgreSQL #Kubernetes