[Digikam-devel] [Bug 127321] allow use of other database backends such as postgres and mysql

Gilles Caulier caulier.gilles at gmail.com
Wed Jul 22 07:14:26 BST 2009


https://bugs.kde.org/show_bug.cgi?id=127321





--- Comment #18 from Gilles Caulier <caulier gilles gmail com>  2009-07-22 08:14:25 ---
>[Field length]
>...paths are difficult to predict (260? No. 1024? 4096? Even longer?)
>In this cases, I would use a reasonable limit for that. Better we allocate more
>than lower space. (For the LONGTEXT there is an overhead of 4bytes per entry
>see http://dev.mysql.com/doc/refman/5.0/en/storage-requirements.html ).

Strings size limitation is a mess, since we host XMP strings in DB. XMP has no
size limitation.

Anyway, some strings has make and model are generally short (255 char is
enough)

But some other as all string dedicated to IPTC-core can be long, as
descriptions for photograph agencies workflow. Please take a care about.

Gilles Caulier

-- 
Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.



More information about the Digikam-devel mailing list