April 11, 2005
alter table, sort of
The good people over at SQLite and AOL have done it at last... almost. SQLite 3.2.1 now supports basic ALTER TABLE statements. You can now add columns and rename tables, all the while preserving existing data, indexes, and so forth.
There is still some work to be done, namely the ability to change and drop columns, as well as manipulate indexes, but this is a huge step in the right direction.
For those who cannot upgrade, or who need to do more than just add columns, there is still my PHP SQLite class for this purpose. You can use it to add, change, and drop columns, although manipulating indexes still hasn't been implemented. Whether SQLite or I get to that first is anybody's guess... if only I had some free time...Posted by jon at April 11, 2005 5:35 PM