As a quick search will reveal, many network file systems have broken locking. This can and will lead to database corruption as soon as more than one process attempts to write to the database because SQLite relies on file locking to implement transactions.
SQLite will happily open whatever path you provide for the database file. -----Ursprüngliche Nachricht----- Von: Richard Schülein [mailto:[email protected]] Gesendet: Montag, 24. Februar 2014 13:08 An: [email protected] Betreff: [sqlite] Network Storage Hi, i have an general question regarding SQLite and Network. As I can read here http://www.sqlite.org/cvstrac/wiki?p=SqliteNetwork there can be problems with that…. Do anybody have experience on that. We use SQLLite on an embedded Linuxsystem on an Audioserver which store his files on local harddisc and this device is also using SQLLite on the internal harddisc. Currently we think about to support also support for Network Storages (NAS, SMB-Share etc). Is there anything needed to store the Database itself on a shared network devices? In my opinion this is similar to an USB drive etc. That means, that the drive don’t even know, where the database is stored. Or is there really a difference between local storage and network storage from the view on the Database access? Best regards/Mit freundlichen Grüßen Richard Schülein Novel-Tech GmbH Am Krautgarten 4 D-91717 Wassertrüdingen Germany fon: +49 (0) 9832 / 706 814 fax: +49 (0) 9832 / 706 818 HRB 4282 Amtsgericht Ansbach www.noveltech.de <http://www.noveltech.de/> email: [email protected] USt-ID DE814809232 WEEE-Reg.Nr. DE82764730 _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ----------------------------------------------------------------------- Gunter Hick Software Engineer Scientific Games International GmbH Klitschgasse 2 – 4, A - 1130 Vienna, Austria FN 157284 a, HG Wien Tel: +43 1 80100 0 E-Mail: [email protected] This e-mail is confidential and may well also be legally privileged. If you have received it in error, you are on notice as to its status and accordingly please notify us immediately by reply e-mail and then delete this message from your system. Please do not copy it or use it for any purposes, or disclose its contents to any person as to do so could be a breach of confidence. Thank you for your cooperation. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
