Re: [sqlite] BedrockDB interview on Floss Weekly

I had never heard of you guys, this looks amazing! How can you only have 222 github stars?! Paxos, so needs at least 3 nodes? How do you use it from an application that normally uses sqlite? Is it a drop-in replacement? I use Node.JS… Interesting that you emulate mysql, given that sqlite tries

Re: [sqlite] optimizing min/max with calculated index?

Y'all please try the lastest trunk version of SQLite for me and let me know if it works better for you. Thanks. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org

Re: [sqlite] optimizing min/max with calculated index?

> On Oct 26, 2017, at 6:11 AM, Richard Hipp wrote: > >> Is this an optimization opportunity for calculated indexes? > > It is. There is a min/max optimization to deal with this situation, > but it currently does not know about indexes on expressions. +1. The project I work

Re: [sqlite] optimizing min/max with calculated index?

On 10/26/17, Wout Mertens wrote: > I have a table with an indexed json field, and I want to know the maximum > value of that field. > > create table events(id integer primary key, json JSON); > create index t on events(json_extract(json, '$.ts)); > > If I do > >

[sqlite] optimizing min/max with calculated index?

I have a table with an indexed json field, and I want to know the maximum value of that field. create table events(id integer primary key, json JSON); create index t on events(json_extract(json, '$.ts)); If I do select max(json_extract(json, '$.ts')) from events; it does a table

Re: [sqlite] C# pragma integrity_check call throwing exception

Simon, > Your text makes it look like you think that that kind of corruption affects > only existing rows. This is not the case. If you continue to write to a > database which shows this problem, you can lose more of the existing rows > and/or the new data you're trying to write. The

Re: [sqlite] BedrockDB interview on Floss Weekly

I'm glad you liked it! I'd be happy to answer any questions you have about http://BedrockDB.com, our use of sqlite, or anything else. Thanks for listening! -david On Wed, Oct 25, 2017 at 4:19 PM, jungle Boogie wrote: > Hi All, > > Pardon the usual interruption of