News for hackers. Stuff that matters.
Re:The Design Of SQLite4 by thesz on Monday May 26, 2014 @05:32AM (#7799176)
1) That would be true for any row-oriented DBMS.

2) LSM tree is blazingly fast in inserts (my own experiments shows two orders of magnitude difference for BerkeleyDB and my own LSM tree implementation in C# for bulk random inserts).

So I think SQLite4 is safe here.

Re:The Design Of SQLite4 by zzzeek on Monday May 26, 2014 @10:47AM (#7799906)
Great! So they can add a full blown ALTER. But so far, the only indication we can get is, "never".