Re: [sqlite] Status of LSM1 extension

2020-03-05 Thread Dan Kennedy
On 5/3/63 16:11, Dominique Devienne wrote: Hi, I'm interested in LSM1 [1] as an alternative to SQLite, since in a particular use-case, I'm using SQLite mostly as a key-value store, and write performance is particularly important, in addition to MVCC. Sounds like it could be an excellent fit

Re: [sqlite] Status of LSM1 extension

2020-03-05 Thread Dominique Devienne
On Thu, Mar 5, 2020 at 12:35 PM Dan Kennedy wrote: > On 5/3/63 16:11, Dominique Devienne wrote: > > I'm interested in LSM1 [1] as an alternative to SQLite [...] > > [...], I don't think it's too bad of an implementation. The > automated tests are reasonably good - although of course not as good

[sqlite] Status of LSM1 extension

2020-03-05 Thread Dominique Devienne
Hi, I'm interested in LSM1 [1] as an alternative to SQLite, since in a particular use-case, I'm using SQLite mostly as a key-value store, and write performance is particularly important, in addition to MVCC. Sounds like it could be an excellent fit here, and the fact it comes from the SQLite team

Re: [sqlite] Status of LSM1 extension

2020-03-05 Thread Charles Leifer
Keith, if you could share a bit more details on how you do that, I'd be interested. On Thu, Mar 5, 2020 at 8:43 AM Keith Medcalf wrote: > > On Thursday, 5 March, 2020 05:51, Dominique Devienne > wrote: > > >PS: I'd still very much appreciate an LSM1 amalgamation > > cd ext/lsm1 > tclsh

Re: [sqlite] Status of LSM1 extension

2020-03-05 Thread Keith Medcalf
On Thursday, 5 March, 2020 20:39, Charles Leifer wrote: >Keith, if you could share a bit more details on how you do that, I'd be >interested. I presume you mean how to create a "built-in" extension, which is available for all connections, just the built-in functions and modules. There is a

Re: [sqlite] Status of LSM1 extension

2020-03-05 Thread Keith Medcalf
On Thursday, 5 March, 2020 05:51, Dominique Devienne wrote: >PS: I'd still very much appreciate an LSM1 amalgamation cd ext/lsm1 tclsh tool/mklsm1c.tcl which will write an lsm1.c amalgamation in the current directory (ext/lsm1) You can append this to the amalgamation and use an EXTRA_INIT