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

Marcel Wiesweg marcel.wiesweg at gmx.de
Wed Jul 22 19:25:24 BST 2009


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





--- Comment #21 from Marcel Wiesweg <marcel wiesweg gmx de>  2009-07-22 20:25:14 ---

> [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 ).

We can add info about a "minimum guaranteed field size" in our DBSCHEMA.ods
schema spec.
It feels good to say "no limit" but a maximum size of 4GB, in practice, is the
same.

>
> BTW: I have now an implementation, which is SQL injection save. I would checkin
> this as soon if I have a branch :)

All right go on

-- 
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