Hi all, My question is: supposed NFS implementes fcntl() correctly, can multiple applications from different hosts access a single database file on NFS at the same time?
After reading http://www.sqlite.org/faq.html#q5 and http://www.sqlite.org/lockingv3.html carefully, I still cannot get a positive answer. I think the answer is: * SELECT is supported. * SQLite will automatically serialize any changes to the db, no extra action (eg. flock()) is needed by the user application. Eg. for python, I can execute the following actions on different hosts: conn = sqlite3.connect('/nfs/example') c = conn.cursor() c.execute("""insert into stocks values ('2006-01-05','BUY','RHAT',100,35.14)""") conn.commit() c.execute("""insert into stocks ....""") conn.commit() .... Please kindly confirm my thought. Thanks, Zhigang _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
