3 ms·
Not disagreeing with your overall point about SQLite's feature set, but IIRC, `ALTER TABLE RENAME` was added in 2018, for version 3.25.0: https://www.sqlite.org
by danso 7y ago
Not disagreeing with your overall point about SQLite's feature set, but IIRC, `ALTER TABLE RENAME` was added in 2018, for version 3.25.0: https://www.sqlite.org/releaselog/3_25_0.html https://www.sqlite.org/releaselog/3_25_0.html
(I chime in only to remark that I myself am constantly surprised that SQLite continues to add these kinds of features – e.g. WINDOW functions were also in 3.25 – long after I had accepted their absence as a fact of life)
- cjfd 7y agoAh, that is interesting. My experiences were before 2018 and I had not kept an eye on it, so I did not know this.
- cjfd 7y agoOw, but looking at the docs they still do not seem to support delete yet.
- dana321 7y agoYeah, its a pity it doesn't have the ability to do anything more than alter table statements that add to a schema, having to rename the table, create a new schema and copy its contents from the old table can be quite a tricky and troublesome thing to do if you've got a live system running with users on it.