SQLite Forum

SQLite Version 3.35.0 - Beta 1
Login
Hi Dan,

MVCC is implemented on the documents, each key or iterator is checked for MVCC visibility during a scan/enumeration.  A temporary Document can also be created from an index key entry (not implemented yet.)  Each document version has a vector of the keys created for that version. This vector Each index entry has an arbitrary user created schema that is provided along with the index key.

The API is currently designed to support MongoDB embedded in a javascript interpreter.  I don't think it is too much of a stretch to support a SQL92 program.

So, to answer you directly, MVCC is either directly supported, or not,  as designated by the table attributes.

The MVCC implementation of the B-Tree can also be implemented by a narrow table that ties all of the entries for an index together with a document/version ID. An API layer would provide support needed for SQL, similar/borrowing from the github/malbrain/JAVASCRIPT-DATABASE interface.

Karl