Re: [sqlite] Bulk Insert

On 08/12/2011 14:25, Sumit Gupta wrote: Hello, Thanks for your suggestion, yup the Speed with Transaction is increase multifold. In 5 minute it read half the data. But wondering what different the Transaction make as compare to normal insert query ? Why is it faster here. I didn't change

[sqlite] Constraint failed infos

Hello, Is it possible to get more info when I get a constraint failed error from the C API? I am interested in the column name, table name and type of constraint. Regards, Julien ___ sqlite-users mailing list sqlite-users@sqlite.org

[sqlite] sqlite3_step() error and constraints

Hi, When sqlite3_step() fail because a UNIQUE constraint is not satisfied, it returns SQLITE_ERROR. I see that there is an error code named SQLITE_CONSTRAINT. Why sqlite3_step() does not return this one? Having a specific error code would be useful to warn the user that the data he submitted

Re: [sqlite] sqlite3_step() error and constraints

On 03/31/2011 19:08, Igor Tandetnik wrote: On 3/31/2011 2:02 PM, Julien Laffaye wrote: When sqlite3_step() fail because a UNIQUE constraint is not satisfied, it returns SQLITE_ERROR. I see that there is an error code named SQLITE_CONSTRAINT. Why sqlite3_step() does not return this one