Hi, Do you mean I shall use
int sqlite3_open_v2( const char *filename, /* Database filename (UTF-8) */ sqlite3 **ppDb, /* OUT: SQLite db handle */ int flags, /* Flags */ const char *zVfs /* Name of VFS module to use */ ); With the last argument "unix-dotfile". BTW I am using it just as one uses database and our app also has connectors to client/server RDBMS. We use sqlite in a mode where app is used for in a mode where only one process uses it and moreover the process is single threaded too. Regards, Prakash ________________________________________ From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] On Behalf Of Roger Binns [rog...@rogerbinns.com] Sent: Monday, June 14, 2010 8:30 AM To: General Discussion of SQLite Database Subject: Re: [sqlite] Locking issue on NFS filesystem -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 06/14/2010 02:56 AM, Prakash Reddy Bande wrote: > Our application is a simple desktop application with a simple install and run > setup. It is not possible to tell users to apply workaround of sharing the > drive via SMB etc. BTW SMB won't be much better than NFS. (A lot of things have to line up right.) You haven't specified if you are using SQLite because it is a convenient file format or because the transactions and durability matter. If it is the latter then you cannot use a networked filesystem. > I was hoping we have a way to enable dot file locking. It is available by default. Use "unix-dotfile" as the VFS name in your open call. Roger -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.10 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ iEYEARECAAYFAkwWIP8ACgkQmOOfHg372QT6YQCZAVqZLFg94FlljT7PkZz0jkxP RH8AoI2daz7YpQ3K7aYNVkG4Qpojqhdf =jh3O -----END PGP SIGNATURE----- _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
