News for hackers. Stuff that matters.
Re:SQLite in Production: Optimizing WAL Mode, Concurrency, a... by grebc on Wednesday July 29, 2026 @06:22AM (#49095534)
How do you migrate in place data that doesn’t convert between types while maintaining a strict condition like NOT NULL?

This is again a scenario I’ve never run into 20ish years of SQL.

Re:SQLite in Production: Optimizing WAL Mode, Concurrency, a... by stanac on Wednesday July 29, 2026 @06:57AM (#49095800)
You create a nullable column and then change it to not null. Which wasn't possible in SQLite until recently.
Re:SQLite in Production: Optimizing WAL Mode, Concurrency, a... by grebc on Wednesday July 29, 2026 @07:38AM (#49096130)
I’m not sure what your original point is pointing out.

Some data doesn’t convert is what I’m pointing out regardless of Postgres or SQLite.

Re:SQLite in Production: Optimizing WAL Mode, Concurrency, a... by stanac on Thursday July 30, 2026 @05:09AM (#49107582)
Ah, my bad, first I was wrong about null/not null, and now I see what you mean.