New episode of #TalkingPostgres #podcast (we're up to Ep25!)

Dawn Wages @BajoranEngineer: #Django dev, Python Software Foundation board chair, & author of upcoming book "Domain-driven Django"—joined the pod to chat about why so many Python developers Just Use Postgres

Give it a listen wherever you get your podcasts. And give it a boost !

Dawn is a gem & this conversation was FUN. #PostgreSQL #OpenSource #Python #Postgres

https://talkingpostgres.com/episodes/why-python-developers-just-use-postgres-with-dawn-wages

https://youtu.be/leir3xJ4Klo?feature=shared

Boriss Mejias & Sarah Conway are part of the slate of speakers for #PosetteConf 2025. They will be telling a Postgres Story about "Cunning Schema Design with Creative Data Modeling" (Livestream 1 on Tue Jun 10th @ 9:00am PDT (UTC-7)).

Learn more: https://posetteconf.com/2025/talks/postgres-storytelling-cunning-schema-design-with-creative-data-modeling/

Are you watching? The Citus 13.0 Launch Party is LIVE now on YouTube:

> A few of the Citus #OpenSource engineers who know the Citus database extension to Postgres inside and out will host an informal walk through of what’s new in Citus 13.0—with DEMOS and Q&A.

Our team proudly contributed to this latest release and we're happy to have been a part of addressing important bugfixes and introducing new features.

Tune in:

https://www.youtube.com/live/DrCu8SX2nDM

New #PostgreSQL event announcement - Postgres Extensions Day 2025 in Montreal is "a full day dedicated to extensions – their development, lifecycle, and so on. A perfect event for extension developers and heavy extension users."

It's a free event and you can register now: https://pgext.day/

Call for Speakers is open until April 1st. https://sessionize.com/pgextday2025mtl

The LIVE recording for the #TalkingPostgres #podcast is happening on Wed 12 Mar at 10:00am PDT. Hope you can join us (or at least tell your database friends!) Boosts are always, always appreciated

This is Ep25 & the guest will be Dawn Wages @BajoranEngineer who is director of Community & Developer Relations at Anaconda—& will be talking about "Why Python developers just use Postgres"

#databases #python #django #OpenSource #PostgreSQL #Postgres

https://aka.ms/talkingpostgres-ep25-cal

In 2024, the Data Bene team traveled to, presented at, & sponsored a number of #PostgreSQL community events, as well as started a blog, began a podcast in collaboration with Xata, and contributed back to #OpenSource.

Curious to know the details and see what we learned as a result of our experiences? Check out our new #Substack (free to subscribe) to see our recap for the year:

https://open.substack.com/pub/databene/p/engaging-with-the-postgresql-community

En 2024, l'équipe de Data Bene a voyagé, a présenté un certain nombre d'événements communautaires de la communauté #PostgreSQL, ainsi qu'un blog, a commencé un podcast en collaboration avec Xata, et a contribué à #OpenSource.

Curieux de connaître les détails et de voir ce que nous avons appris à la suite de nos expériences? Découvrez notre nouveau #Substack (abonnement gratuit) pour voir notre récapitulatif pour l'année:

https://open.substack.com/pub/databene/p/sengager-avec-la-communaute-postgresql

So today was officially my last day on this job.

Still looking for another.

#fedihire anyone want a #python / #django / #postgres /FullStack engineer?

From Australia?

Innovation is happening around us in tech all the time; it's super helpful to be able to understand how different technologies are evolving and affected by current events. This write up by @andy_pavlo is a great reference for a recap of how the database world was affected in 2024, including license changes, acquisitions, and market standings.

https://www.cs.cmu.edu/~pavlo/blog/2025/01/2024-databases-retrospective.html

Avez-vous déjà vu notre podcast #Postgres Café ? Sinon, vous pouvez voir tous les épisodes précédents ici :

https://www.youtube.com/playlist?list=PLf7KS0svgDP_zJmby3RMzzOVO45qLbruA

Seriez-vous intéressés à recevoir plus d'épisodes de ce podcast avec Xata.io sur les extensions #PostgreSQL, l'open source, la communauté et des sujets similaires ? Nous voulons savoir ! Dites-le nous dans les commentaires ci-dessous

Here's an sqlc + postgres query, used to fetch a list of posts to be displayed on a user's profile:

-- name: GetPostsByAuthor :many
SELECT * FROM posts WHERE author = $1;

Can you spot the problem with this query? ;)

Any of you good people on software dev Mastodon have a good solution to this problem?

For legal reasons, we need to store datetime values in a Postgres DB that will adapt to future political changes in TZ/DST rules. The dates are often several decades into the future. So a TZ for a given day at a given hour must be correct when it arrives. UTC cannot store this info, and UTC is what Postgres stores it seems.

cc @mpejcoch

I'll never write "INSERT INTO" again. Just use tables.

Docker Compose Postgres Connection: Troubleshooting and Best Practices
Master Docker Compose Postgres Connection! Learn best practices & troubleshooting tips for smooth database integration in your Dockerized environment. #DockerCompose #Postgres #DatabaseConnection #DataAnalysis #Python #DB2LUW
https://tech-champion.com/database/db2luw/docker-compose-postgres-connection-troubleshooting-and-best-practices/

¡Nuevo video sobre PostgreSQL!

Descubre cómo dominar las restricciones (NOT NULL, UNIQUE, PRIMARY KEY, FOREIGN KEY, CHECK) para asegurar la integridad y eficiencia en tus bases de datos.

Mira el video aquí: https://link.illustris.org/pgrestricciones

#ilovefs I've been using #Rstats since before it was version 1. #Emacs and #Latex even longer as well as awk/sed and all manner of utilities (I have vague recollections of kermit a utility not the frog). But today, I love my #Debian Bookworm with #KDE. And #Postgres. That's a lot of thank yous.

Hello, again #FediHire ... seems my contract is winding up sooner than expected.

Anyone need a #Python / #Django / Web / #Javascript senior dev with decades of experience?

Comfortable with #React and #htmx

And can tune your #postgres DBMS to keep it delivering

Based in Melbourne, Australia, and quite practiced at working remote.

When elephants meet. #postgres #mastodon #fosdem

@floord

New post: First look at combining multiple postgres databases into a single cloudnative-pg instance

https://www.beyondwatts.com/posts/combining-multiple-postgres-databases-into-a-single-cloudnative-pg-instance/