4 ms·

> Better option is to just add a new column with the correct definition After that you won't be able to change column to NOT NULL. You would need migration to

by stanac 2mo ago

> Better option is to just add a new column with the correct definition After that you won't be able to change column to NOT NULL. You would need migration to create new table with not null column, copy everything, drop old table and rename the new one. Edit: unless the table is empty.

grebc 2mo ago
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.
- stanac 2mo ago
  You create a nullable column and then change it to not null. Which wasn't possible in SQLite until recently.
  - grebc 2mo ago
    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.
    - stanac 2mo ago
      Ah, my bad, first I was wrong about null/not null, and now I see what you mean.
yomismoaqui 2mo ago
Wrong, you can change NOT NULL since 3.53: https://sqlite.org/releaselog/3_53_3.html https://sqlite.org/releaselog/3_53_3.html
- stanac 2mo ago
  Released a month ago, thanks, didn't know.