> On Oct 9, 2016, at 8:15 AM, Howard Chu <h...@symas.com> wrote: > > Use SQLightning, it's designed specifically for write once read many > workloads.
"SQLite3 ported to use LMDB instead of its original Btree code” — sounds great, and the performance figures quoted in the readme are impressive. But the source code appears to be a modified version of SQLite’s source, which would make it very difficult to keep in sync with SQLite, and (as Domingo pointed out) the last commit is three years old and seems to be based on SQLite 3.7.17. So far this looks like an exciting proof-of-concept, but not something I’d use in a real project. (By comparison, SQLCipher is also released as a modified copy of SQLite, but they sync with SQLite regularly; the latest version from this April is based on 3.11.0.) It would be best if this were implemented as a separate plugin, but as I’m not familiar with the innards of SQLite, I’ll assume that simply wasn't feasible. (I know SQLite supports VFS plugins, but I think those just operate at the paging layer, below the b-tree.) —Jens _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
