ok, thank you Simon and Keith! other people have experience with multiple applications/one sqlite database?
looking at this list <https://www.sqlite.org/howtocorrupt.html>, I wonder if there is an operating system to favour with Sqlite. I saw that there could be problems with older versions of Windows or Linux. But take the example of a web server, with as the latest version of Windows Server 2012 or the latest version of Ubuntu. What would be the most reliable operating system for Sqlite(last version)? olivier > Keith Medcalf <mailto:kmedcalf at dessus.com> > 1 mars 2015 00:17 > > There will be only one *connection* that can write at a time. This > will correspond to a single process, but not necessarily a single > thread within that process. Mulithreaded access on a connection must > be serialized (or will be automatically, unless you defeat the > automatic thread seialization), but the transaction applies to the > connection and is not linked to the processID or threadID. > > --- > Theory is when you know everything but nothing works. Practice is when > everything works but no one knows why. Sometimes theory and practice > are combined: nothing works and no one knows why. > > > > > > _______________________________________________ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > Olivier Vidal <mailto:paxdo at mac.com> > 28 f?vrier 2015 20:02 > 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 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). > > According to your experience, it is reliable? Serialization is still > correctly performed through applications? > There are precautions to take? > > Thank you! > > Olivier > _______________________________________________ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
