Lite implementation?
>
>
> Regards,
> Clemens
> ___
> sqlite-users mailing list
> sqlite-users@mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
--
John Found
_
On Fri, 12 Oct 2018 08:27:10 +0200
Clemens Ladisch wrote:
> John Found wrote:
> > i.e. how to select only the groups that contain
> > some value in the set of values in a column not
> > specified in group by clause.
> >
> > select
> > (select gr
not
specified in group by clause.
The only way I was able to do it is by subquery.
Something like this:
select
(select group_concat(b) from t t1 where t1.a = t2.a) as list
from t t2
where b = ?1;
--
John Found
___
sqlite-users mailing list
arly, if you need the result columns to have certain names, you must
> provide these via AS clauses.
>
> -Ursprüngliche Nachricht-
> Von: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] Im
> Auftrag von John Found
> Gesendet: Sonntag, 16. September 2018 10:30
On Sun, 16 Sep 2018 10:59:31 -0400
Richard Hipp wrote:
> On 9/16/18, John Found wrote:
> >
> > Is it means that in every query that uses GROUP BY and ORDER BY
> > simultaneously, one of the operations will always be provided by using
> > temporary b-tree?
> >
&g
y to group by and order by simultaneously
without using temp b-tree?
On Sun, 16 Sep 2018 10:59:31 -0400
Richard Hipp wrote:
> On 9/16/18, John Found wrote:
> >
> > Is it means that in every query that uses GROUP BY and ORDER BY
> > simultaneously, one of the operations w
On Sun, 16 Sep 2018 13:30:55 +0100
Simon Slavin wrote:
> On 16 Sep 2018, at 9:29am, John Found wrote:
>
> > Is there some relation between the indexes used in the query, the GROUP BY
> > fields used
> > and the order of the result rows, when no "ORDER BY"
adeoff of library size & cycles to optimise vs execution cycles
> saved to consider).
>
> > On 16 Sep 2018, at 6:29 pm, John Found wrote:
> >
> > Is there some relation between the indexes used in the query, the GROUP BY
> > fields used
> > and the orde
o2
NULL 5 300
f,g 3 200
c,d,e 2 50
a,b1 100
--
John Found
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
On Wed, 5 Sep 2018 10:42:04 +0200
"E.Pasma" wrote:
> John Found wrote:
> > In order to write an autoupdater, I need to download the latest SQLite
> > amalgamation.
> > Is there a permanent link to the subject, or the only way is to parse the
> > d
In order to write an autoupdater, I need to download the latest SQLite
amalgamation.
Is there a permanent link to the subject, or the only way is to parse the
download page
for links to "sqlite-amalgamation-*.zip" or to build it from the fossil
checkout?
--
uirement for stack alignment on 16 bytes,
regardles of that it was compiled to 32bit code. On the other hand, my code
aligns the stack on 4 bytes as an usual 32bit program.
The option -mpreferred-stack-boundary=2 fixed the issue.
--
John Found
_
supports almost
all extensions), gcc version is 8.2.0;
BTW, compiling with -O1 sometimes produces working result (but pretty slow)
which only entagles the puzzle.
--
John Found
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://ma
this (my gcc and generally
C/C++ skills are pretty low) or I somehow messed the options elsewhere. Then
what to check?
--
John Found
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo
" COLLATE NOCASE ASC);
> > CREATE UNIQUE INDEX "Disruptions_Idx2" ON Disruptions ("Disruption_id"
> > COLLATE NOCASE ASC, "version" COLLATE NOCASE ASC, "category" COLLATE
> > NOCASE ASC, "subCategory" COLLATE NOCASE ASC);
>
On Sat, 10 Mar 2018 01:17:38 +
Simon Slavin <slav...@bigfraud.org> wrote:
> On 9 Mar 2018, at 7:49pm, John Found <johnfo...@asm32.info> wrote:
>
> > In the current implementation "insert or replace" behave as the foreign
> > constraint is deferred.
On Fri, 9 Mar 2018 19:42:19 +
Simon Slavin <slav...@bigfraud.org> wrote:
> On 9 Mar 2018, at 7:11pm, John Found <johnfo...@asm32.info> wrote:
>
> > "insert or replace" succeed without deleting the old rows from B.
>
> "replace" mea
al. At least this was my
expectation when writing the code.
--
http://fresh.flatassembler.net
http://asm32.info
John Found <johnfo...@asm32.info>
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
t;USE TEMP B-TREE FOR ORDER BY".
Order by any field
other than "rank" and "rowid" makes this query very slow.
> On Thu, Feb 8, 2018, 7:14 PM John Found, <johnfo...@asm32.info> wrote:
>
> >
> > I am using FTS5 for pretty complex search in my applica
ain question follows:
What is the right way to design such complex search systems, based on FTS? How
to properly approach the sorting of the search results in order to not have so
big slowdowns and out of memory errors.
Any tips are highly welcome!
Regards
--
http://fresh.flatassembler.net
http:
ease update your records to use william.dr...@l3t.com.
> ___
> sqlite-users mailing list
> sqlite-users@mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
--
http://fresh.flatassembler.net
xed query or need specially
synthesized query for every particular case.
>
> -Ursprüngliche Nachricht-
> Von: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] Im
> Auftrag von John Found
> Gesendet: Montag, 05. Februar 2018 15:55
> An: sqlite-users@mai
to be good).
But what are the disadvantages of such approach? (except the bigger database
size, of course)
On Mon, 5 Feb 2018 09:24:51 -0500
Richard Hipp <d...@sqlite.org> wrote:
> On 2/5/18, John Found <johnfo...@asm32.info> wrote:
> > The following query:
> >
idxPostsThreadUser on Posts(threadid, userid);
IMHO, the change of the selected columns should not affect the query plan, but
maybe I am wrong somehow.
What I am missing?
--
http://fresh.flatassembler.net
http://asm32.info
John Found <johnfo...@asm32.i
mailing list
> sqlite-users@mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
--
http://fresh.flatassembler.net
http://asm32.info
John Found <johnfo...@asm32.info>
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
ot;source
clearness" actually is hard for detection hidden bug that can strike after long
time on the database schema change.
>
> Thanks.
>
> --
> Cecil Westerhof
> ___
> sqlite-users mailing list
> sqlite-user
unt() from PostFTS where PostFTS match ?1 ThreadID:?2;
--
http://fresh.flatassembler.net
http://asm32.info
John Found <johnfo...@asm32.info>
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
? Or such behavior is normal and expected.
--
http://fresh.flatassembler.net
http://asm32.info
John Found <johnfo...@asm32.info>
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/
On Tue, 2 May 2017 09:38:30 +0200
Olivier Mascia <o...@integral.be> wrote:
> > Le 2 mai 2017 à 09:00, John Found <johnfo...@asm32.info> a écrit :
> >
> > What is the best way (less CPU consuming) to put a thread in sleep and wake
> > it up when new reco
want both. :)
--
http://fresh.flatassembler.net
http://asm32.info
John Found <johnfo...@asm32.info>
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
n. If so, would periodic WAL checkpoints help?
>
> —Jens
> ___
> sqlite-users mailing list
> sqlite-users@mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
--
http:/
users mailing list
> sqlite-users@mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
--
http://fresh.flatassembler.net
http://asm32.info
John Found <johnfo...@asm32.info>
___
sqlite-users mailing list
sqlite-users@mai
On Tue, 26 Jul 2016 21:52:26 +0100
Simon Slavin <slav...@bigfraud.org> wrote:
>
> On 26 Jul 2016, at 9:29pm, John Found <johnfo...@asm32.info> wrote:
>
> > Is it possible to use SQLite, making queries directly in the internal
> > virtual machine language, inste
On Tue, 26 Jul 2016 16:40:07 -0400
Richard Hipp <d...@sqlite.org> wrote:
> On 7/26/16, John Found <johnfo...@asm32.info> wrote:
> > Is it possible to use SQLite, making queries directly in the internal
> > virtual machine language, instead of SQL?
>
> No. Why
://fresh.flatassembler.net
http://asm32.info
John Found <johnfo...@asm32.info>
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
"not reliable". Isn't it?
--
http://fresh.flatassembler.net
http://asm32.info
John Found <johnfo...@asm32.info>
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
hat is why I am using netbook class PCs and 5..10 years old desktop machines
for testing my applications.
--
http://fresh.flatassembler.net
http://asm32.info
John Found <johnfo...@asm32.info>
___
sqlite-users mailing list
sqlite-users@mailingli
On Thu, 14 Apr 2016 13:57:20 -0400
Richard Hipp wrote:
> On 4/14/16, Richard Hipp wrote:
> > On 4/14/16, John Found wrote:
> >> But after some time working in wild (executing the more complex original
> >> query), the performance decreased again and despite
On Thu, 14 Apr 2016 09:19:06 -0400
Richard Hipp wrote:
> On 4/14/16, John Found wrote:
> >
> > But after some time working in wild (executing the more complex original
> > query), the performance decreased again and despite of existing the index,
> > the result
On Thu, 14 Apr 2016 13:44:45 +0200
R Smith wrote:
>
>
> On 2016/04/14 10:46 AM, John Found wrote:
> > Playing with optimization of my queries, I stuck on very strange (for me)
> > behaviour of
> > sqlite.
> >
> > The query is pretty compl
at can be the reason for such strange behaviour?
--
http://fresh.flatassembler.net
http://asm32.info
John Found
changing the whole SQL query.
P.S. BTW another issue that I can't solve with fts5 is returning posts that
does not contain some word.
"NOT keyword" does not work at all, neither "* NOT keyword";
--
http://fresh.flatassembler.net
http://asm32.info
John Found
On Wed, 13 Apr 2016 23:38:04 +0700
Dan Kennedy wrote:
> On 04/13/2016 11:24 PM, John Found wrote:
> > What FTS5 query should I use in order to match all rows in the table?
> >
>
> Can you use "SELECT * FROM fts_table;"?
>
*I* can. But the users of the progr
On Sat, 26 Mar 2016 16:08:33 +0100
Eduardo Morras wrote:
> On Sat, 26 Mar 2016 16:37:18 +0200
> John Found wrote:
>
> > Why cannot drop the table test?
> >
> > sqlite> begin transaction;
> > sqlite> create virtual table test using fts5;
> > Erro
tent test_docsize
test_config test_data test_idx
$sqlite3 --version
3.11.1 2016-03-03 16:17:53 f047920ce16971e573bc6ec9a48b118c9de2b3a7
--
http://fresh.flatassembler.net
http://asm32.info
John Found
45 matches
Mail list logo