> I have not tried this with SQLite, but if I was using SQLite for such
> an app, I assume I would need to serialize all such writes through a
> single thread or process. E.g., in my web server, the connection
> thread servicing the user request would send a message to my one
> single db writer thread, saying, "Heh, please insert this data for
> me!". Then the conn thread would simply block until the db writer
> thread replies with, "Yup, your transaction is committed."
Why not just do it the same way other distributed systems do it?
As an example the ethernet card you're probably using right now.
If a card tries to transmit at the same time as another card on
the same network segment, they detect the collision, wait a
short period, and retry. As long as you have few writers and many
readers it works acceptably.
__________________________________
Do you Yahoo!?
Yahoo! Small Business - Try our new resources site!
http://smallbusiness.yahoo.com/resources/
