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.
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
