Re: [sqlite] INSERT OR IGNORE vs INSERT WHERE NOT EXISTS

Thanks, but I can't do that because I'm batching up multiple writes in transactions to get performance. The errors cause the whole transaction to need to be rolled back. On 8/04/2012 11:20 a.m., Igor Tandetnik wrote: Josh Gibbs wrote: The method that must be used is as

Re: [sqlite] INSERT OR IGNORE vs INSERT WHERE NOT EXISTS

Josh Gibbs wrote: > The method that must be used is as follows: > > CREATE TABLE test_table (property TEXT PRIMARY KEY, value TEXT); > > SQLite: INSERT OR IGNORE INTO test_table VALUES('prop','val'); > Postgres: INSERT INTO test_table SELECT 'prop','val' WHERE NOT EXISTS >

[sqlite] INSERT OR IGNORE vs INSERT WHERE NOT EXISTS

Looking for some performance advice before I go testing this myself. I'm porting some code that's currently running with SQLite as its DB engine over to postgres. SQLite will still be an option so I need to maintain compatibility across both engines. I've run into the common postgres

Re: [sqlite] [patch 2/2] move "const" out of loop in "WHERE const AND expr"

On 2011/10/23, Yuriy Kaminskiy wrote: > Yuriy Kaminskiy wrote: >> Yuriy Kaminskiy wrote: >>> Yuriy Kaminskiy wrote: When WHERE condition is constant, there are no need to evaluate and check it for each row. It works, but only partially: >>> ... [In fact, you can move out out

Re: [sqlite] undefined symbol: sqlite3_stricmp

Command-line shell works fine but tclsqlite package does not: $ tclsh8.5 test.tcl /usr/lib/libsqlitefts3.so: undefined symbol: sqlite3_stricmp while executing "db eval {SELECT load_extension('/usr/lib/libsqlitefts3.so')}" $ sqlite3 SQLite version 3.7.12 2012-04-07 11:00:54 Enter ".help" for

Re: [sqlite] undefined symbol: sqlite3_stricmp

On Sat, Apr 7, 2012 at 7:20 AM, Alexey Pechnikov wrote: > Compiled as extension FTS3 module produce error "undefined symbol: > sqlite3_stricmp" by loading. > The problem exists in last release and current trunk. > See

Re: [sqlite] Compiling with VS 2010 (force foreign key constraints)

OK, i am getting somewhere. I try to use SQLite with custom compiles dll (System.Data.SQLite, System.Data.SQLite.Linq, SQLite.Interop) and it works. No error, which is a huge think for me. But for foregein key ID i can add anythink i want also ID that is not in reference table. I did edit

[sqlite] undefined symbol: sqlite3_stricmp

Compiled as extension FTS3 module produce error "undefined symbol: sqlite3_stricmp" by loading. The problem exists in last release and current trunk. -- Best regards, Alexey Pechnikov. http://pechnikov.tel/ ___ sqlite-users mailing list