Join data across clouds in a single query as easily as if all tables were on a single system.

Have you seen the syntax of INNER JOIN? Of course! What about NATURAL INNER JOIN?

https://coffingdw.com/new-to-sql-is-the-keyword-natural-join/

If you're using Akamai Cloud, guess what? pgEdge Distributed #PostgreSQL is now available on this cloud vendor (formally known as #Linode) in order to bring performance and availability for #database infrastructure to edge networks.

Read more about our latest partnership on our blog:

https://www.pgedge.com/blog/pgedge-distributed-postgresql-now-available-on-akamai-cloud

https://coffingdw.com/date-functions-date-formats-and-timestamp-formats-for-all-databases-45-blogs-in-one/

PlanetScale for Postgres

Link: https://planetscale.com/blog/planetscale-for-postgres
Discussion: https://news.ycombinator.com/item?id=44434667

You will never forget the first time you saw a 30-table join spanning 30 systems in a single query.

https://coffingdw.com/30-table-join-across-30-different-systems-shocks-the-it-world/

KI #Chatbot erstellen mit #n8n und Wissensdatenbank (#RAG)!

https://www.youtube.com/watch?v=3XRRxUTVszU

Hi from #Jinan, #China @ Highgo Open World (#PostgreSQL & #IvorySQL Eco Conference")

> With the mission of "linking the world with open source", Highgo emphasizes the core role of open source technology in the field of database basic software, and is committed to promoting industry development through sharing and cooperation, while connecting and empowering global users.

https://ivorysql.io/

pro tip for user interface designers:

if you have hundreds of millions of dollars of venture capital and you want to make a user facing data analytics tool of some kind and you think it's reasonable to ask an average human being to type this:

CAST('2023-05-01' AS TIMESTAMP)

to do literally anything with a date or time in your application's user interface, just stop right there. do not pass go, do not collect $200, and do not ever attempt to offer feedback to a UX designer ever again. something is deeply broken inside you that means there are certain mysteries of the universe that even the guys who designed the postgres command line can access that you will never know, and that's ok. You can still live a really rad life.

It can be challenging to run applications with stringent high availability requirements, low latency requests, and ensure there's a reliable database management system powering it all. Luckily, there's #PostgreSQL to the rescue.

Multi-master distributed #Postgres as a solution is discussed in depth in our technical whitepaper - view it here: https://www.pgedge.com/landing-pages/multi-master-whitepaper

From Highgo Software Inc., the HOW2025 Eco Conference is in 2 days - will you be there? Say hi to our team!

It is a community-driven technical conference dedicated to advancing #OpenSource technology, especially focused on the #database field (particularly on #PostgreSQL and IvorySQL, a #Postgres distribution with #Oracle compatibility). Registration is 100% free, and it will be live streamed.

Don’t miss tomorrow’s webinar on what’s new in #MariaDB 11.8 LTS—features, improvements, and why it matters for your apps.

Register now and join us live: https://go.mariadb.com/25Q2-WBN-GLBL-Community11.8-2025-06-25_Registration-LP.html

Interesting Bits of Postgres Grammar

Link: https://steve.dignam.xyz/2025/06/20/interesting-bits-of-postgres-grammar/
Discussion: https://news.ycombinator.com/item?id=44356597

New episode 28 of the #TalkingPostgres #podcast is out!

Peter Cooper (@cooperx86)—the witty, irreverent, & wicked smart programmer & editor-in-chief of Cooperpress—joined me to talk about "12 years of Postgres Weekly"

We started near the Prime Meridian and time-traveled through his early days writing QBASIC fanzines on Usenet, all the way to building a newsletter empire that reaches nearly half a million devs each week—with his own geeky, opinionated tone of voice.

Spam filters, photoshop, & one very cheesy story included. Give it a listen & please boost

https://talkingpostgres.com/episodes/12-years-of-postgres-weekly-with-peter-cooper

https://youtu.be/F1eWSAVKxdY?si=YLeHXVw5inGzNOSS

Show HN: SnapQL – Desktop app to query Postgres with AI

Link: https://github.com/NickTikhonov/snap-ql
Discussion: https://news.ycombinator.com/item?id=44326620