[sqlite] cross-database transaction

2015-07-24 Thread MM
Hello, Is it possible to only update table1 in database1 and table2 in database2 if both succeed? Rds,

[sqlite] WAL with linux and win

2015-04-01 Thread MM
about win/linux dbfile travel through git? I understand 2 more files appear in WAL, the wal-index and the shmem file. I can't just share across the 2 boxes server and pc? Rds, MM

[sqlite] sqldiff nowadays

2016-04-06 Thread MM
On 23 March 2016 at 15:53, Alek Paunov wrote: > Hi MM, > > Sorry for the late replay - I usually manage to check the list only once a > day :-(. > > On 2016-03-22 16:05, MM wrote: > ... > > If, by chance, you are on something Fedora based, I could give you some >

[sqlite] sqldiff nowadays

2016-03-22 Thread MM
sqldiff and build only that, in 64bit as well. Rds, MM

[sqlite] sqldiff nowadays

2016-03-22 Thread MM
On 22 March 2016 at 13:28, Alek Paunov wrote: > On 2016-03-22 13:49, Richard Hipp wrote: > >> On 3/22/16, MM wrote: >> >>> Hello, >>> I can see sqldiff appearing here: >>> >>> https://www.sqlite.org/sqldiff.html >>> >>> and

[sqlite] Recursive query

2018-06-15 Thread MM
I have table A of rows with column "object_id", and 2 NULL columns A_id and B_id. Each row of A (among rows with the same object_id) either references table A itself or table B, ie columns A_id and B_id are mutually exclusive. e.g. Table A object_id A_id B_id ... 1 NULL

Re: [sqlite] Recursive query

2018-06-15 Thread MM
> > On 2018/06/15 3:19 PM, MM wrote: > I have table A of rows with column "object_id", and 2 NULL columns A_id > and B_id. > Each row of A (among rows with the same object_id) either references > table A itself or table B, ie columns A_id and B_id are mutually

[sqlite] wal mode

2019-12-06 Thread MM
e writers too. I suppose I am in autocommit mode as that is the default and I do nothing to change that. What happens when 2 processes that have had their connection open for a while, attempt a UPDATE or INSERT INTO statement at the same time? MM ___ sq

Re: [sqlite] wal mode

2019-12-07 Thread MM
On Fri, 6 Dec 2019 at 19:06, Simon Slavin wrote: > On 6 Dec 2019, at 6:39pm, MM wrote: > > > So it suffices that I run "PRAGMA journal_mode=WAL;" once from say the > sqlite3 cli, for all future connections from any tool will use WAL mode for > this database file? >