[sqlite] Searching this mailing lsit

RMtrix writes: > > Mail-Archive.com returns no hits for 2013 and 2014 even when the search term is "SQLite". None until > sometime in 2015. So the archive is incomplete or its index is corrupted. > > On the other site, your search has results only in 2013 and 2016. With Mail-Archive.com

[sqlite] Searching this mailing lsit

> Mail-Archive.com returns no hits for 2013 and 2014 even when the search term > is "SQLite". None until sometime in 2015. So the archive is incomplete or its > index is corrupted. > > On the other site, your search has results only in 2013 and 2016. With > Mail-Archive.com having no data for

[sqlite] COLLATE NU800_NOCASE as a loadable extension?

Aleksey Tulinov writes: . > > Unfortunately i'm not familiar with SQLite Expert, however > > >2.6 Message : no such collation sequence:_RMNOCASE > > Collation provided by nunicode SQLite extension is called NU800_NOCASE > (or NU800 for case-sensitive collation), that

Re: [sqlite] WHERE expression with operators from text functions?

and execute it. Tom > On Oct 16, 2014, at 12:55 PM, Tom Holden <ve3...@gmail.com> wrote: > > I think you are right. The FTS MATCH looks like it should function the way > I want. > > Thanks, Richard! I will now learn how to use FTS... > > Tom > >> On Thu, Oc

Re: [sqlite] WHERE expression with operators from text functions?

I think you are right. The FTS MATCH looks like it should function the way I want. Thanks, Richard! I will now learn how to use FTS... Tom On Thu, Oct 16, 2014 at 12:20 PM, Richard Hipp <d...@sqlite.org> wrote: > On Thu, Oct 16, 2014 at 12:03 PM, Tom Holden <ve3...@gmai

[sqlite] WHERE expression with operators from text functions?

Coming up with a subject was a struggle and maybe that indicates an impossibility. Searching the archive was equally fruitless. What I am trying to do is to build a SELECT with a compound WHERE using one or more run-time parameters. Sort of like transforming an input phrase such as:

Re: [sqlite] False Error 'no such collation sequence'

> Date: Fri, 21 Jun 2013 21:23:20 +0300 > From: Bogdan Ureche > To: General Discussion of SQLite Database > Subject: Re: [sqlite] False Error 'no such collation sequence' > > You are mistaken. The free version of SQLite Expert supports loadable >

Re: [sqlite] False Error 'no such collation sequence'

Richard Hipp drh at sqlite.org Fri Jun 21 00:15:56 EDT 2013 wrote: Can you not compile your custom collation sequences into a loadable extension (a DLL or shared library), then load that extension into your SQLite shell? http://www.sqlite.org/loadext.html - Tom replies: With Ralf's

Re: [sqlite] False Error 'no such collation sequence'

Ralf Junker ralfjunker at gmx.de Thu Jun 20 18:44:15 EDT 2013 wrote: On 19.06.2013 17:18, Tom Holden wrote: I use the SQLiteSpy compilation of SQLite3 which recently upgraded from pre SQLite 3.7.8 to pre 4.2.0. You must be mistaken. As the author of SQLiteSpy, I can clearly say

Re: [sqlite] False Error 'no such collation sequence'

(my apology for trying to reply to a message in the archive which has no reply-to feature – I hope it ends up in the right thread) Richard, I think I know why your test of the command line shell returned no error – an index is needed on the field with the missing collation. I am guessing what

[sqlite] False Error 'no such collation sequence'

I use the SQLiteSpy compilation of SQLite3 which recently upgraded from pre SQLite 3.7.8 to pre 4.2.0. I also occasionally use the SQLite3 Windows command-line shell. I am now encountering an error with the current versions that I did not with earlier ones – sorry, I cannot be precise at this

Re: [sqlite] Query with UNION on large table

Is the Hard Drive thrashing? Could be that most everything is being done in swap files. Given the size of the table, a lot more RAM would help. Tom ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] Query with UNION on large table

This is even faster, on a tiny table: SELECT n1, n2 FROM table1 INTERSECT SELECT n2, n1 FROM table1 WHERE n2

Re: [sqlite] Automating the build of a sqlite database

Perhaps by adding .quit to your schema.sql Tom -Original Message- From: Maurice Marinus Sent: Friday, April 22, 2011 11:18 AM To: sqlite-users@sqlite.org Subject: [sqlite] Automating the build of a sqlite database So how would I get the batch file to run and terminate the sqlite

Re: [sqlite] Request for help with SQLite Query to return missingDate/Time Ranges

Could you not do this: Select A.time + 1 minute, B.time - 1 minute from log as A, log as B where A.RowID=B.RowID+1 and B.time-A.time > 1 minute Tom -Original Message- From: Andrew Lindsay Sent: Wednesday, April 20, 2011 7:34 PM To: sqlite-users@sqlite.org Subject: [sqlite] Request for

Re: [sqlite] Case-sensitivity, performance and LIKE

- Original Message - From: "Jay A. Kreibich" <j...@kreibi.ch> To: "General Discussion of SQLite Database" <sqlite-users@sqlite.org> Sent: Tuesday, March 30, 2010 9:26 PM Subject: Re: [sqlite] Case-sensitivity, performance and LIKE > On Tue, Mar 30, 2

Re: [sqlite] Case-sensitivity, performance and LIKE

- Original Message - From: "Simon Slavin" To: "General Discussion of SQLite Database" Sent: Tuesday, March 30, 2010 8:12 PM Subject: Re: [sqlite] Case-sensitivity, performance and LIKE > > On 31 Mar 2010, at 12:51am, Rashed Iqbal wrote:

Re: [sqlite] Passing Value from one query to another

Store the results of the first query in a temporary table? - Original Message - From: "personalt" To: Sent: Saturday, February 06, 2010 8:54 AM Subject: Re: [sqlite] Passing Value from one query to another > > I realize this works fine for

Re: [sqlite] SQL Crash with sqlite 3.6.22 commandline

The point is not how the table was created but rather that the absence of the RMNOCASE collation causes the query to crash the latest versions of sqlite while earlier versions gracefully report an error. Moreover, having saved a VIEW from this query resulted in these managers of later releases

[sqlite] Speed regression after 3.6.17

I have been trying out a number of SQLite managers, one test being the execution time for the same query on the same database on the same computer. The scattering of results was very surprising with a spread on the order of 10:1. I followed up with one of the developers and he was able to