Re: [sqlite] Exclusive transactions over network

2010-04-28 Thread Max Vlasov
Jean-Christophe, from my experience it depends. We have several clients accessing a database shared on a 2003 server and no corruption took place so far, but sometimes freezing of a client was possible. Also when I did some artificial tests, when several clients tried to write on a constant basis

[sqlite] Exclusive transactions over network

2010-04-27 Thread Jean-Christophe Deschamps
Hi gurus, I'm aware of the limitations that generally preclude using SQLite over a network. Anyway do you think that doing so with every read or write operation wrapped inside an explicit exclusive transaction can be a safe way to run a DB for a group of 10 people under low load (typically 2Kb