[Digikam-devel] sqlite and locking...

[Fabien]

Hi,

For people who want to test it, here's the patch (in attachment), for
file graphics/digikam/libs/sqlite3/sqlite3.c

I added some ifdef parts to disable afp blocks to be able to compile it
under linux (inspired by this patch :
<http://archive.netbsd.se/?ml=sqlite-users&a=2006-12&m=2872097>)

It would be great if those who had/have problems in the past using
digiKam on network storage or non-unix partitions could try it.

Thanks.


Fabien wrote:
> Now that sqlite is included in digikam kde3 svn, we have the ability to
>  have a standard behavior with it. Maybe it's the right moment to
> specify the options to prevent problems with locking on network file
> systems...
> 
> Look the following :
> 
> 1) SQLite lets you set a fixed locking style at compile-time by
> defining SQLITE_FIXED_LOCKING_STYLE to a value from its
> sqlite3LockingStyle enumeration...
> http://svn.haxx.se/dev/archive-2007-03/0121.shtml
> 
> 2) SQLite on NFS cache coherency :
> http://www.nabble.com/SQLite-on-NFS-cache-coherency-td15655701.html
> 
> 
> I think we should enable SQLITE_ENABLE_LOCKING_STYLE and set
> SQLITE_FIXED_LOCKING_STYLE to dotlockLockingStyle which is supported on
> all platforms...

--
Fabien
-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: patch_to_change_locking_style_in_sqlite3
URL: <http://mail.kde.org/pipermail/digikam-devel/attachments/20080703/03881203/attachment.ksh>