On 10 Jul 2018, at 21:17, Dan Kennedy wrote:
>>
>
> Try running the FTS5 integrity-check command with the 3.24.0 command line to
> ensure it really is corrupt:
>
> https://www.sqlite.org/fts5.html#the_integrity_check_command
>
> The index can be rebuilt using the rebuild command:
>
>
On 07/11/2018 02:56 AM, Nick wrote:
Using sqlite cli version 3.13 I have a simple schema with a virtual FTS5 table
providing full index searching. It is accessed by a python application using
apsw==3.13.0.post1.
I could successfully use the full index functionality during manual testing of
Using sqlite cli version 3.13 I have a simple schema with a virtual FTS5 table
providing full index searching. It is accessed by a python application using
apsw==3.13.0.post1.
I could successfully use the full index functionality during manual testing of
the db at creation time (probably a
On 2018/07/10 8:27 PM, Randall Smith wrote:
One follow-up: Do you know if the dump output is "deterministic" over
time? That is, if I diff two dumps taken at different times, will the
unchanged material be in the same order and so on? Or is the ordering
effectively random?
My underlying
From: Simon Slavin
> I'm curious if there is some standard or normal way to convert a SQLite DB to
> a text representation, and then recreate the DB content from the text.
> Naively, this seems hard or impossible as a general problem, but perhaps I am
> missing something.
Yep. It's
cast(abs(random()) / 9223372036854775807.0 * 7 as integer)
Will fix that. You throw away one bit of randomness (by the abs()), convert to
a floating point value in the range of 0 but less than 1 (throwing away a few
more bits in the conversion (since the precision of a double mantissa is only
Rob Willett wrote:
> I removed two instances of -O2 from the Makefile and, lo and behold, it
> compiles.
>
> Sadly my database to check is approx 80GB which could be interesting.
The bottleneck is I/O speed; it does not matter whether sqlite3_analyzer uses
ten
or twenty microseconds before
> It works without -O2, do you have optimisations left on?
-fPIC -O2 -Wall -Wextra -pedantic
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
David,
Thanks for the reply.
We have the latest build-essential
root@preprod1:/jambuster/src/sqlite-src-324/tool# apt-get install
build-essential
Reading package lists... Done
Building dependency tree
Reading state information... Done
build-essential is already the newest version
Dan,
Many thanks for this. I removed two instances of -O2 from the Makefile
and, lo and behold, it compiles.
Sadly my database to check is approx 80GB which could be interesting.
However I'll take a working (but slower) program over a faster (but not
working) application every time :)
Rob
10 matches
Mail list logo