Timeline for answer to UPSERT in SQLite by CL.
Current License: CC BY-SA 3.0
Post Revisions
12 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Aug 9, 2017 at 7:41 | comment | added | CL. | @alizx There is a 1:1 relationship between a connection and a transaction. If you want separate transactions, you need separate connections. | |
| Aug 9, 2017 at 7:40 | comment | added | alizx | @CL. I cannot get what does sharing a transaction mean. can you please elaborate on this? | |
| Aug 9, 2017 at 7:35 | comment | added | CL. | @alizx When two threads share a connection, they also share the connection's transaction. Proper multithreading requires using using separate connections. | |
| Aug 9, 2017 at 7:33 | comment | added | alizx | "If a separate thread makes changes on the same database connection while sqlite3_changes() is running then the value returned is unpredictable and not meaningful." SQLite documentation | |
| Aug 9, 2017 at 7:24 | comment | added | alizx | according to documentation its per database connection not transaction. | |
| Aug 9, 2017 at 6:39 | comment | added | CL. | @alizx When using a transaction, other threads cannot interfere. | |
| Aug 9, 2017 at 6:39 | history | edited | CL. | CC BY-SA 3.0 |
added 25 characters in body
|
| Aug 9, 2017 at 5:59 | comment | added | alizx | what if another thread was updating a row and changes() was changed between the two query statement? | |
| Apr 1, 2015 at 5:12 | comment | added | Mrug |
INSERT OR IGNORE is using because it consumes single SQL statement.
|
|
| Dec 2, 2013 at 15:43 | comment | added | ultima_rat0 |
Why is everbody using REPLACE INTO or INSERT OR IGNORE then? This solution works like a charm and looks beautiful, thanks!
|
|
| Dec 2, 2013 at 15:42 | vote | accept | ultima_rat0 | ||
| Dec 2, 2013 at 11:02 | history | answered | CL. | CC BY-SA 3.0 |