Re: [sqlite] SQLite with single writer on Windows network share

Andrew Moss, on Monday, May 13, 2019 04:59 AM, wrote... >Many thanks for all your comments and suggestions. I will bear it all in >mind. Are you trying to shut us up? :-) ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org

Re: [sqlite] SQLite with single writer on Windows network share

Many thanks for all your comments and suggestions. I will bear it all in mind. On Sun, 12 May 2019 at 12:26, Warren Young wrote: > On May 11, 2019, at 5:52 PM, Jose Isaias Cabrera > wrote: > > > > Warren Young, on Saturday, May 11, 2019 06:20 PM, wrote... > >> > >> On May 11, 2019, at 4:10 PM,

Re: [sqlite] SQLite with single writer on Windows network share

On May 11, 2019, at 5:52 PM, Jose Isaias Cabrera wrote: > > Warren Young, on Saturday, May 11, 2019 06:20 PM, wrote... >> >> On May 11, 2019, at 4:10 PM, Thomas Kurz wrote: >> >> It should run under Cygwin and WSL. > > I tried to build it. I fould out that I needed brew Cygwin’s own package

Re: [sqlite] SQLite with single writer on Windows network share

qlite.org] On Behalf Of Simon Slavin >Sent: Saturday, 11 May, 2019 18:04 >To: SQLite mailing list >Subject: Re: [sqlite] SQLite with single writer on Windows network >share > >On 12 May 2019, at 12:52am, Jose Isaias Cabrera >wrote: > >> the other question is, that I think

Re: [sqlite] SQLite with single writer on Windows network share

On 12 May 2019, at 12:52am, Jose Isaias Cabrera wrote: > the other question is, that I think I only need the gcc@6 package to build > Bedrockdb. Does anybody know what is gcc@6? But I don't know where to find it for your platform.

Re: [sqlite] SQLite with single writer on Windows network share

Warren Young, on Saturday, May 11, 2019 06:20 PM, wrote... > >On May 11, 2019, at 4:10 PM, Thomas Kurz wrote: > > It should run under Cygwin and WSL. > > I doubt it’s any more difficult to port to Windows than dozens of other > similar > packages like Apache and MySQL. Someone’s just got to

Re: [sqlite] SQLite with single writer on Windows network share

On 11 May 2019, at 11:20pm, Warren Young wrote: > I doubt it’s any more difficult to port to Windows than dozens of other > similar packages like Apache and MySQL. Mutex/Locking. You're relying on a File System and/or a Network File System that does locking properly. I'm not saying that

Re: [sqlite] SQLite with single writer on Windows network share

On May 11, 2019, at 4:10 PM, Thomas Kurz wrote: > >> How about you give up on the idea of using Windows shares to distribute a >> SQLite DB and use a tool meant for the job, such as BedrockDB? > > BedrockDB is recommended here now and then, and it sounds interesting indeed. > However, it's

Re: [sqlite] SQLite with single writer on Windows network share

> How about you give up on the idea of using Windows shares to distribute a > SQLite DB and use a tool meant for the job, such as BedrockDB? BedrockDB is recommended here now and then, and it sounds interesting indeed. However, it's not available for Windows. (This should always be noted when

Re: [sqlite] SQLite with single writer on Windows network share

On Fri, May 10, 2019 at 4:40 AM Warren Young wrote: > Bedrock is based in part on the Paxos algorithm, another major advance in > distributed computing, and another of Leslie Lamport’s brainchildren: > > https://en.wikipedia.org/wiki/Paxos_(computer_science) In the same vein, there's also

Re: [sqlite] SQLite with single writer on Windows network share

On May 9, 2019, at 4:56 PM, James K. Lowden wrote: > > file I/O operations act on the kernel’s filebuffer It’s more widely called a buffer cache or page cache: https://en.wikipedia.org/wiki/Page_cache > If this sounds like an indictment of NFS, it's really not. In large part, it’s a

Re: [sqlite] SQLite with single writer on Windows network share

On Wed, 8 May 2019 21:36:43 +0200 Clemens Ladisch wrote: > Andrew Moss wrote: > > ... an SQLite database hosted on a windows network share (using > > server 2012 R2 or later). We are well aware this is not advisable > > There are three possible sources of network filesystem data > corruption: >

Re: [sqlite] SQLite with single writer on Windows network share

Andrew Moss wrote: > ... an SQLite database hosted on a windows network share (using server > 2012 R2 or later). We are well aware this is not advisable There are three possible sources of network filesystem data corruption: 1) Bad locking implementations. Some Unix-y network filesystems

Re: [sqlite] SQLite with single writer on Windows network share

Simon Slavin wrote: > setting the journal mode of the database to WAL will ... certainly lead to data corruption; WAL requires shared memory, which cannot work over a network filesystem. Regards, Clemens ___ sqlite-users mailing list

Re: [sqlite] SQLite with single writer on Windows network share

On May 8, 2019, at 10:30 AM, Jose Isaias Cabrera wrote: > > Warren Young, on Wednesday, May 8, 2019 12:10 PM, wrote... > >> How about you give up on the idea of using Windows shares to distribute a >> SQLite DB >> and use a tool meant for the job, such as BedrockDB? >> >>

Re: [sqlite] SQLite with single writer on Windows network share

Warren Young, on Wednesday, May 8, 2019 12:10 PM, wrote... >On May 8, 2019, at 8:42 AM, Andrew Moss wrote: >How about you give up on the idea of using Windows shares to distribute a >SQLite DB > and use a tool meant for the job, such as BedrockDB? > >https://bedrockdb.com/ Man, I wish this

Re: [sqlite] SQLite with single writer on Windows network share

On May 8, 2019, at 8:42 AM, Andrew Moss wrote: > > We are currently backed into a corner by a customer In what way, exactly? It might help to know. > and are looking at > using an SQLite database hosted on a windows network share (using server > 2012 R2 or later). You’ve fallen victim to the

Re: [sqlite] SQLite with single writer on Windows network share

On 8 May 2019, at 3:42pm, Andrew Moss wrote: > My question is, if we limit the application (through other means) to a > single writer, but allow multiple readers, does that remove the risk of > database corruption from multiple SQLite processes? > > Any notes from other users who had to do

Re: [sqlite] SQLite with single writer on Windows network share

Andrew Moss, on Wednesday, May 8, 2019 10:42 AM, wrote... >We are currently backed into a corner by a customer and are looking at >using an SQLite database hosted on a windows network share (using server >2012 R2 or later). We are well aware this is not advisable and have read

[sqlite] SQLite with single writer on Windows network share

Hi, We are currently backed into a corner by a customer and are looking at using an SQLite database hosted on a windows network share (using server 2012 R2 or later). We are well aware this is not advisable and have read https://www.sqlite.org/whentouse.html. My question is, if we limit the