[sqlite] Does the Connection string support UNC paths?

2014-09-06 Thread Chris
I am old database programmer that just came across SQLite and am working on a small project for a PVR that uses SQLite as it's db provider. I try specifying a UNC path to the database for the datasource in the connection string and I get the following error, "unable to open database file". .

Re: [sqlite] Transactions for read operations

2014-09-06 Thread Keith Medcalf
No. Apache uses a worker process pool where each forked worker process contains one or more service threads. Each concurrent http operation is dispatched to a separate thread (which may only comprise one thread per process). The worker service model is serially entrant. So you would need

Re: [sqlite] Transactions for read operations

2014-09-06 Thread Simon Slavin
On 7 Sep 2014, at 3:49am, Keith Medcalf wrote: > You say "the database connection". Did you use the language imprecisely or > are you using only one database connection? One presumes that you may have > half-a-million pages and half-a-billion concurrent HTTP operations,

Re: [sqlite] Transactions for read operations

2014-09-06 Thread Darren Duncan
As a general principle, database transactions should be held for as short a time as possible. You should start your transaction, then do all of the operations immediately that need to be mutually consistent, and then end the transaction appropriately; ideally a transaction is only open for a

Re: [sqlite] Transactions for read operations

2014-09-06 Thread Keith Medcalf
On Saturday, 6 September, 2014, at 20:23, Richard Warburton inquired: >Brief: >Should transactions be used for ensuring consistency between multiple >queries? And if so, after I've finished is there a reason why I should >not call commit? >Background: >I'm

Re: [sqlite] Transactions for read operations

2014-09-06 Thread Simon Slavin
On 7 Sep 2014, at 3:22am, Richard Warburton wrote: > Should transactions be used for ensuring consistency between multiple > queries? Good idea. > And if so, after I've finished is there a reason why I should not > call commit? You should finish the

[sqlite] Transactions for read operations

2014-09-06 Thread Richard Warburton
Hi, Brief: Should transactions be used for ensuring consistency between multiple queries? And if so, after I've finished is there a reason why I should not call commit? Background: I'm using SQLite for a web service. The database reference is passed to Page objects, which handle their specific