You Can Make Postgres Scale — Newsflash: Postgres scales! After last week’s experiments with a 1 trillion row table using Citus, we know Postgres scales, but once you go beyond a certain point, bringing multiple machines into play becomes a potentially complex necessity and the PgDog horizontal scaling/sharding approach offers just one solution.

Lev Kokotov (PgDog)

Think About MERGE in Terms of a RIGHT JOIN — RIGHT JOIN isn’t encountered too often in SQL as you can just write a more universally understood LEFT JOIN alternative instead. However, right join semantics play an important role with the MERGE statement.

Lukas Eder

Sure, You Can Roll Your Own Auth - If You Hate Free Time — Don’t sacrifice your control. FusionAuth is downloadable, and can be developed and tested locally. A single-tenant architecture provides better scale and security than a purely multi-tenant SaaS model, even if you deploy via the cloud. Try it for free!

FusionAuth sponsor

Troubleshooting Duplicate Primary Key Rows — If a table has unwanted ‘duplicate rows’ (which can happen due to a variety of quirks causing corrupt unique indexes) Greg has a multi-step technique for getting things back under control.

Greg Sabino Mullane

Can Artificial Intelligence Create Better Tables Than You? — As someone guilty of leaning on LLMs for a little SQL grunt work lately, this was an interesting read. As ever, you need to stay on your toes and check anything produced before rolling it into production!

Dave Stokes

Xata Agent: An 'AI Expert' in Postgres — An open source agent that monitors your database, finds root causes of issues, and suggests fixes and improvements. It’s early days in this space but it’s interesting to see different takes on the idea.

Xata

pgFormatter 5.6: A Tool to Format SQL Code — You can test it out online, or you can grab the source from GitHub (it’s written in Perl) and run it for yourself. What’s new in v5.6.

HexaCluster

pg_ivm 1.10: Incremental View Maintenance (IVM) Extension — A more efficient way to update materialized views incrementally, applying only changes instead of fully recomputing the view like REFRESH MATERIALIZED VIEW does.

IVM Development Group

pgzx 0.3: Create Postgres Extensions using Zig — If you’re familiar with pgrx as a way to build Postgres extensions with Rust, this is a similar idea in the world of Zig, another modern systems language that’s a little more C-like than Rust.

Xata