Hi Alexis, you will be ok. However, make sure to handle the SQLITE_BUSY returncode in your apps correctly, and keep the write-transactions short and commit or rollbackt them all. Based on your data, a SQLITE_BUSY will be very unlikely, but you have to take it into account.
See also http://www.sqlite.org/c3ref/busy_timeout.html To answer your question: Yes, sqlite will insure sequestial write by using its locking nechanism. If there are many write operations however, the database will be locked often and other applications will be forced to wait for longer and longer times, which can become unaccepable to the people using you web application. Martin alexis_ wrote: > Hi Martin > > The Java Application will do all the write. PHP will only read. (Just out of > curiosity what would the implication be if both PHP and Java did write. > Wouldn’t SQLite insure sequential write?) > > As for Traffic: > Java could do 1 or 2 write's once a day. > PHP will be doing 2000 - 4000 reads a day. Mostly in the morning around > 08:30 and afternoon 17:00 > > Cheers > Alexis > > > Martin Engelschalk wrote: > >> Hi, >> >> the important question is: What about updates to the database? Will >> there be concurrent updates, or will the db be read only? Will some >> processes read an others write? What amount of traffic do you expect on >> the site? >> >> See http://www.sqlite.org/faq.html#q5 >> >> Martin >> >> alexis_ wrote: >> >>> Hi there, >>> >>> I am at the research stage of a project i have been asked to undertake. >>> >>> At the moment the O/S will be windows server 2003 and the web server IIS. >>> These are set and i cannot change them. >>> >>> I will be using PHP to deliver the web content to users and also a Java >>> application will be used to integrate to third party product. >>> >>> Both PHP and Java will be accessing a SQLite db concurrently. SQLite, >>> Java >>> App and php will all be on one box. So my questing is should this setup >>> work >>> OK? Is there anything i should be aware off. >>> >>> Thank you for any help, pointers >>> >>> Alexis >>> >>> >>> >>> >> _______________________________________________ >> 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
