[sqlite] public archive

When I find something interesting on this ML that I'd like to share with a colleague it's often convenient to link to an online archive instead of just forwarding a (possibly incomplete) snapshot of the thread. It seems the "official" archive is not public?

Re: [sqlite] Best way to "split" a large DB into two DBs

On Wed, Sep 7, 2016 at 10:08 AM, Dan Kennedy wrote: > > [...] then attach it and your main db to the same handle so that you can > use an "INSERT INTO ... SELECT ..." statement Can you elaborate or provide any reference materials for this "attach it and your main db to

Re: [sqlite] SELECT the "middle" of a large ordered table

execute faster!? Maybe I'll have more questions after I test it out. Thanks! 1. https://www.sqlite.org/fileformat2.html#section_2_6_6 On Fri, May 27, 2016 at 1:23 PM, Simon Slavin <slav...@bigfraud.org> wrote: > > On 27 May 2016, at 9:02pm, Clay Gerrard <clay.gerr...@g

[sqlite] SELECT the "middle" of a large ordered table

The OpenStack Object Storage system uses sqlite3 databases as the "metadata" storage layer for it's "containers" and "accounts" - similar in a function to AWS S3 "buckets". Each "object" in the system is recorded by a row in it's "container". Given a the API URI for an object: