Exciting news!
My book PostgreSQL Mistakes and How to Avoid Them is going to print very soon! You can pre-order now during
@ManningPublications's flash sale — everything is 50% off.
Get it while it's hot! https://www.manning.com/books/postgresql-mistakes-and-how-to-avoid-them?utm_source=vyruss&utm_medium=affiliate&utm_campaign=flash_sale_4_16_25&a_aid=vyruss&a_bid=ca6764d9

Unexpected usecases for #postgres #postgresql #postgis https://dev.to/shayy/postgres-is-all-you-need-3pgb

Ive built a setup for hosting websites which consists of:
* Host running #microos with #podman
* #Treafik and #sshpiper at the edge
* #Nginx, php-fpm, #mariadb + phpmyadmin + nginx or #postgres + dbadmin, openssh for each site

It actually works quite well, openssh keybased access is to transfer files into the containers, traefik does the reverse proxying.

I'm just wondering if its a sustainable and maintainable setup. Sometimes just going with a "standard" solution seems so much easier.

Hacking the Postgres Wire Protocol

Link: https://pgdog.dev/blog/hacking-postgres-wire-protocol
Discussion: https://news.ycombinator.com/item?id=43693326

I recently leaned on an #LLM to help me get data out of a legacy database. The key was a multi-step prompt that took an existing schema and compressed it. That allowed me to build a chat bot that understood and could generate SQL for the answers I was seeking.

https://www.joecotellese.com/posts/2025-04-10-accelerate-database-understanding-with-llms/

#osm2pgsql v2.1.0 released #osm #openstreetmap #postgres #postgis

https://github.com/osm2pgsql-dev/osm2pgsql/releases/tag/2.1.0

Good one.

Show HN: Hatchet v1 – a task orchestration platform built on Postgres

Link: https://github.com/hatchet-dev/hatchet
Discussion: https://news.ycombinator.com/item?id=43572733

"Managing #PostgreSQL at scale: Challenges, Tools, & Techniques" will be presented by @karenhjex (Karen Jex) at #PosetteConf 2025 (Livestream 3 on Wed Jun 11th @ 9:00am PDT (UTC-7))

Learn more: https://posetteconf.com/2025/talks/managing-postgres-at-scale-challenges-tools-techniques/

An interesting PostgreSQL Claude Sonnet 3.7 hallucination

Would you like to see a more inclusive and diverse PostgreSQL community? We would too! Consider joining the PgUS Diversity Committee to help make that a reality!

https://postgresql.us/diversity/

Show HN: Cloud-Ready Postgres MCP Server

Link: https://github.com/stuzero/pg-mcp
Discussion: https://news.ycombinator.com/item?id=43520953

Postgres Language Server: Initial Release

Link: https://github.com/supabase-community/postgres-language-server
Discussion: https://news.ycombinator.com/item?id=43513996

I just came back from my second SCaLE (22x)! I hosted 3 days of live broadcasts from the conf, and spoke about Row-Level Security:

https://vyruss.org/blog/scale-22x-live-streams-row-level-security-sucks.html

Great read on debugging a Postgres performance mystery. You will learn a lot about Postgres internals just by following the author's thought process. (btw, what a grafana theme! ) #postgres https://blog.danslimmon.com/2025/03/14/did-u-ever-read-so-hard-u-accidentally-wrote/

"Building modern Python web apps with PostgreSQL" will be delivered by Pamela Fox (@pamelafox) at #PosetteConf 2025 (Livestream 1 on Tue Jun 10th @ 10:00am PDT (UTC-7)).

Learn more: https://posetteconf.com/speakers/pamela-fox/

Frage an die Admins: Nehmt Ihr ein spezielles Tool um ein Backup der PostgreSQL Dbs zu erstellen? Eventuell eins was danach noch eine Mail/ein Protokoll rausgibt?
#postgresql #postgres

You Can Make Postgres Scale

Link: https://pgdog.dev/blog/you-can-make-postgres-scale
Discussion: https://news.ycombinator.com/item?id=43364668

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/