Re: [sqlite] Do we need locking with multithread off ?

2012-03-17 Thread Roger Binns
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 16/03/12 22:50, Arnav Aggarwal wrote: I don't have any choice of using a different filesystem.. I'd suggest you write your own VFS then. You can choose exactly how locking is done. It isn't that much work and you can map to the exact semantics

Re: [sqlite] Do we need locking with multithread off ?

2012-03-17 Thread Arnav Aggarwal
On Sat, Mar 17, 2012 at 11:51 AM, Roger Binns rog...@rogerbinns.com wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 16/03/12 22:50, Arnav Aggarwal wrote: I don't have any choice of using a different filesystem.. I'd suggest you write your own VFS then. You can choose exactly how

[sqlite] brain failed: help needed

2012-03-17 Thread RhinosoRoss
Hi everyone, Sorry to be a pest, but I'm drowning in manual pages and clearly missing something simple. I don't think I'm going to progress without some help. I noticed at work that they were using excel to store serial numbers of devices sold in orders... Should be a database! So I knocked one

Re: [sqlite] brain failed: help needed

2012-03-17 Thread Puneet Kishor
You need LEFT JOIN. Also, keep in mind that no operator other than IS NULL or IS NOT NULL works on NULL. On Mar 17, 2012, at 9:06 AM, RhinosoRoss bosss...@hotmail.com wrote: Hi everyone, Sorry to be a pest, but I'm drowning in manual pages and clearly missing something simple. I don't

Re: [sqlite] brain failed: help needed

2012-03-17 Thread Richard Hipp
On Sat, Mar 17, 2012 at 10:06 AM, RhinosoRoss bosss...@hotmail.com wrote: Hi everyone, Sorry to be a pest, but I'm drowning in manual pages and clearly missing something simple. I don't think I'm going to progress without some help. I noticed at work that they were using excel to store

[sqlite] System.Data.SQLite backup API support

2012-03-17 Thread Levi Haskell
Hi, What is the easiest way to make use of SQLite backup API from System.Data.SQLite.dll mixed mode bundle, prefererably without recompiling it? AFAIK it's not supported directly yet, but is there a work around? Thank you, - Levi

Re: [sqlite] Do we need locking with multithread off ?

2012-03-17 Thread Arnav Aggarwal
On Sat, Mar 17, 2012 at 12:07 PM, Arnav Aggarwal arnav.aggarwal.2...@gmail.com wrote: On Sat, Mar 17, 2012 at 11:51 AM, Roger Binns rog...@rogerbinns.comwrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 16/03/12 22:50, Arnav Aggarwal wrote: I don't have any choice of using a

Re: [sqlite] Do we need locking with multithread off ?

2012-03-17 Thread Dan Kennedy
On 03/18/2012 11:26 AM, Arnav Aggarwal wrote: On Sat, Mar 17, 2012 at 12:07 PM, Arnav Aggarwal arnav.aggarwal.2...@gmail.com wrote: On Sat, Mar 17, 2012 at 11:51 AM, Roger Binnsrog...@rogerbinns.comwrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 16/03/12 22:50, Arnav Aggarwal