How to do a migration properly without downtime? Avoid a transaction on all rows.

Method:

1. add new column as nullable
2. new writes use the new column and read from the old-and new columns
3. Deploy
4. Fix the old data in a batch. Pause briefly between each batch and run another one once the database load is correct.

Lineage has a flash tool directly integrated in the browser viw WebUSB. Wow

In fact, yes for many reasons.

My hope is that as web standards improve, build tools can become slimmer and simpler, because abandoning them altogether is not a good option on larger projects.

For small apps, it doesn't matter.