It boils down to that SQLite is working as intended as it can only rely on what the OS feeds it. As stated, the developers of SQLite are not going to be looking at network sharing as the responsibility of file locking is on the OS, not SQLite. Network sharing is tricky, and it "seems" seamless when used with SMB, Windows Client, and all that, however, there are workarounds in the back end (SMB/MSC) that gets around the limitations, such as writing files. Latency, even on a GigE network isn't nearly that of what is local. SQLite is NOT a full out database management system. This isn't its purpose in life. I think even MySQL recommends that its data stores not be put on a remote share.
In *MY* experience, I'm either randomly -reading- random bits of data from a file over a share, or, bulk transferring data in either direction by means of a file copy, or, watching a movie, listening to audio, etc, however, I'm only doing one operation on the file at once, not reading and writing to the same file from multiple sources. I don't recall ever randomly writing bits of data directly over a share, then expecting multiple remote machines to properly handle file locking since that is the responsibility of the machine holding the data. In all cases of data transfer I've done via network, its been a one-on-one communication. Heck, even back in the DOS days when relying on SHARE.EXE for proper file sharing between processes (Remember Desqview anyone?) even THAT was quite the pain! As of late, however, I've been trying to formulate a plan about how I can share data over the network in this regard, and the only one that I seem to have come up with is to backup or copy the file locally (Either by a standard file copy, or, SQLites Backup command), then when done, copy the file back. The problem starts hitting home when multiple sessions, or machines start poking at the data remotely and making changes. Whoever last writes the data wins, and that isn't exactly the best of environments. ;) I've also looked at making a client/server application for SQLite, but I end up going to MySQL at that point since I already have the ODBC installed locally. On Tue, Jan 8, 2013 at 5:36 AM, Raymond Meester <[email protected]>wrote: > Hi JCHD, > > Thnx for your notice. Of course I checked the AutoIt forum first. There is > indeed some discussion on this topic, but no solution that worked for me. I > also checked the solution by atensoft (actually I used this for a while, > but couldn't find out how to properly write a wrapper for it in > server/client configuration). Anyway I wrote with the default sqlite dll > and the default tcp Autoit libraries a server/client solution. As I said in > my first post this worked. > > The question however remains how can I keep using sqlite serverless on a > networkshare. The current implementation relies on calling directly the OS. > This doesn't work, so I wonder if the devs will make changes to avoid these > errors, instead of warning users the avoid a common use case scenario. > > Simon wrote > > > 2013/1/8 Jean-Christophe Deschamps <[email protected]> > > > Raymond, > > > > > > So I checked some server/client solutions from > >> http://www.sqlite.org/cvstrac/**wiki?p=SqliteNetwork< > http://www.sqlite.org/cvstrac/wiki?p=SqliteNetwork>. > >> But as there wasn't a > >> solution that supported my script > >> language (Autoit) I ended up writing my own server/client solution. This > >> worked for me, but I still have some questions regarding this issue: > >> > > > > I'm the de-facto maintainer of the SQLite AutoIt UDF. While the UDF > > currently relies on the standard SQLite .dll file I believe you could try > > using a variant library enriched with a TCP/IP client/server layer like > > this one: > > http://www.atensoft.com/dev/**sqlite3.php< > http://www.atensoft.com/dev/sqlite3.php> > > > > I never looked at it closely but I guess it would be fairly easy to make > a > > compatible wrapper around this version. > > > > Anyway I advise you browse the US AutoIt forum as there have been some > > discussions about such shared use. You can join me there as jchd (MVP) > and > > also on the french AutoIt forum (also jchd). > > > > > > ______________________________**_________________ > > sqlite-users mailing list > > [email protected] > > http://sqlite.org:8080/cgi-**bin/mailman/listinfo/sqlite-**users< > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users> > > > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
