[sqlite] Sqlite and threads/multiple applications

2015-03-03 Thread Olivier Vidal
ok, thank you all! > Will Fong > 2 mars 2015 01:23 > Hi Olivier, > > As other people have already mentioned, the operating system doesn't > matter. Pick the one you're most comfortable or interest in using. The > most reliable or secure OS is worthless if you don't

[sqlite] Sqlite and threads/multiple applications

2015-03-02 Thread Will Fong
Hi Olivier, On Sun, Mar 1, 2015 at 5:22 PM, Olivier Vidal wrote: > What would be the most reliable operating system for Sqlite(last version)? As other people have already mentioned, the operating system doesn't matter. Pick the one you're most comfortable or interest in using. The most reliable

[sqlite] Sqlite and threads/multiple applications

2015-03-01 Thread R.Smith
On 2015-03-01 11:22 AM, Olivier Vidal wrote: > ok, thank you Simon and Keith! > other people have experience with multiple applications/one sqlite > database? > > looking at this list , I > wonder if there is an operating system to favour with Sqlite.

[sqlite] Sqlite and threads/multiple applications

2015-03-01 Thread Simon Slavin
On 1 Mar 2015, at 9:22am, Olivier Vidal wrote: > looking at this list , I wonder if > there is an operating system to favour with Sqlite. Operating systems aren't a problem. Chose whatever OS you like based on other considerations. The same is true

[sqlite] Sqlite and threads/multiple applications

2015-03-01 Thread Olivier Vidal
ok, thank you Simon and Keith! other people have experience with multiple applications/one sqlite database? looking at this list , I wonder if there is an operating system to favour with Sqlite. I saw that there could be problems with older versions of

[sqlite] Sqlite and threads/multiple applications

2015-02-28 Thread Simon Slavin
On 28 Feb 2015, at 7:02pm, Olivier Vidal wrote: > According to this paragraph http://www.sqlite.org/faq.html#q5, multiple > applications or multiple instances of the same application can access the > *same* database at the *same time*. Even in WAL mode? Yes. Assuming that you are talking

[sqlite] Sqlite and threads/multiple applications

2015-02-28 Thread Olivier Vidal
Hello all, According to this paragraph http://www.sqlite.org/faq.html#q5, multiple applications or multiple instances of the same application can access the *same* database at the *same time*. Even in WAL mode? If I have understood correctly, all applications will be able to read the sqlite

[sqlite] Sqlite and threads/multiple applications

2015-02-28 Thread Keith Medcalf
>If I have understood correctly, all applications will be able to read >the sqlite database at the same time, but there will be only one thread >(one thread of one application) who will write at the same time (in WAL >mode). There will be only one *connection* that can write at a time. This will