Wrote about the new system views in PG19. I think this might be the longest I’ve ever spent on a blog 😅 I expanded on the pg_stat_lock (cumulative, cluster-wide lock statistics with one row per lock type). Covered a lot on pg_stat_recovery & pg_stat_autovacuum_scores. All with demo queries! 🐘 🚀

Planet PostgreSQL@planet.postgresql.org · 3w ago

Gülçin Yıldırım Jelínek: New system views in PostgreSQL 19 https://postgr.es/p/9tF #postgresql

Fun fact: instant branching is not a function of data size. 10 TB database is also branched / clones in around 1 second. Here is the power of that using "xata scratch", instant disposable Postgres branch (a scratch pad) that's automatically deleted the moment your session ends.

Xata - Postgres at Scale@xata.io · 2mo ago

2TB+ Postgres. Branch it in seconds, query it, delete it. xata scratch (new Xata CLI cmd) forks a disposable branch off your real DB, drops you into psql or runs SQL inline, tears it down on exit. Demo 👇

Nobody will ever beat Linus at this game. In 2005 he created git so that none of the haters would have any remaining excuse for not forking the kernel

Phillip Carter@phillipcarter.dev · 2mo ago

It's alway so fun to double-dog dare someone to fork and take the project seriously. Had too much fun doing that to drive-by losers in OSS projects who objected to codes of conduct

Tailscale is the most underappreciated tool in my stack. My RPi NAS in Bangkok is accessible from anywhere in the world. My homelab LM Studio endpoint is callable from my Mac. Zero port forwarding, zero VPN config, zero maintenance. Just works.

Donate $30 to an educational non-profit or open-source project and I'll credit you $30 toward The Consensus Standard subscription. I'm excited to support these organizations with you! theconsensus.dev/subscribe.html

I’ve written a blog post on why and how we built our own distributed storage engine. We’re calling it Xatastor and enables us to scale to a huge number of Postgres instances and branches. It’s based on ZFS and NVMe-oF as key technologies. xata.io/blog/xatasto...

Xatastor: ZFS + NVMe-oF for millions of Postgres instances by Tudor Golubenco

Read the technical details of our new distributed storage system, which is the key to scaling to a huge number of Postgres instances.

xata.io

We rebuilt the storage engine behind Xata Cloud. Today we're talking about why: xata.io/blog/xatasto...

Xatastor: ZFS + NVMe-oF for millions of Postgres instances by Tudor Golubenco

Read the technical details of our new distributed storage system, which is the key to scaling to a huge number of Postgres instances.

xata.io

I got @home-assistant.io loading over a wasm build of @tailscale.com, completely in the browser :D

Getting into split keyboards after all these years! blog.divyendusingh.com/p/split-keyb...

Getting into split keyboards using two cheap keyboards

Validating the mechanical keyboard rabbit hole using thick paper, two Logitechs, and Karabiner-Elements.

blog.divyendusingh.com

Back to textbooks: Denmark rolls back digital learning. Denmark was quick to adopt digital technologies in the classroom, but wise enough to examine the impact on students, which led to a roll back in specific areas. www.youtube.com/watch?v=aKoC...

Back to textbooks: Denmark rolls back digital learning • FRANCE 24 English

YouTube video by FRANCE 24 English

youtube.com

> tailscale is the secure way to connect all your computers! > i've used tailscale to connect my molty to all my computers and internal services and gave it all my keys oh no, not like that

Taking database snapshots and moving large volumes of data over the network is something our customers do regularly. While batching is the de facto way to make this efficient choosing the right batch size is non-trivial considering network variability, latency & system load. Read how we solved it👇🏽

Xata - Postgres at Scale@xata.io · 8mo ago

Batching is often used to process large volumes of data but a batch size that works in one network setup can perform poorly in another. We applied automatic batch size tuning to Postgres snapshots in pgstream to adapt across different network environments. Check the post 👇 xata.io/blog/postgre...

New in xata clone: AI-assisted PII removal config (schema → strict config → validated).

Xata - Postgres at Scale@xata.io · 8mo ago

New in xata clone: xata clone config --mode=ai Feed it your schema + prompt → get a strict, reviewable anonymization config that’s typically more complete than static heuristics. Blog post: xata.io/blog/smarter...

@divyendusingh.com is doing a great job making agents do all sorts of stuff using databases. In our case with a few simple instructions, they are able to do branching operations, run queries, validate bug fixes and more. The blog posts are paired with demo videos, have a look 👀 👇🏽

Xata - Postgres at Scale@xata.io · 8mo ago

AI agents get useful faster with guardrails, not plugins. Repo playbook: gh issue → xata branch create + xata branch wait-ready → xata branch url (not $DATABASE_URL) → psql repro/verify → fix. Video + write-up:

Batching is often used to process large volumes of data but a batch size that works in one network setup can perform poorly in another. We applied automatic batch size tuning to Postgres snapshots in pgstream to adapt across different network environments. Check the post 👇 xata.io/blog/postgre...

Optimizing data throughput for Postgres snapshots with batch size auto-tuning by Esther Minano Sanz

Why static batch size configuration breaks down in real world networks and how automatic batch size tuning improves snapshot throughput.

xata.io

posted about my Apple ID woes, please share widely? hey.paris/posts/appleid/

20 Years of Digital Life, Gone in an Instant, thanks to Apple

Here’s how Apple “Permanently” locked my Apple ID. I am writing this as a desperate measure. After nearly 30 years as a loyal customer, authoring technical books on Apple’s own programming languages (...

hey.paris

Dr Paris Buttfield-Addison 🔜 MIGW26@hey.paris · 9mo ago

yep so my apple account is permanently gone, so I guess time to switch to linux and android eh

Can an AI Agent follow the same workflow that human developers can? We explored giving AI agent access to the database branch, a compute sandbox to execute code and instructions to follow a developer workflow (in plain English) and the experiment was a success.

We explored giving AI agents access to compute (via Sandbox) and database via Xata branches and some “commandments” to follow a developer-like workflow.

So excited for this one, looking forward to sharing our experience of building a LLM powered on-call database agent. As someone who is writing 90+% of code with agents in the last 2 months, looking forward to share the parallels and experience between coding and monitoring agents.

Xata - Postgres at Scale@xata.io · 12mo ago

Can an AI agent handle your Postgres on-call? @divyendusingh.com from @xata.io is speaking at the Postgres Berlin Meetup tomorrow showing how we’re using LLMs to automate DB diagnostics, fixes, and even PRs. Come see “Xata Agent” in action. 📍 RSVP: www.meetup.com/postgresql-m...

Just published a deep dive on how every Vercel preview gets a full production database copy. But that's not even the best bit. Want to know how to safely update your database schema add a column, rename a field, even do complex behind‑the‑scenes transformations while production keeps humming?

Zero Downtime Schema Changes with Vercel and Xata by Divyendu Singh

Discover how Xata’s pgroll‑powered platform plus Vercel preview deployments enable zero‑downtime Postgres schema changes with instant branches.

xata.io

I haven't seen the stars But I have touched the tall trees Where's my Nintendo An original haiku by my ten year old son Duke whilst camping.

This matches my experience

Brianna@mc.horse · last yr.

This is a thoughtful post that echoes conversations I've had IRL with colleagues and friends. Also: "You should use AI-powered tools to complement or increase your agency, not replace it." ^ This is where I've landed for my own work so far.. Should help me do & think *more* deeply, not less.

GitHub released Spark yesterday, their extremely well crafted prompt-to-app platform for creating and iterating on React apps with user auth and persistent storage I like it a lot! I reverse engineered it with Spark itself, the details are fascinating simonwillison.net/2025/Jul/24/...

Using GitHub Spark to reverse engineer GitHub Spark

GitHub Spark was released in public preview yesterday. It’s GitHub’s implementation of the prompt-to-app pattern also seen in products like Claude Artifacts, Lovable, Vercel v0, Val Town Townie and Fl...

simonwillison.net

May was wild. One moment I’m design and coding, the next I’m on stage performing for millions. Still can’t believe it. Grateful for everything. 💙

📣 We have a brand new Postgres platform with: Instant Copy-on-Write branching Built-in data anonymization Separation of storage and compute 100% vanilla Postgres It’s for staging/dev environments as well as for production workloads. Blog post: xata.io/blog/xata-po... And more details in 🧵

Xata is one of the few female-founded companies in the Postgres world, and 40% of our team are women. Because inclusion is built, not wished for. Proud to host another "Women In Postgres" breakfast at #PGConfDE in Berlin. Great breakfast, even greater conversations! 💜

What time is it? It is PGConf time 🐘

Vibes of Szczecin 🇵🇱

Vibes from Düsseldorf

🌅