[sqlite] The Lock-Byte Page

2015-12-27 Thread Olivier Mascia
> Le 27 d?c. 2015 ? 23:17, Simon Slavin a ?crit : > > These bytes can be used by a VFS designed to run on those operating systems > to allow communication between processes about lock status. Thanks a lot for the whole explanation Simon. Much clearer now. -- Meilleures salutations, Met vriende

[sqlite] The Lock-Byte Page

2015-12-27 Thread Olivier Mascia
Hello, I'm referring to paragraph 1.3 of https://www.sqlite.org/fileformat2.html about the Lock-Byte page.

[sqlite] The Lock-Byte Page

2015-12-27 Thread Simon Slavin
On 27 Dec 2015, at 10:08pm, Olivier Mascia wrote: > What I don't really get straight is what file-locking related mechanism would > have a use for those bytes, knowing they wouldn't even exists unless the > database size is 2^30 bytes or more? Some operating systems for unusual operating syst

[sqlite] Locked database

2015-12-27 Thread Cecil Westerhof
2015-12-27 18:11 GMT+01:00 Yuriy M. Kaminskiy : > (I know, I'm a bit late for discussion, but...) > > Cecil Westerhof > writes: > > > 2015-12-14 12:40 GMT+01:00 Clemens Ladisch : > > > >> Cecil Westerhof wrote: > >> > I have a crontab job which uses a SQLite database. Sometimes this > database >

[sqlite] How is the name of the db file is identified?

2015-12-27 Thread Igor Korot
Hi, ALL, Is it possible to save the SQLite DB file whose name contains some Unicode characters? Have such a character in the table name? Thank you.

[sqlite] Locked database

2015-12-27 Thread Yuriy M. Kaminskiy
(I know, I'm a bit late for discussion, but...) Cecil Westerhof writes: > 2015-12-14 12:40 GMT+01:00 Clemens Ladisch : > >> Cecil Westerhof wrote: >> > I have a crontab job which uses a SQLite database. Sometimes this database >> > is locked because I used SQLite DB Browser, but did not Write or

[sqlite] Locked database

2015-12-27 Thread Simon Slavin
On 27 Dec 2015, at 5:11pm, Yuriy M. Kaminskiy wrote: > (I know, I'm a bit late for discussion, but...) ... but you know the language (script system) the OP was writing in and you understand the problems involved in scripting SQLite. Great post. Simon.

[sqlite] Maybe a typo in documentation...

2015-12-27 Thread Stayros Mpampis
2015-12-27 16:11 GMT+02:00, Olivier Mascia : > Not sure where to report such things, so let's report here and have whoever > concerned forward it where it belongs. Thanks. > > Within this page of documentation: > https://www.sqlite.org/fileformat2.html#btree > I think the next sentence has a typo.

[sqlite] Maybe a typo in documentation...

2015-12-27 Thread Olivier Mascia
Not sure where to report such things, so let's report here and have whoever concerned forward it where it belongs. Thanks. Within this page of documentation: https://www.sqlite.org/fileformat2.html#btree I think the next sentence has a typo. (I "think", because english is not my native language)

[sqlite] Maybe a typo in documentation...

2015-12-27 Thread Richard Hipp
On 12/27/15, Olivier Mascia wrote: > > "Varints are big-endian: bits taken from the earlier byte of the varint are > the more significant and bits taken from the later bytes." > > Shouldn't it read: "... are more significant than bits taken from the later > bytes." ? > Thanks. Typo fixed at http