Urgent.News

What's breaking now, across thousands of outlets.

Sunday, 4 October 2026 Reading Room

Tech

Isolation Levels

Isolation Levels A deep-dive walkthrough of SQL transaction isolation levels — covering all five levels in precise, mechanical detail (Read Uncommitted, Read Committed, Repeatable Read, Serializable, and Snapshot as its own, genuinely distinct level), the crucial difference between Read Committed Snapshot Isolation and true Snapshot Isolation, the write skew anomaly that Snapshot permits but…

dev.to ·

We haven't written up this one. Dev.to has the full story — the link below goes straight to it.

Read the original at dev.to →

More in Tech

Our delete all my data button leaves one table alone, and the dialog says so

Two of the controls a privacy policy promises, export everything and delete everything, live in the same route file in our app. Neither is complicated.

  • Delete function excludes exercise attempts for AI scoring budget
  • Retains marker for review requests to reset account state
  • Policy retains assessment centre data until account deletion

·dev.to

Before you pay a stranger, write an acceptance test first

The leap nobody prices in You found someone who can do the thing. Their work looks good. Now you have to send money to a person you have never met, whose reputation you cannot check, whose claims you…

  • Acceptance test crucial before paying strangers for services
  • Limited first job with clear pass/fail criterion recommended
  • Seller completes small, honest rewrite by specified date

·dev.to

We dropped 8 indexes and added 3 without a single production statistic

A round of database work in our app fixed a handful of genuinely expensive reads and rationalised the indexes on the three hottest tables.

  • Eight indexes removed without affecting production statistics
  • Three new indexes added to improve query performance
  • Dashboard layout updated for more efficient data retrieval

·dev.to

Dose Buddy: a Medicine Reminder That Reads Prescriptions Locally with Gemma

This is a submission for the Hacktoberfest Weekend Challenge: Build for a Friend What I Built Dose Buddy is a privacy-first medicine reminder that turns a doctor's instructions into a ready-to-use…

  • Dose Buddy is a medicine reminder app using local AI to read prescriptions.
  • Users input prescriptions as text or upload photos; AI interprets instructions.
  • App sets reminders on laptop and phone, exportable as .ics file with offline alerts.

·dev.to

More from Sunday 4 October →