Ok so speeking about network file system. 1 process with 2 threads that read/write DB file, is safe or not?
Do you think the SQLITE_THREADSAFE [1] in Thread-Safe or in Serialize mode can avoid network problem in this use case? Il 2016-08-05 14:52 Keith Medcalf ha scritto: > iSCSI is not shared network filesystem file system. > > iSCSI is a used to mount a local block file system using "SCSI over an IP > Network Cable". Without the i the iSCSI protocol is plain SCSI over a SCSI > Parallel Cable or sometimes (if you call it SAS) SCSI over a Serial Cable. > You can also have SCSI over Fibre Channel, SCSI over Token Ring, or probably > even SCSI over Avian Carriers. > > The issues with Network File Systems are with Network File Systems, not with > the method used to connect the physical block device to local computer. > >> -----Original Message----- >> From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] >> On Behalf Of Michele Pradella >> Sent: Friday, 5 August, 2016 00:31 >> To: sqlite-users@mailinglists.sqlite.org >> Subject: [sqlite] Network file system >> >> Hi all, I read documentation about using sqlite on a Network file >> system, so I know is not a good environment because file lock problem. >> Anyway do you think I can have the same problem if I'm sure that only my >> precess try write or read database? So I have just one process using >> network DB (for example an iSCSI), with more connections on the same >> database but just one process. Do you think this can result in >> corruptions? Do you have some experience about? >> _______________________________________________ >> sqlite-users mailing list >> sqlite-users@mailinglists.sqlite.org >> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users Links: ------ [1] https://www.sqlite.org/compile.html#threadsafe _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users