Re:The Design Of SQLite4
by marcosdumay on Sunday May 25, 2014 @09:37PM
(#7798309)
The usual way to deal with that (and recommended by the SQLite docs) is creating a new table, copying the data, and dropping the old table.
Needless to say that this is VERY error prone, and limited resources make it even more so.
Seeing as ALTER support is currently lacking, what kinds of approaches are commonly taken to work around this issue? I'm particularly interested in hearing about how people manage workaround to this problem for things like upgrading embedded devices. I imagine the scarcity of resources (RAM, CPU) available to most embedded devices would make this a difficult problem to solve on the hardware at hand.