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?
>
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
>
> 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
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
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
>
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
sqldiff and build only that, in 64bit
as well.
Rds,
MM
Hello,
Is it possible to only update table1 in database1 and table2 in database2
if both succeed?
Rds,
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
9 matches
Mail list logo