Re: [sqlite] malloc failures on ubuntu

2012-12-15 Thread bkk
but i have got 142 errors out of 2083931 tests (result of alltest excution) but you told its 119415 , so is it doing any thing more ? Brijesh -- View this message in context: http://sqlite.1065341.n5.nabble.com/malloc-failures-on-ubuntu-tp65936p66148.html Sent from the SQLite mailing list

Re: [sqlite] malloc failures on ubuntu

2012-12-15 Thread bkk
but i have got 142 errors out of 2083931 tests (result of alltest excution) but you told its 119415 , so is it doing any thing more ? Brijesh -- View this message in context: http://sqlite.1065341.n5.nabble.com/malloc-failures-on-ubuntu-tp65936p66149.html Sent from the SQLite mailing list

Re: [sqlite] sqlite-users Digest, Vol 60, Issue 15

2012-12-15 Thread Çağlar Orhan
Hi fellows, i just begin to use sqlite for my little project. The main job is to record documents names, subjects, date etc. to database and running queries on it. I wonder if sqlite handle huge amounts of data inserted? Is there a limit of file capacity of .sqlite file, or record count? Thank you

Re: [sqlite] sqlite-users Digest, Vol 60, Issue 15

2012-12-15 Thread Simon Slavin
On 15 Dec 2012, at 5:19pm, Çağlar Orhan cagla...@gmail.com wrote: i just begin to use sqlite for my little project. The main job is to record documents names, subjects, date etc. to database and running queries on it. I wonder if sqlite handle huge amounts of data inserted? Is there a limit

[sqlite] INSERT OR REPLACE

2012-12-15 Thread Peter Haworth
If I understand the docs correctly, the REPLACE part of an INSERT OR REPLACE command deletes a row if a UNIQUE constraint occurs and inserts a new row in its place. On the face of it, that seems like it will invalidate any foreign key definitions that use the primary key of the INSERT OR REPLACE

Re: [sqlite] INSERT OR REPLACE

2012-12-15 Thread Simon Slavin
On 15 Dec 2012, at 6:26pm, Peter Haworth p...@lcsql.com wrote: If I understand the docs correctly, the REPLACE part of an INSERT OR REPLACE command deletes a row if a UNIQUE constraint occurs and inserts a new row in its place. Correct. f that commend decides a REPLACE is needed the