Claude Codeで複数の作業を並列に動かせるようになると、次に増えるのは「待ち」と「確認」だ。CIが落ちた、レビューが返ってきた、長い処理が終わった、外部サービスが復旧した。これらを人が見つけて、結果をコピーし、次の指示を出している限り、人が作業の中継地点になってしまう。
この発表では、LS…
📌 Overview We recently switched to version 7 (v7) uuid primary keys and saw significantly faster inserts for some tables. The databases were running Postgres 18.4 and mostly used v1 with some v4 uuid values for primary keys. Changing the column default involved running a single alter table command, but did require an exclusive lock on the table, blocking everything including selects. To solve that, we used a short lock timeout and lots of retries. The biggest speedup was 23x faster average execution time for a multi-row insert query called 12000 times per minute on a table with billions of rows.
Welcome to pg_shmemviz: PostgreSQL shared memory visualizer
Introduction The purpose of this blog post is to introduce pg_shmemviz, a new tool to visualize PostgreSQL shared memory. It follows the same approach as pg_walviz, bringing physical layout and byte level navigation to PostgreSQL shared memory instead of WAL segments. Views such as pg_shmem_allocations, pg_buffercache and pg_shmem_allocations_numa are useful...
WAIT FOR in PostgreSQL 19 lets a reader block until the replica has replayed a specific LSN. Measured against sticky routing, sleeps, and synchronous commit, on a replica that misses the write 99% of the time.
How we migrated lovable.dev away from Next.js and turned it into another Lovable app | Lovable
42M monthly visitors, 400 routes and 850K lines of code moved from Next.js on Vercel to TanStack Start on Lovable—route by route, mostly by agents, with one 11-minute incident along the way.
When Rosa first released SolidQueue, she did a fantastic talk on the internals of how it works and what trade-offs she made when building it. You should give it a watch. It’s where I first learned how the SolidQueue approach works, and why it performs as well as it does.
I wrote the batch implementation for SolidQueue (with feedback from loads of folks!), so as a complement to Rosa’s original talk, here’s a bit about how the internals of batches work.
rhsev/fileregister: Permanent ids and self-documenting binders for your files, in plain text; references survive renames, moves, and a change of machine.
Permanent ids and self-documenting binders for your files, in plain text; references survive renames, moves, and a change of machine. - rhsev/fileregister
Claude’s new system prompt really doesn’t want to reproduce song lyrics
Anthropic publish the system prompts for their Claude consumer applications (Claude.ai and the Claude mobile apps—sadly not for Claude Cowork or Claude Code). I love that they do this, and …