[Qt-interest] QSQLITE and Network Shares

[Israel Brewster]

On Nov 22, 2009, at 8:01 AM, Gordon Schumacher wrote:
>>>
> Well, this is all true, and it's not true... this sounds like the
> byte-range locking issue; we ran into that too.
> I will vouch that switching away from SQLite is not always an option -
> in our case, we're limited by an environment where there's nowhere we
> could run the DB server app!
>
> You may, when building SQLite, define SQLITE_ENABLE_LOCKING_STYLE on  
> the
> command line.  I would suggest trying dot-file locking, or even *no*
> locking if you know you can get away with it.  The catch is, the  
> former
> kills your performance IIRC, and the latter is dangerous.  You may  
> have
> to look at implementing your own locking... *eww*


Thanks for the response. As it turned out, the problem was with the  
SQLite library included with Qt. After re-compiling Qt to use my  
system-sqlite, this problem went away. For what it's worth, the  
"system" SQLite I used was downloaded and compiled without any special  
LOCKING defines or anything, the only flags I gave to configure were -- 
prefix and --enable-static. So I didn't have to jump through any hoops  
there to get things working. I'm not sure what the SQLite library  
included with Qt does differently that breaks things, but no biggie  
since there is an easy solution. Besides, I suspect this is a somewhat  
unusual usage case, as most of the time if you want network you'll  
probably use a real DB server.

In my case, I really wanted this working because it creates a simple  
database environment. It doesn't take too much technical knowledge to  
set up a network share, and then with a nice GUI getting a "networked"  
database becomes dead simple. While MySQL or PostgreSQL (my  
preference) are WAY WAY better for this sort of thing, it takes more  
to get them set up. I like being able to give my users the choice-  
dead simple, but with caviats, or robust but not-so-simple.  
Thankfully, Qt makes the difference almost transparent when it comes  
to my code :-)
-----------------------------------------------
Israel Brewster
Computer Support Technician II
Frontier Flying Service Inc.
5245 Airport Industrial Rd
Fairbanks, AK 99709
(907) 450-7250 x293
-----------------------------------------------

-------------- next part --------------
A non-text attachment was scrubbed...
Name: Israel Brewster.vcf
Type: text/directory
Size: 417 bytes
Desc: not available
Url : http://lists.qt-project.org/pipermail/qt-interest-old/attachments/20091123/2f23566c/attachment.bin 
-------------- next part --------------