> SQLite allows multiple readers, or exactly one wrier, accessing the database > at the same time. You can't read and write simultaneously, you must arrange > for your connections to take turns. SQLITE_BUSY error is a signal for you to > back off, wait a little, then try again. See also > http://sqlite.org/c3ref/busy_timeout.html
A little correction to this: in latest version (3.7.0.1) with WAL journal mode SQLite can read old data while another connection writing. So things could be a little easier for you. Pavel On Wed, Aug 18, 2010 at 8:11 AM, Igor Tandetnik <itandet...@mvps.org> wrote: > andres felipe tamayo cortes <andrewt12...@hotmail.com> wrote: >> i have one application who reads a database, it run well without problems, >> but when i tried to load this dabase from other >> program (while its still running the first application), appearsme database >> blocked, isnt it possible to load one database from >> more than one programm at time? >> >> what i am tring to do its that one program reads the database while other >> program writes so the first program has to see what the >> second programs write. > > SQLite allows multiple readers, or exactly one wrier, accessing the database > at the same time. You can't read and write simultaneously, you must arrange > for your connections to take turns. SQLITE_BUSY error is a signal for you to > back off, wait a little, then try again. See also > http://sqlite.org/c3ref/busy_timeout.html > -- > Igor Tandetnik > > _______________________________________________ > 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
