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
