Hi All, Any words on what kind of new feature is going to be in 3.2?
Thanks, Ming ------------------------------------- D. Richard Hipp wrote: Nothing is definite yet, but we are looking into thepossibility of releasing SQLite version 3.2 in a fewweeks. Version 3.2 will include a subtle but importantfile format change that will break forwards compatibility.That is, Version 3.2 will be able to read and write filesgenerated by 3.0 and 3.1. But 3.0 and 3.1 will not beable to read and write files generated by version 3.2.Again, this is not definite yet. But if we chose to gothis route, a beta release of version 3.2 will appearreal soon - probably the first part of March. The changeswill be very minor and will not effect stability of thelibrary - we might skip beta all together and go straightto stable.The file format change is to be used in a new CREATE TABLEADD COLUMN statement.Actually, the incompatibility probably will not be asbad as described above. We will likely rig it so thatfiles generated by version 3.2 will be readable andwritable by version 3.1 and 3.0 as long as you neverdo an ALTER TABLE ADD COLUMN. The first time you dodo an ADD COLUMN, the database will become unreadableby 3.1 and 3.0 until after you VACUUM.So, if you are using SQLite in a product and can wait acouple of weeks before you lock into a particular version,that would be a good idea.
