Re:SQLite 3.32
by HelloNurse on Saturday May 23, 2020 @12:50PM
(#23284426)
"Splitting" a table usually means creating two new ones and dropping the old one after migrating its content with a complex migration script followed by thorough testing. Dropping columns is not only abnormal (adding columns is far more common: features tent to be added, not removed, over time) but also a very crude tool.
[ Parent
| on HN ]
Re:SQLite 3.32
by calpaterson on Saturday May 23, 2020 @01:20PM
(#23284692)
Well what I meant was: when you break one table out of another. The kind of thing that comes up when you learn that there's a one-to-many in the domain that you didn't know about when you started.