SQLite Forum

Adding columns to sqlar dbs

Adding columns to sqlar dbs

(1) By anonymous on 2020-11-13 09:44:47 [link] [source]

Will it be future safe if I create sqlar dbs using the standard CLI and then add columns for example for the windows file creation date, last access date and perhaps a description etc.?

Or should it rather be done another way?

It appears to currently work without problem.


(2) By Richard Hipp (drh) on 2020-11-13 13:11:32 in reply to 1 [source]

I'm not going to make any guarantees that adding columns to an sqlar table will be 100% future safe forever and ever. But, it is likely to be safe as far as I know at this time. There are no current plans to do anything to break it, and I can't off the top of my head think of any reason why this should break in the future.