Re: [sqlite] SQLite DB on external USB HD - is it safe?

2017-05-12 Thread Tim Streater
On 11 May 2017, at 23:35, Simon Slavin wrote: > It’s the word 'remote' which is not clearly explained. In the SQLite > documentation, the word 'remote' means you’re accessing it using a networking > API not a file system API. It’s the network storage APIs which tend to do > locking badly. Loca

Re: [sqlite] SQLite DB on external USB HD - is it safe?

2017-05-11 Thread Simon Slavin
On 11 May 2017, at 4:12pm, Bill Wade wrote: > I'd say that "local file system" versus "remote file system" is really more > of a shorthand for the requirement that low-level operations such as locks > and reads behave the way that sqlite expects them to behave. > > > > In particular, locks on

Re: [sqlite] SQLite DB on external USB HD - is it safe?

2017-05-11 Thread Bill Wade
om] >> Sent: Tuesday, May 9, 2017 17:06 >> To: SQLite mailing list >> Subject: Re: [sqlite] SQLite DB on external USB HD - is it safe? >> ... >> If Windows reports that the filesystem is "local" then it is OK. >> ... _

Re: [sqlite] SQLite DB on external USB HD - is it safe?

2017-05-10 Thread Wolfgang Enzinger
OK, thanks for the detailed analysis! :-) Am Tue, 09 May 2017 16:06:28 -0600 schrieb Keith Medcalf: [...] > If Windows reports that the filesystem is "local" then it is OK. If > Windows reports that the filesystem is "remote", then it is ungood. A > "drive mapped to the local computer" is a

Re: [sqlite] SQLite DB on external USB HD - is it safe?

2017-05-09 Thread Keith Medcalf
On Tuesday, 9 May, 2017 15:02, Wolfgang Enzinger enquired, > since it's wise to store SQLite databases on local HDs (as opposed to > network filesystems) in order to avoid corruption, As long as you understand what a "network filesysem" is. A "network filesystem" is a filesystem that is remo

[sqlite] SQLite DB on external USB HD - is it safe?

2017-05-09 Thread Wolfgang Enzinger
Dear group members, since it's wise to store SQLite databases on local HDs (as opposed to network filesystems) in order to avoid corruption, I would like to have my program check if this requirement is fulfilled. I'm on Windows so I use GetDriveType() for testing the DB path. Now I noticed that th