[sqlite] Index Selection

Igor Tandetnik writes: > On 3/26/2016 6:12 PM, Denis Burke wrote: >> CREATE INDEX [IndxT1C3] >> ON [T1]( >> [C3] COLLATE [NOCASE]); >> -- >> after doing this: >> explain query plan >> select C1 from T1 >> where C3='2016-01-02' > > You are requesting a case sensitive comparison; a cas

[sqlite] Searching a table of patterns

On 3/27/16, David Rayna wrote: > One thing I have occasionally desired is be able to search a table of > patterns given a string that might match some rows. > This is the reverse of searching a table of strings to find ones that > match a pattern. CREATE TABLE t1(a INT, pattern TEXT); INSERT INTO

[sqlite] Using a "personal" partial index

On 3/27/16, David Rayna wrote: > I got excited when I saw the "indexed by" clause. > A technique I used years ago with FoxPro & etc was to allow each user to > create his own personal index of the same data. That's not what INDEX BY does. An you cannot really give each user their own private ind

[sqlite] Searching a table of patterns

One thing I have occasionally desired is be able to search a table of patterns given a string that might match some rows. This is the reverse of searching a table of strings to find ones that match a pattern. I was wondering if anyone else has come across this and if a small change to sqlite mig

[sqlite] Using a "personal" partial index

I got excited when I saw the "indexed by" clause. A technique I used years ago with FoxPro & etc was to allow each user to create his own personal index of the same data. FoxPro allowed storing index files separately and on each user's own local C: drive. The index was on a complex computed "qual

[sqlite] Database layout in memory

Sorry for the late reply? So from the connection object you can find the PCache? Do you have any hints as to how I could find the db connection object in memory? Is there some typical pattern that I could find? Best, Ren? > On 28 Feb 2016, at 17:09, Keith Medcalf wrote: > > You would have to

[sqlite] Database layout in memory

You have a pointer to the db connection when you open the database. The definition of the structure is in sqliteInt.h it contains a pointer to the Db struct. which contains pointers to other structures used to magange the Btree and the Pager and the PCache. > -Original Message- > From:

[sqlite] sqlite fixed data loading extension

Well, like I mentioned, I do have the basic functionality that I want in an existing C# application. Unfortunately it works in the opposite direction that I was hoping...meaning it implements Sqlite and not Sqlite implementing it. The functionality would be more generally usable if Sqlite could imp