The video for our December PUG "What's New in PostgreSQL 18" with Christophe Pettus, is now available on our YouTube Channel:
The video for our December PUG "What's New in PostgreSQL 18" with Christophe Pettus, is now available on our YouTube Channel:
#PostgreSQL 18's new improvements simplify complex workflows, reduce round trips to the database, & make building modern apps more efficient than ever.
Our newest blog is focused on:
→ What's new in RETURNING clause functionality
→ Real-world use cases and performance benefits
→ How to leverage these enhancements in your applications
Perfect for devs & database architects looking to maximize PG18's capabilities.
Check it out: https://www.pgedge.com/blog/postgresql-18-returning-enhancements-a-game-changer-for-modern-applications
Diversity and inclusion make for a brighter community and a brighter future for everyone. Take a look at how our Diversity Committee incorporates that into our organization:
We are excited to welcome DALIBO ( @dalibo) as a Partner sponsor of pgDay Paris 2026! We could not run this event without our sponsors.
#PostgreSQL 18's new improvements simplify complex workflows, reduce round trips to the database, & make building modern apps more efficient than ever.
Our newest blog is focused on:
→ What's new in RETURNING clause functionality
→ Real-world use cases and performance benefits
→ How to leverage these enhancements in your applications
Perfect for devs & database architects looking to maximize PG18's capabilities.
Check it out: https://www.pgedge.com/blog/postgresql-18-returning-enhancements-a-game-changer-for-modern-applications
We are excited to welcome DALIBO ( @dalibo) as a Partner sponsor of pgDay Paris 2026! We could not run this event without our sponsors.
Postgres extension complements pgvector for performance and scale
https://github.com/timescale/pgvectorscale
#HackerNews #Postgres #pgvector #extension #performance #scale #database #technology
Obelisk 0.32: Cancellation, WebAPI, Postgres
https://obeli.sk/blog/announcing-obelisk-0-32/
#HackerNews #Obelisk #WebAPI #Postgres #Cancellation #TechNews
What We Learned from the Recent Mandrill Outage, https://mailchimp.com/what-we-learned-from-the-recent-mandrill-outage/.
Mailchimp encountered a database failure. This is the story of how they have fixed it.
This is TSQLparser, a complete T-SQL parser written in Go. It's the kind of thing you use when you want to abandon Microsoft SQL Server for good (parser, lexer, and AST builder, to be exact).
And here it is, GPL 3.0 licenced, or email me if you have any other ideas:
h@ual.fi
https://github.com/ha1tch/tsqlparser
#golang #foss #tsql #mssql #mssqlserver #db #database #parser #microsoft #sql #sqlite #postgres
Another milestone for us at Icelandic Met Office 🎉
This week we launched a new site with #avalanche forecasts and conditions, including recent avalanches. A major update was required in the background, migrating to #Postgres and building the APIs and of course the website handled by our friends at Origo & Metall with maps from MapTiler
Another milestone for us at Icelandic Met Office 🎉
This week we launched a new site with #avalanche forecasts and conditions, including recent avalanches. A major update was required in the background, migrating to #Postgres and building the APIs and of course the website handled by our friends at Origo & Metall with maps from MapTiler
$50 PlanetScale Metal Is GA for Postgres
https://planetscale.com/blog/50-dollar-planetscale-metal-is-ga-for-postgres
#HackerNews #$50PlanetScaleMetal #Postgres #GA #PlanetScale #DatabaseNews
Pg_ClickHouse: A Postgres extension for querying ClickHouse
https://clickhouse.com/blog/introducing-pg_clickhouse
#HackerNews #Pg_ClickHouse #Postgres #ClickHouse #Database #Extension #Querying #Tools
This is TSQLparser, a complete T-SQL parser written in Go. It's the kind of thing you use when you want to abandon Microsoft SQL Server for good (parser, lexer, and AST builder, to be exact).
And here it is, GPL 3.0 licenced, or email me if you have any other ideas:
h@ual.fi
https://github.com/ha1tch/tsqlparser
#golang #foss #tsql #mssql #mssqlserver #db #database #parser #microsoft #sql #sqlite #postgres
This is an extremely interesting article looking at the tradeoffs of using #pgvector for #Postgres in production, including the different vector indexing algorithms, metadata filtering, and hybrid search. I'm not sure about its conclusions yet, but definitely food for thought! https://alex-jacobs.com/posts/the-case-against-pgvector/
A fun looking project 🤩 SSE for Django using Postgres pub/sub as the messaging layer
Yet another great example of async Django. Long lived ASGI connections that just aren’t feasible with WSGI’s worker-per-connection model.
I’m looking forward to giving it a play.
https://github.com/usmanhalalit/DjangoRealtime #django #sse #postgres #async
PGlite – Embeddable Postgres
#HackerNews #PGlite #Embeddable #Postgres #PostgreSQL #Database #Development
A fun looking project 🤩 SSE for Django using Postgres pub/sub as the messaging layer
Yet another great example of async Django. Long lived ASGI connections that just aren’t feasible with WSGI’s worker-per-connection model.
I’m looking forward to giving it a play.
https://github.com/usmanhalalit/DjangoRealtime #django #sse #postgres #async