Hacker News: radimm

A Gopher Meets a Crab

radimm — Thu, 30 Apr 2026 06:30:53 +0000

Article URL: https://miren.dev/blog/gopher-meets-crab

Comments URL: https://news.ycombinator.com/item?id=47958944

Points: 1

# Comments: 0

New comment by radimm in "Hot Updates in Postgres"

radimm — Thu, 30 Apr 2026 06:21:13 +0000

Somehow it feel HOT updates are very confusing. You can also try to play with interactive visualizer to understand it better https://boringsql.com/visualizers/hot-updates/

Hot Updates in Postgres

radimm — Thu, 30 Apr 2026 06:20:14 +0000

Article URL: https://boringsql.com/posts/hot-updates/

Comments URL: https://news.ycombinator.com/item?id=47958861

Points: 1

# Comments: 2

New comment by radimm in "Pgbackrest is no longer being maintained"

radimm — Mon, 27 Apr 2026 13:18:03 +0000

This is the message the author posted on LinkedIn:

After a lot of thought, I have decided to stop working on pgBackRest. I did not come to this decision lightly. pgBackRest has been my passion project for the last thirteen years, and I was fortunate to have corporate sponsorship for much of this time, but there were also many late nights and weekends as I worked to make pgBackRest the project it is today, aided by numerous contributors. Every open-source developer knows exactly what I mean and how much of your life gets devoted to a special project.

Since Crunchy Data was sold, I have been maintaining pgBackRest and looking for a position that would allow me to continue the work, but so far I have not been successful. Likewise, my efforts to secure sponsorship have also fallen far short of what I need to make the project viable.

Like everyone else, I need to make a living, and the range of pgBackRest-related roles is very limited. I can now consider a wider variety of opportunities, but those will not leave me time to work on pgBackRest, which requires a fair amount of time for maintenance, bug fixes, PR reviews, answering issues, etc. That does not even include time to write new features, which is what I really love to do. Rather than do the work poorly and/or sporadically, I think it makes more sense to have a hard stop.

I will post a notice of obsolescence and archive the repository. I imagine at some point pgBackRest will be forked, but that will be a new project with new maintainers, and they will need to build trust the same way we did.

Again, many thanks to all the pgBackRest contributors over the years. It was a pleasure working with you!

PostgreSQL MVCC, Byte by Byte

radimm — Mon, 20 Apr 2026 06:16:20 +0000

Article URL: https://boringsql.com/posts/postgresql-mvcc-byte-by-byte/

Comments URL: https://news.ycombinator.com/item?id=47830946

Points: 4

# Comments: 0

PostgreSQL MVCC, Byte by Byte

radimm — Fri, 17 Apr 2026 13:22:49 +0000

Article URL: https://boringsql.com/posts/postgresql-mvcc-byte-by-byte/

Comments URL: https://news.ycombinator.com/item?id=47805658

Points: 3

# Comments: 0

New comment by radimm in "Show HN: DryRun – PostgreSQL MCP and schema advisor that works offline"

radimm — Wed, 08 Apr 2026 10:46:20 +0000

One of the benefit is that instead of LLM blindly advising you to do

> ALTER TABLE customers ALTER COLUMN email SET NOT NULL;

it can advise you to

-- Step 1: backfill NULLs UPDATE customers SET email = 'unknown-' || id || '@example.com' WHERE email IS NULL;

-- Step 2: add constraint without full table scan ALTER TABLE customers ADD CONSTRAINT customers_email_not_null CHECK (email IS NOT NULL) NOT VALID;

-- Step 3: validate in the background with a weaker lock ALTER TABLE customers VALIDATE CONSTRAINT customers_email_not_null;

Show HN: DryRun – PostgreSQL MCP and schema advisor that works offline

radimm — Wed, 08 Apr 2026 10:34:47 +0000

Article URL: https://github.com/boringSQL/dryrun

Comments URL: https://news.ycombinator.com/item?id=47688190

Points: 2

# Comments: 1

Don't let AI touch your production database

radimm — Tue, 07 Apr 2026 06:34:49 +0000

Article URL: https://boringsql.com/posts/dont-let-ai-to-prod/

Comments URL: https://news.ycombinator.com/item?id=47671463

Points: 4

# Comments: 0

New comment by radimm in "Good CTE, Bad CTE"

radimm — Tue, 31 Mar 2026 08:13:53 +0000

Thanks - I will recheck later today.

New comment by radimm in "Good CTE, Bad CTE"

radimm — Tue, 31 Mar 2026 07:45:00 +0000

OP here, damn - that's a very good point. Can't believe I missed it.

New comment by radimm in "I am definitely missing the pre-AI writing era"

radimm — Mon, 30 Mar 2026 07:39:58 +0000

This is exactly same struggle for me. Writing technical content about PostgreSQL and balancing my voice without sounding like LLM written is genuinely difficult.

As English is not my first language, I do run into problem where the line between fix my clumsy sentence and rewrite my thought is very thin. Same with writing "boring" technical explanation and more approachable content. I'm getting pushed back for both.