[sqlite] Follow-up to "database disk image is corrupted" problem

Earlier today I posted a question about SQLite compiled into my application generating a "database disk image is corrupted" on a particular query, but the command-line application does not (even using the same database file). I haven't seen that message posted yet, but I have some additional

Re: [sqlite] limiting table size?

Looks like the experts have given good advice. I'll try a different tack... Have a look at http://www.sqlite.org/cvstrac/tktview?tn=1476 The author pointed me to this patch in response to my question about keeping a foreign sequence. But, I think the patch could work equally well for you,

[sqlite] database disk image is malformed -- or not

Any idea what would cause SQLite (3.2.7, I think) compiled into an application to report "database disk image is malformed" when the command-line version of SQLite (3.1.3 and 3.2.8) is able to access the same DB file -- even running the same query -- without error? -Eric -- Eric Scouten |

Re: [sqlite] 2nd question about 'localtime'

Does the column need to be loaded with UTC? Why not just insert the column with localtime already applied? It would make the SELECT you require trivial: SELECT * FROM table WHERE datefield = '2005-12-23'. Regards. rayB |-+> | | "Murray @

Re: [sqlite] ring buffer table

implement a trigger that count the number of rows : if count(rows) = 500 then delete the first row Julien LEFORT wrote: Hi, I would like to implement a log table with a finite dimension, for exemple a table with 500 records, and when the last record is set in the table I would like to come

Re: [sqlite] 2nd question about 'localtime'

Murray @ PlanetThoughtful wrote: Hi All, I have a second question re: dates in SQLite and 'localtime'. I have a table with a DEFAULT CURRENT_TIMESTAMP field. I'm trying to retrieve a recordset of records that have been added to that table today (but, of course, because the field stores UTC,

Re: [sqlite] limiting table size?

Adler, Eliedaat wrote: Sean Wrote === I'm considering using SQLLite for an embedded project. Some of the data I'd like to store is timestamped sensor readings. I'd like to know if there is a way to >configure a table so that it acts like a fixed length FIFO queue, e.g. stores 10,000

[sqlite] 2nd question about 'localtime'

Hi All, I have a second question re: dates in SQLite and 'localtime'. I have a table with a DEFAULT CURRENT_TIMESTAMP field. I'm trying to retrieve a recordset of records that have been added to that table today (but, of course, because the field stores UTC, the value for the majority of

Re: [sqlite] SQlite for Linux on the ARM processor.

Ben Clewett wrote: Dear SQLite I wish to compile SQLite for the ARM processor running Linux (ARM720T). The compilation will have to use the cross-compiler arm-linux-gcc version 2.95.2 running on Intel Linux, since the devise it's self has no compiler. Does any person have an image for

Re: [sqlite] Question about threads

Hello, A patch for this: http://www.sqlite.org/cvstrac/tktview?tn=1417 We are using it since September on our systems without any problem. Bye. Thu, Dec 22, 2005 at 10:04:31AM +0100: Martin Engelschalk wrote: > Hello Eduardo, > > SQLite does not uses threads in itself. Every call to sqlite

[sqlite] ring buffer table

Hi, I would like to implement a log table with a finite dimension, for exemple a table with 500 records, and when the last record is set in the table I would like to come back at the first tuplet and write over the previous value recorded. I think it's the way SQLite journal is implmented. Is

RE: [sqlite] limiting table size?

>Sean Wrote === >I'm considering using SQLLite for an embedded project. Some of the data I'd like to store is timestamped sensor readings. I'd like to know if there is a way to >configure a table so that it acts like a fixed length FIFO queue, e.g. stores 10,000 records then once full drops off

Re: [sqlite] where clause and index question

Hello Stanislaw, i think you may be mistaken. Indices in sqlite are implemented as trees. If the where clause does not include column c, there is no way to use the tree beyond the column b. The program has to look at every row that meets the clauses involving a and b. Also, in my

[sqlite] where clause and index question

Hi I have found following in 'The SQLite Query Optimizer Overview': It is not necessary for every column of an index to appear in a WHERE clause term in order for that index to be used. But there can not be gaps in the columns of the index that are used. Thus for the example index above, if

Re: [sqlite] Question about threads

Hello Eduardo, SQLite does not uses threads in itself. Every call to sqlite executes in the context of the calling thread. There is a restriction explained in http://www.hwaci.com/sw/sqlite/faq.html#q8 I hope this helps. Martin Eduardo schrieb: Hello: We are going to implement

[sqlite] SQlite for Linux on the ARM processor.

Dear SQLite I wish to compile SQLite for the ARM processor running Linux (ARM720T). The compilation will have to use the cross-compiler arm-linux-gcc version 2.95.2 running on Intel Linux, since the devise it's self has no compiler. Does any person have an image for ARM? If not, would any