Urgent.News

What's breaking now, across thousands of outlets.

Tech

How long do you keep a published claim provisional?

I retracted a benchmark this week. Two weeks ago I published a timing figure, described it as a fixed cost, and built an argument on it. Today the same script on the same machine ran two and a half times faster, and the reason was that I had taken the original reading while my laptop was under a load average of 70 from an unrelated experiment. That is the fourth thing I have had to correct this…

The author of a published claim faces a decision on how long to retain the validity of their findings. They have experienced four instances of needing to correct published figures, each due to factors like unrecorded conditions, truncation of queries, retry helper budget issues, and reader feedback. The author believes the optimal approach is to treat all published numbers as provisional and version the post with a changelog.

However, this would require maintaining multiple versions of posts, which they find unsustainable with their current volume. Alternatives include setting an expiry date for measurements, which they find cheap but insufficient for catching immediate errors. The author also observes that corrections often lead to more useful content than the original posts.

They question whether their writing team or their own practice has an explicit shelf life for measured claims, or if they only retain truth until they receive feedback. The dilemma lies in whether to make numbers permanent until challenged or to maintain a flexible approach to revisiting published information.

Written by urgent.news from Dev.to's reporting — not their text. Machine-written — may contain errors; check the original before relying on it.

Read the original at dev.to →

More in Tech

My writing linter can be defeated by writing more. I measured how much more.

I ran my writing checker over one of my own published posts twice: once on the whole file, once on just the body with the front matter removed. Same post. Same prose.

  • Writing linter scores unchanged when front matter removed
  • Density-based tests can be reduced by adding non-objective text
  • Separating set-based and density-based scores prevents padding

Self-hosting break-even: $23/month of SaaS, a $170 mini PC, about 9 months

Replacing $23/month in SaaS subscriptions (Google One 2TB + 1Password + Plex Pass) with a $170 mini PC drawing 15W idle breaks even in about 9 months.

  • Replacing $23/month SaaS with $170 mini PC yields 9-month break-even
  • Payback depends on what services are replaced, not on $10/month storage
  • Electricity costs and hardware choice significantly affect break-even timeline

Adding a NOT NULL Column to a Large PostgreSQL Table: Constant Default, Backfill or NOT VALID

Disclosure: I build Schemity , a desktop ERD tool - this post is from our blog and uses it for the examples. TL;DR: On PostgreSQL 11 and later, ADD COLUMN ...

  • Adding a NOT NULL column with constant default (e.g., NOW()) is fast in PostgreSQL 11+.
  • For per-row computed values, add column as nullable, backfill in batches, then set NOT NULL.
  • PostgreSQL 12+ allows NOT VALID constraint to skip full table scan during backfill.

More from Thursday 1 October →