On Thu, 26 Sep 2019 at 13:01, Jens Alfke wrote:
>
> > On Sep 24, 2019, at 3:48 PM, Keith Medcalf wrote:
> >
> > There are not, to my knowledge, any client/server database systems that
> will work properly if the database resides on a network filesystem (meaning
> remote multi-access). The "clie
On 26/09/2019 15:30, Keith Medcalf wrote:
-Original Message-
From: sqlite-users On
Behalf Of Gary R. Schmidt
Sent: Wednesday, 25 September, 2019 23:13
To: sqlite-users@mailinglists.sqlite.org
Subject: Re: [sqlite] Safe to use SQLite over a sketchy network?
On 26/09/2019 15:00, Jens
-Original Message-
>From: sqlite-users On
>Behalf Of Gary R. Schmidt
>Sent: Wednesday, 25 September, 2019 23:13
>To: sqlite-users@mailinglists.sqlite.org
>Subject: Re: [sqlite] Safe to use SQLite over a sketchy network?
>
>On 26/09/2019 15:00, Jens Alfke wrote:
>>
On 26/09/2019 15:00, Jens Alfke wrote:
On Sep 24, 2019, at 3:48 PM, Keith Medcalf wrote:
There are not, to my knowledge, any client/server database systems that will work properly if the database resides on a network filesystem
(meaning remote multi-access). The "client" is remote from the
> On Sep 24, 2019, at 3:48 PM, Keith Medcalf wrote:
>
> There are not, to my knowledge, any client/server database systems that will
> work properly if the database resides on a network filesystem (meaning remote
> multi-access). The "client" is remote from the "server" because the "client"
On 25/09/2019 15:36, Rowan Worth wrote:
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 wonde
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 n
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 tim
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 commit-or-rollba
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 database
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 dat
> 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 be
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 questio
> 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 shoul
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 commit-or-rollb
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 connection
16 matches
Mail list logo