Re: [sqlite] LSM1 extension

On 8/9/17, Jens Alfke wrote: > > One thing I’m unclear on: Will the LSM1 extension in SQLite3 be able to plug > in at a low level (replacing the b-tree engine), so one can use it with all > the existing features like relational tables and SQL queries; or will it > provide only

Re: [sqlite] LSM1 extension

> On Aug 9, 2017, at 8:23 AM, Nico Williams wrote: > > I must say though, SQLite4 is *brilliant*. I do hope that it either > gets completed and replaces SQLite3, or has all its good ideas folded > into SQLite3. The LSM1 work in SQLite3 seems to point towords the >

Re: [sqlite] LSM1 extension

On Wed, Aug 09, 2017 at 08:26:51AM -0500, Charles Leifer wrote: > sqlite4's future is uncertain. It's not, as I understand, meant to replace > sqlite3 any time soon. I think it was more of a place to try out new ideas > for implementations. I must say though, SQLite4 is *brilliant*. I do hope

Re: [sqlite] LSM1 extension

> > From: Charles Leifer<mailto:colei...@gmail.com> > Sent: 08 August 2017 21:21 > To: SQLite mailing list<mailto:sqlite-users@mailinglists.sqlite.org> > Subject: Re: [sqlite] LSM1 extension > > There's some information that may be of interest on the sqlite4 wiki: > >

Re: [sqlite] LSM1 extension

Thanks Charles. Is sqlite4 available yet? From: Charles Leifer<mailto:colei...@gmail.com> Sent: 08 August 2017 21:21 To: SQLite mailing list<mailto:sqlite-users@mailinglists.sqlite.org> Subject: Re: [sqlite] LSM1 extension There's some information that may be of interest on the

Re: [sqlite] LSM1 extension

-users@mailinglists.sqlite.org> > Subject: Re: [sqlite] LSM1 extension > > On 8/8/17, x <tam118...@hotmail.com> wrote: > > I keep reading about this LSM1 but can’t find anything about it beyond > > tickets. Any links? > > Baseline technology: https://en.wikipedia.org/wiki

Re: [sqlite] LSM1 extension

Thanks Richard. From: Richard Hipp<mailto:d...@sqlite.org> Sent: 08 August 2017 18:47 To: SQLite mailing list<mailto:sqlite-users@mailinglists.sqlite.org> Subject: Re: [sqlite] LSM1 extension On 8/8/17, x <tam118...@hotmail.com> wrote: > I keep reading about this LSM1 bu

Re: [sqlite] LSM1 extension

On 8/8/17, x wrote: > I keep reading about this LSM1 but can’t find anything about it beyond > tickets. Any links? Baseline technology: https://en.wikipedia.org/wiki/Log-structured_merge-tree No documentation yet on the LSM1 implementation in SQLite. -- D. Richard Hipp

Re: [sqlite] LSM1 extension

I keep reading about this LSM1 but can’t find anything about it beyond tickets. Any links? From: Jens Alfke<mailto:j...@mooseyard.com> Sent: 08 August 2017 18:04 To: SQLite mailing list<mailto:sqlite-users@mailinglists.sqlite.org> Subject: Re: [sqlite] LSM1 extension > On Aug 4

Re: [sqlite] LSM1 extension

> On Aug 4, 2017, at 9:12 PM, Charles Leifer wrote: > > Right -- my question is still unanswered as to why the code was merged in. It’s not uncommon in software engineering to put unfinished long-running feature work on the main development branch but disable it with a

Re: [sqlite] LSM1 extension

On 8/5/17, Charles Leifer wrote: > Right -- my question is still unanswered as to why the code was merged in. The code was merged due to bad planning. We thought LSM1 would be ready in time for 3.20.0, but we underestimated the amount of work involved in getting it there,

Re: [sqlite] LSM1 extension

Right -- my question is still unanswered as to why the code was merged in. I have tremendous respect for this project and everyone involved in it, so please understand I'm not trying to call into question your decisions -- I'd just like clarification as to why this was included now? On Fri, Aug

Re: [sqlite] LSM1 extension

On 8/4/17, Charles Leifer wrote: > > My excitement quickly turned to disappointment as I realized that the > extension is unusable for all practical purposes: > Yes, it needs work. That is why it is unannounced. -- D. Richard Hipp d...@sqlite.org

[sqlite] LSM1 extension

Hi, I was pleased to see that 3.20 contained the source for the LSM1 virtual table, even if not included in the official announcements. My excitement quickly turned to disappointment as I realized that the extension is unusable for all practical purposes: - Single-key equality lookups are

Re: [sqlite] lsm1 extension

Thanks for the clarification! On Tue, Jun 20, 2017 at 2:41 AM Dan Kennedy wrote: > On 06/20/2017 12:42 PM, Charles Leifer wrote: > > Hi, > > > > I'm not quite sure of the proper way to compile the lsm1 extension (in > the > > lsm-vtab branch). I ended up hand-hacking the

Re: [sqlite] lsm1 extension

On 06/20/2017 12:42 PM, Charles Leifer wrote: Hi, I'm not quite sure of the proper way to compile the lsm1 extension (in the lsm-vtab branch). I ended up hand-hacking the makefile to replace $(TCCX) and add the appropriate flags for gcc (-fPIC) to get it to build. I'd like to do it the "right

[sqlite] lsm1 extension

Hi, I'm not quite sure of the proper way to compile the lsm1 extension (in the lsm-vtab branch). I ended up hand-hacking the makefile to replace $(TCCX) and add the appropriate flags for gcc (-fPIC) to get it to build. I'd like to do it the "right way", though, as I was hoping to share some