Re: [sqlite] Safe to use SQLite over a sketchy network?

2019-09-24 Thread Rowan Worth
On Wed, 25 Sep 2019 at 12:58, Simon Slavin wrote: > When I first learned the SQLite had problems with Network File Systems I > read a ton of stuff to learn why there doesn't seem to be a Network File > Systems that implements locking properly. > > Still, I wonder why someone working on a Linux

Re: [sqlite] Safe to use SQLite over a sketchy network?

2019-09-24 Thread Simon Slavin
When I first learned the SQLite had problems with Network File Systems I read a ton of stuff to learn why there doesn't seem to be a Network File Systems that implements locking properly. I ended up with … A) It slows access a lot. Even with clever hashing to check for collisions it takes

Re: [sqlite] Safe to use SQLite over a sketchy network?

2019-09-24 Thread Rowan Worth
On Wed, 25 Sep 2019 at 05:14, Randall Smith wrote: > I have an application where remote users will be connecting to a SQLite DB > over a network connection that seems to be somewhat sketchy (I can't > characterize it well; I'm hearing this second-hand). > > My question is: Do the

Re: [sqlite] Safe to use SQLite over a sketchy network?

2019-09-24 Thread Keith Medcalf
On Tuesday, 24 September, 2019 16:30, Jens Alfke wrote: >There will be times when a program using SQLite finds itself running over >a networked filesystem, but no one should deliberately write SQLite-based >code intending to use a networked filesystem. For that you want a >client/server

Re: [sqlite] Safe to use SQLite over a sketchy network?

2019-09-24 Thread Jen Pollock
On Tue, Sep 24, 2019 at 03:30:00PM -0700, Jens Alfke wrote: > There will be times when a program using SQLite finds itself running > over a networked filesystem, but no one should deliberately write > SQLite-based code intending to use a networked filesystem. For that > you want a client/server

Re: [sqlite] Safe to use SQLite over a sketchy network?

2019-09-24 Thread Jens Alfke
> On Sep 24, 2019, at 3:22 PM, Jose Isaias Cabrera wrote: > > Even on a great network, you can have problems, so when you say "sketchy", > then definitely there will be problems. And even with a perfect network and perfect networked filesystem, it's still possible to get denial-of-service

Re: [sqlite] Safe to use SQLite over a sketchy network?

2019-09-24 Thread Jose Isaias Cabrera
Randall Smith, on Tuesday, September 24, 2019 05:14 PM, wrote...​ > ​ > I have an application where remote users will be connecting to a SQLite DB > over a network​ > connection that seems to be somewhat sketchy (I can't characterize it well; > I'm hearing​ > this second-hand).​ > ​ > My

Re: [sqlite] Safe to use SQLite over a sketchy network?

2019-09-24 Thread Jens Alfke
> On Sep 24, 2019, at 2:14 PM, Randall Smith wrote: > > My question is: Do the commit-or-rollback semantics of SQLite transactions > work if the connection to the file system is weird? What filesystem is it — SMB, NFS, AFP, …? I'm not an expert, but in general I think the database file

Re: [sqlite] Safe to use SQLite over a sketchy network?

2019-09-24 Thread Simon Slavin
On 24 Sep 2019, at 10:14pm, Randall Smith wrote: > I have an application where remote users will be connecting to a SQLite DB > over a network connection that seems to be somewhat sketchy (I can't > characterize it well; I'm hearing this second-hand). > > My question is: Do the

[sqlite] Safe to use SQLite over a sketchy network?

2019-09-24 Thread Randall Smith
I have an application where remote users will be connecting to a SQLite DB over a network connection that seems to be somewhat sketchy (I can't characterize it well; I'm hearing this second-hand). My question is: Do the commit-or-rollback semantics of SQLite transactions work if the