[Digikam-users] Mysql/MariaDb database expert needs...

[Henrique Santos Fernandes]

Hello,

For the mysql itself there is no diference if it is internal or external.
Just use the network conection.

The permissions are the same for the user just need to grant all
privilegdes for the user.

Digikam could ask for two ways to begin, the first would be to already have
the user it needs to connect to the database. The second it could ask for
database admin user, in this case, digikam would create its users as it
needs. It makes the installating easier for the user, and also more secure
for the user digikam, so it will only have the permission it needs.

But i mean, i guess this is the easier part.. the hard part woould be the
actual use of mysql for storing stuff right?
I wish i knew mysql well enouh to help..

I prefere mysql cause it would be possible/easier to use digikam on
multiple computers with the same database!

Hope this goes forward!


Em qui, 12 de nov de 2015 às 10:02, Gilles Caulier <caulier.gilles at gmail.com>
escreveu:

> 2015-11-12 12:43 GMT+01:00 maderios <maderios at gmail.com>:
>
>> On 11/12/2015 11:18 AM, Pedro Neves wrote:
>>
>> I'm not an expert on databases or MySQL, but the explanation Gilles gave
>>> makes sense to me. I'm using SQlite and to me, it makes sense to only
>>> use MySQL as a remote storage.
>>> But that's only my opinion...
>>>
>> Hi
>> My experience: mysql is much better because it runs faster than sqlite,
>> especially  with huge images stock, > 20 000 or 30 000. In this last case,
>> Sqlite takes hours to rebuild db.
>
>
> yes, i agree. In fact 2 user cases :
>
> databases are local : sqlite : enough for small and medium collections.
> databases are remote : mysql : for large collections.
>
> Note that i use more than 100.000 items in my collections, hosted in a
> huge SDD (including sqlite databases files), and this work perfectly.
>
> Gilles
>
>
>>
>>
>> --
>> Maderios
>>
>> _______________________________________________
>> Digikam-users mailing list
>> Digikam-users at kde.org
>> https://mail.kde.org/mailman/listinfo/digikam-users
>>
> _______________________________________________
> Digikam-users mailing list
> Digikam-users at kde.org
> https://mail.kde.org/mailman/listinfo/digikam-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.kde.org/pipermail/digikam-users/attachments/20151112/5feaa76e/attachment.html>