Re: [sqlite] sqlite3_randomness Quality

2013-05-25 Thread Udon Shaun
Hi Simon. >That's 2^64 values. That's not the same as the repetition/period. Also.sqlite3_randomness can supply up to n bytes so isn't limited to 8 bytes. >"You're not going to catch any one of us saying here publicly "This is good enough for all cryptographic purposes." since we have no intent

Re: [sqlite] Best way to implement Find commands

2013-05-25 Thread Michael Falconer
Hi Vance, ...yes it seems reasonable to expect the same resulting order if your subsequent (temp creating) query is identical to that which was run previously. However I can understand, from a theoretical and experience point of view, why you might feel uneasy about relying on a rowid as the basis

Re: [sqlite] Is pragma foreign_key_check fast enough to be used in normal application flow?

2013-05-25 Thread Paolo Bolzoni
To get answers in a similar situation I found useful the EXPLAIN QUERY PLAN command. On Fri, May 24, 2013 at 3:56 PM, kyan wrote: > On Fri, May 24, 2013 at 4:46 PM, Marc L. Allen > wrote: > >> It's exhaustive in that it absolutely verifies if the key exists or not. >> However, it doesn't necessa

Re: [sqlite] Use more than one database in one application

2013-05-25 Thread Igor Tandetnik
On 5/24/2013 8:10 AM, Simon Wei wrote: I use two databases in a application (.exe): sqlite3_open16 (“db1.db”, db_1); // open first sqlite3_open16 (“db2.db”, db_2); // open second when I INSERT some data into db_1, data is actually inserted into db_2. Is this my bug or Sqlite’s bug? I'm 99.

[sqlite] Use more than one database in one application

2013-05-25 Thread Simon Wei
Hi, I use two databases in a application (.exe): sqlite3_open16 (“db1.db”, db_1); // open first sqlite3_open16 (“db2.db”, db_2); // open second when I INSERT some data into db_1, data is actually inserted into db_2. Is this my bug or Sqlite’s bug? Thank you. BR, Simon ___

Re: [sqlite] Unattended install

2013-05-25 Thread Joe Mistachkin
Matthijs ter Woord wrote: > > I'm looking for a way to install System.Data.SQLite unattended, as part of > the installation procedure of my product. > How can this be achieved? > Normally, there is nothing that requires installation on an end-user machine. Simply deploy the System.Data.SQLite m

[sqlite] Unattended install

2013-05-25 Thread Matthijs ter Woord
Hi, I'm looking for a way to install System.Data.SQLite unattended, as part of the installation procedure of my product. How can this be achieved? Regards, Matthijs ter Woord ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/c