[sqlite] [AGAIN] SQLite on network share

2015-11-16 Thread Stephen Chrzanowski
Where's the like button when you actually want to use it? On Sun, Nov 15, 2015 at 8:05 PM, James K. Lowden wrote: > On Fri, 13 Nov 2015 13:19:33 -0800 > Roger Binns wrote: > > > On talking to sites that had the competitor devices, we'd find they > > did notice increases in programs crashing

[sqlite] [AGAIN] SQLite on network share

2015-11-15 Thread Luiz Américo
Em 13/11/2015 15:29, "A. Mannini" escreveu: > > Hi, > > i read SQLite FAQ and understood that use of SQLite on network share CAN > corrupts database file. > Fo me, it isn't clear if there is a way to safely use SQLite on a > network share in contests with few clients (max 5 for ex) and low read /

[sqlite] [AGAIN] SQLite on network share

2015-11-15 Thread James K. Lowden
On Fri, 13 Nov 2015 13:19:33 -0800 Roger Binns wrote: > On talking to sites that had the competitor devices, we'd find they > did notice increases in programs crashing and data file issues, but > had written it off as the kind of thing that happens with Windows. Q: Why doesn't Microsoft

[sqlite] [AGAIN] SQLite on network share

2015-11-14 Thread Stephen Chrzanowski
I've read through all the other posts on this thread, and I must agree. Your "serverless" configuration can't exist because each client becomes a server, BY DEFINITION, when it starts PROVIDING information to other clients. I've written a book, by now, when this topic comes up. Believe me

[sqlite] [AGAIN] SQLite on network share

2015-11-13 Thread Stephan Beal
On Fri, Nov 13, 2015 at 11:15 PM, A. Mannini wrote: > Yes I use it in other contests but, as written in another message, in > need a serverless solutions. > A shared filesystem _is_ a network service! Since they have a system sharing a drive, they can just as easily install MySQL on it and

[sqlite] [AGAIN] SQLite on network share

2015-11-13 Thread A. Mannini
> Why do you think that is a problem? (the x86_64)? > Yes there isn't a x64 Jet version. Or at least, there is the ACE x64 but can't be installed side-by-side to Office 32 bit. > Other suggests are welcomed? > Microsoft SQL Server is free (with a limitation of a 4GB database) and it > probably

[sqlite] [AGAIN] SQLite on network share

2015-11-13 Thread R Smith
On 2015/11/13 10:52 PM, A. Mannini wrote: >> Basically the decision is easy - If you require either of: >> - Network data >> - User control >> >> Then you should use a suited Network DB and not a file-based DB. Best >> free (without limitations) choices are (In no particular order): >> -

[sqlite] [AGAIN] SQLite on network share

2015-11-13 Thread R Smith
On 2015/11/13 9:55 PM, A. Mannini wrote: > Ok, thanks for all your replies!!! > > First, i was asking to understand...before to start development in a > wrong direction. > > I don't have experience with SQLite and even less on a network share. I > would understand if corruption is a remote

[sqlite] [AGAIN] SQLite on network share

2015-11-13 Thread A. Mannini
> Basically the decision is easy - If you require either of: > - Network data > - User control > > Then you should use a suited Network DB and not a file-based DB. Best > free (without limitations) choices are (In no particular order): > - PostGres | http://www.postgresql.org/ > - MariaDB / MySQL

[sqlite] [AGAIN] SQLite on network share

2015-11-13 Thread Simon Slavin
On 13 Nov 2015, at 6:46pm, A. Mannini wrote: > 1) is there a list of FS where SQLite works fine? It's not usually the FS which is causing the problem. When your application tells the OS to write to a remote disk ... program calls OS API to write to a file OS calls Network FS on client

[sqlite] [AGAIN] SQLite on network share

2015-11-13 Thread A. Mannini
Ok, thanks for all your replies!!! First, i was asking to understand...before to start development in a wrong direction. I don't have experience with SQLite and even less on a network share. I would understand if corruption is a remote possibility or a certainty. Someone said that Access suffer

[sqlite] [AGAIN] SQLite on network share

2015-11-13 Thread Bernardo Sulzbach
You said you wanted something that didn't require too much skill to set up? PostgreSQL seems safer and easier than implementing VFS yourself. One is **slightly** less error-prone than the other. On Fri, Nov 13, 2015 at 7:08 PM, Keith Medcalf wrote: > You realize that the marketing translation of

[sqlite] [AGAIN] SQLite on network share

2015-11-13 Thread A. Mannini
Il 13/11/2015 19:31, Richard Hipp ha scritto: > On 11/13/15, A. Mannini wrote: >> Hi, >> >> i read SQLite FAQ and understood that use of SQLite on network share CAN >> corrupts database file. >> Fo me, it isn't clear if there is a way to safely use SQLite on a >> network share in contests with

[sqlite] [AGAIN] SQLite on network share

2015-11-13 Thread A. Mannini
Hi, i read SQLite FAQ and understood that use of SQLite on network share CAN corrupts database file. Fo me, it isn't clear if there is a way to safely use SQLite on a network share in contests with few clients (max 5 for ex) and low read / write concurrency.. Thanks Alessandro

[sqlite] [AGAIN] SQLite on network share

2015-11-13 Thread Niall O'Reilly
On Fri, 13 Nov 2015 18:29:32 +, A. Mannini wrote: > > Hi, > > i read SQLite FAQ and understood that use of SQLite on network share CAN > corrupts database file. > Fo me, it isn't clear if there is a way to safely use SQLite on a > network share in contests with few clients (max 5 for ex) and

[sqlite] [AGAIN] SQLite on network share

2015-11-13 Thread Bernardo Sulzbach
On Fri, Nov 13, 2015 at 5:04 PM, Niall O'Reilly wrote: > People on this mailing list can't do your risk assessment or > impact analysis for you. > > Best regards, > Niall O'Reilly > Seconded. You asked if there was a way to safely use it. I don't think there is. You also mentioned "max

[sqlite] [AGAIN] SQLite on network share

2015-11-13 Thread Keith Medcalf
> > Why do you think that is a problem? (the x86_64)? > Yes there isn't a x64 Jet version. Or at least, there is the ACE x64 but > can't be installed side-by-side to Office 32 bit. Ah, I see. Microsoft introduces artificial restrictions "because they can". Just like they could have fixed all

[sqlite] [AGAIN] SQLite on network share

2015-11-13 Thread Random Coder
On Fri, Nov 13, 2015 at 1:46 PM, A. Mannini wrote: > 2) why there are SERVERLESS database (MS Access or VistaDB) that works > without FS restrictions? If you think Access works reliably on a network share, you're going to run in to trouble sooner or later:

[sqlite] [AGAIN] SQLite on network share

2015-11-13 Thread Keith Medcalf
> Ok, thanks for all your replies!!! > > First, i was asking to understand...before to start development in a > wrong direction. > > I don't have experience with SQLite and even less on a network share. I > would understand if corruption is a remote possibility or a certainty. > > Someone said

[sqlite] [AGAIN] SQLite on network share

2015-11-13 Thread Keith Medcalf
On Friday, 13 November, 2015 12:55 A. Mannini said: > About VistaDB it support use on network share look at > http://www.gibraltarsoftware.com/Support/VistaDB/Documentation/WebFrame.ht > ml#VistaDB_Introduction_SupportedPlatforms.html > and confirmed from its support. Unfortunately i have not

[sqlite] [AGAIN] SQLite on network share

2015-11-13 Thread Richard Hipp
On 11/13/15, A. Mannini wrote: > Hi, > > i read SQLite FAQ and understood that use of SQLite on network share CAN > corrupts database file. > Fo me, it isn't clear if there is a way to safely use SQLite on a > network share in contests with few clients (max 5 for ex) and low read / > write

[sqlite] [AGAIN] SQLite on network share

2015-11-13 Thread Roger Binns
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 11/13/2015 11:55 AM, A. Mannini wrote: > About VistaDB it support use on network share look at > http://www.gibraltarsoftware.com/Support/VistaDB/Documentation/WebFram e.html#VistaDB_Introduction_SupportedPlatforms.html > > and confirmed from its

[sqlite] [AGAIN] SQLite on network share

2015-11-13 Thread Scott Robison
On Fri, Nov 13, 2015 at 12:55 PM, A. Mannini wrote: > > Ok, thanks for all your replies!!! > > First, i was asking to understand...before to start development in a > wrong direction. > > I don't have experience with SQLite and even less on a network share. I > would understand if corruption is a

[sqlite] [AGAIN] SQLite on network share

2015-11-13 Thread Roger Binns
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 11/13/2015 10:46 AM, A. Mannini wrote: > 1) is there a list of FS where SQLite works fine? I don't know of any. Network filesystems are very hard to implement (so many corner cases), and there is a lot of complexity if you also want them to be

[sqlite] [AGAIN] SQLite on network share

2015-11-13 Thread Roger Binns
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 11/13/2015 10:31 AM, Richard Hipp wrote: > Just be warned that there are many network filesystems that claim > to implement locks correctly, and do most of the time, but > sometimes mess up It is also worth mentioning that SQLite trusts the