mORMot Open Source

pult

Member

From: Ukraine, Kyiv

Registered: 2013-11-06

Posts: 18

what is sqlite4

what is sqlite4
http://sqlite.org/src4/doc/trunk/www/design.wiki

esmondb

Member

From: London

Registered: 2010-07-20

Posts: 299

Re: what is sqlite4

It doesn't seem that active looking at the timeline:
http://sqlite.org/src4/timeline
But the Decimal Math feature looks interesting

edwinsn

Member

Registered: 2010-07-02

Posts: 1,215

Re: what is sqlite4

IIRC, it's announced few years ago, I don't think it's under active development tough.

To me, with the recent JSON support added to sqlite3, it's almost perfect in my use cases so far

---

Delphi XE4 Pro on Windows 7 64bit.
Lazarus trunk built with fpcupdelux on Windows with cross-compile for Linux 64bit.

ab

Administrator

From: France

Registered: 2010-06-21

Posts: 14,269

Website

Re: what is sqlite4

One of the ideas of SQLite4 is to implement a storage using LSM, which is faster than SQlite3 BTrees.
Mainly a Proof of Concept by now (who is using it on production?), but a very interesting one!

It is funny to see that MongoDB 3, and its new WiredTiger storage engine, uses LSM or BTree, on choice.
See https://github.com/wiredtiger/wiredtige … ree-vs-LSM