[Qt-interest] QSQLITE and Network Shares

[Bill King]

On 11/12/2009 04:50 AM, ext Israel Brewster wrote:
> On Nov 11, 2009, at 8:42 AM, Sylvain Pointeau wrote:
>
>> SQLite needs to put a lock on the file, but the network drives have
>> all a issue with that.
>> it is explained on the sqlite website.
>
> Thanks for the response. However, the problem can not be an inherent
> SQLite problem because, as I explained in my original message, the
> sqlite command-line utility works fine this way, even on the same file
> created by Qt. Actually, on the SQLite website it is explained that it
> SHOULD work just fine for low volume usage (which this obviously is)
> -that's why I am trying it. They do point out some caveats with
> windows or NFS shares, where it SOMETIMES (not always) doesn't work,
> but I am not using either. To quote (from
> http://www.sqlite.org/cvstrac/wiki?p=SqliteNetwork ):
>
> *Using SQLite on a Network*
>
> SQLite database files may be shared accross a network using a network
> filesystem.
>
>
> They go on to say it won't be particularly efficient (which I don't
> care about, at least at the moment), and that it may have problems
> with certain file systems (specified elsewhere as NFS and FAT, neither
> of which I am using), but the point is it should work. And does, at
> least from the command line. It is just Qt that has problems with
> this, at least on my system. So the question really is, is this an
> inherent problem with Qt, or just a problem with my build? Thanks for
> any help!
>
>>
>>
The problem is an sqlite problem. What you are seeing is that another
query has a lock open on the table, and your query is trying to elevate
it's lock status.

Seriously, I would consider a proper client/server database system
rather than trying to get what is essentially a single user system to
act in a networked fashion.
There are lots of free/zero config databases out there. try firebirdsql
for instance, or postgresql, both have very permissive licences, and
cost you nothing.

-- 
Bill King, Software Engineer
Qt Development Frameworks, Nokia Pty Ltd
Brisbane Office

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.qt-project.org/pipermail/qt-interest-old/attachments/20091116/452c7401/attachment.html