On 4 Mar 2015, at 9:07pm, Scott Hess wrote:
> In the time I've been involved with high-volume SQLite clients (Google
> Gears, then Chrome), what I've found is that the corruption invariably
> (*) ends up being a case where distinct pages were not written
> atomically, but where each page in isol
Hello Joe,
ok i'll tried:
gcc -s -O4 -I /path/to/sqlite/headers/ -shared -o spellfix.dll spellfix.c
and got this error:
c:\MinGW\bin>gcc -s -O4 -I c:\Sqlite\src\ -shared -o spellfix.dll
c:\Sqlite\ext
\misc\spellfix.c
In file included from c:\Sqlite\ext\misc\spellfix.c:17:0:
c:\Sqlite\src/sqlit
System.Data.SQLite version 1.0.96.0 (with SQLite 3.8.8.3) is now available
on the System.Data.SQLite website:
https://system.data.sqlite.org/
Further information about this release can be seen at
https://system.data.sqlite.org/index.html/doc/trunk/www/news.wiki
Please post on the SQL
Ok, that's what I finally convinced myself, too. Thanks for the confirmation.
- Andy
On Wed, Mar 4, 2015 at 4:24 PM, Scott Perry wrote:
> Good eye, thanks for reporting this.
>
> Pointers on the stack or in static storage are pointer-aligned by default on
> all of Apple's platforms.
>
> On Ma
In order of preference
a) use FastBit software
b) normalize your database design to eliminate the array
c) use a BLOB of 125 bytes and user defined functions to operate on them
d) use a string of 1000 characters ('0' or '1') and the SUBSTR() function
-Urspr?ngliche Nachricht-
Von: Oskar S
Hello,
what is the best way to implement a Bitfield of size 1000 as a column in a
Table. I need to make queries to select all rows which have the nth bit set?The
bitfield describes for each day in about three years if a specific task needs
to be done.
There is some info here:
http://sqlite.org/threadsafe.html
--
Bill Drago
Senior Engineer
L3 Narda-MITEQ
435 Moreland Road
Hauppauge, NY 11788
631-272-5947 / William.Drago at L-3COM.com
> -Original Message-
> From: sqlite-users-bounces at mailinglists.sqlite.org [mailto:sqlite-
> users-
I'd be interested if you could characterize the corruption. For
example, can use still use .dump to dump the database, and if so
what kind of damage is there?
The cases I've encountered recently, the "corruption" was only
a few duplicated records, which broke the uniqueness constraint
on an in
I'd be interested if you could characterize the corruption. For
example, can use still use .dump to dump the database, and if so
what kind of damage is there?
The cases I've encountered recently, the "corruption" was only
a few duplicated records, which broke the uniqueness constraint
on an in
Good eye, thanks for reporting this.
Pointers on the stack or in static storage are pointer-aligned by default on
all of Apple's platforms.
On Mar 3, 2015, at 7:27 PM, Andy Rahn wrote:
>
> Hi SQLite users;
>
> I have a question about _sqliteZone_ in mem1.c. I notice that the
> address of thi
I have worked with numeric data and also "keyword" data, i.e. a small number of
distinct keywords that appear in a string (or not).
-Urspr?ngliche Nachricht-
Von: Dominique Devienne [mailto:ddevienne at gmail.com]
Gesendet: Mittwoch, 04. M?rz 2015 10:39
An: General Discussion of SQLite Da
On 4 Mar 2015, at 1:45pm, Hick Gunter wrote:
> Only one writer may be active at any one time. The other(s) will recieve an
> error return status. You can either wait a while and retry this in your
> application or set a busy timeout to handle the "usual" cases for you.
Agreed. The default ti
Only one writer may be active at any one time. The other(s) will recieve an
error return status. You can either wait a while and retry this in your
application or set a busy timeout to handle the "usual" cases for you.
-Urspr?ngliche Nachricht-
Von: Rohit Savaliya [mailto:rohit.savaliya
On Wed, Mar 4, 2015 at 1:11 AM, Alexandr N?mec wrote:
> we have a product that uses SQLite. Because it was running very stable for
> years, we are still using SQLite 3.7.17. Now we've seen on one of our
> installations that the database has been corrupted, we saw that there was a
> power failure a
Hi all,
I am using System.Data.SQLite in my project.
I have two threads which are updating database simultaneously.
I get SQLite error(5): database is locked, System.Data.SQLite error.
Why is it so!. What could be the reason? Does System.Data.SQLite is not
thread safe?
Please help me out.
--
Re
On Wed, Mar 4, 2015 at 10:08 AM, Hick Gunter wrote:
> Properly implemented virtual tables do support indexing, but you have to
> write the code to support that yourself.
>
> I have personally implemented an index based on the fastbit package which
> is ideally suited to retrieving large data sets
Hi all,
?
we have a product that uses SQLite. Because it was running very stable for
years, we are still using SQLite 3.7.17. Now we've seen on one of our
installations that the database has been corrupted, we saw that there was a
power failure around the time of the corruption. We tested power
Properly implemented virtual tables do support indexing, but you have to write
the code to support that yourself.
I have personally implemented an index based on the fastbit package which is
ideally suited to retrieving large data sets via equality and range constraints.
See https://sdm.lbl.gov
> Rowids will be faster than primary keys.
My primary keys are ROWIDs ("INTEGER PRIMARY KEY" actually)
None of the index was exploited for the order by, and the matched records
in table A are scattered in pages all over the database, so ordering them
in memory has a tendency to "replace" the whol
Hello,
The SQLite Command Line Shell is documented
(http://www.sqlite.org/sessions/sqlite.html) to support interrupting a
long-running SQL statement by using the interrupt character (Control-C).
On Windows, the shell is terminated immediately by Control-C, rather than
interrupting the SQL stateme
On 3/3/2015 6:59 PM, Jean-Christophe Deschamps wrote:
> At 11:27 03/03/2015, you wrote:
>
>> - the full table scan returns rows in rowID order, which is the order
>> in which the rows were added to the table
> `---
>
> No and no.
>
> An SQL engine doesn't guarantee any row "order" unless you
21 matches
Mail list logo
