On 10/26/19 8:07 PM, Thomas Kurz wrote: >> Feel free to make suggestions. Which missing feature or features causes > you the most bother? > > Thanks, Dan. > > To me, the most puzzling thing is the lack of full ALTER TABLE support (DROP > COLUMN, MODIFY COLUMN, ADD CONSTRAINT, DROP CONSTRAINT). Modifying tables is > some kind of science in SQLite, and thus, very error-prone. I'd be willing to > donate for that but as a private user I cannot affort 85 k$ ;-) > My one thought about fuller ALTER TABLE support would be that since SQLite stores the schema as the simple CREATE TABLE command, that ALTER TABLE needs to know how to edit that string to match the changes, where simple adds are much easier than other forms of editing.
Also, due to the way SQLite handles rows, adding columns will automatically assume default values for all existing rows. Anything much more complicated could easily require that SQLite update the whole table row by row, and that likely would require making sure that nothing else was looking at the database, as it might not be possible to keep the view consistent. -- Richard Damon _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
