On Tue, Oct 4, 2011 at 11:36 AM, Dungan, Kerry <kdun...@hpti.com> wrote:
> Thanks for the info, my database interfaces to an application that is > automatically reading/writing from/to the database, while the client side > gets information from and sends information to the application through the > database. There will be multiple clients. I may need to use a database like > mysql. > A client/server database engine (like mysql) is usually a better choice when you have multiple machines access the same database over a network. > > Thanks, > Kerry > ________________________________________ > From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on > behalf of Roger Binns [rog...@rogerbinns.com] > Sent: Tuesday, October 04, 2011 11:05 AM > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] sqlite3.OperationalError: disk I/O error > > -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA1 > > On 10/04/2011 06:34 AM, Dungan, Kerry wrote: > > At this point, I guess my next step is to figure out how to get this > fixed (any suggestions). > > Do not use SQLite with a networked file system. > > If there will only be one client so locking is not a big issue then there > are multiple alternative VFS as part of SQLite. You also need to specify > the alternate VFS when opening the database. The sqlite3 module that comes > with Python doesn't have that plumbed in so you can either recompile > it/SQLite to enable URI filenames by default or use APSW (disclosure I am > the APSW author). > > The alternate VFS are named unix-excl, unix-dotfile and unix-none. > > http://www.sqlite.org/vfs.html > http://www.sqlite.org/uri.html > > Roger > -----BEGIN PGP SIGNATURE----- > Version: GnuPG v1.4.11 (GNU/Linux) > > iEYEARECAAYFAk6LILoACgkQmOOfHg372QQWEQCghaNaRfCyFdX1m1iaZ3/V+sqb > zMsAoJ+StW0E/TNVV5g80EIHAIIT+5YP > =qHds > -----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 > -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
