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 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 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

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

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

[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