[Digikam-users] digikam and mysql

[Elle Stone]

Thanks, Gilles

Upon further investigation, it seems ubuntu lucid has some issues with
mysql, which I don't care to try to unravel at present time. So for
now I will stick with sqlite.

How many images can fit in sqlite database before there are scaling
problems? I doubt there are more than 20,000 images on my computer,
only 9,000 of which are currently in the digiKam sqlite database.

Warm regards,

Elle





On 7/17/10, Gilles Caulier <caulier.gilles at gmail.com> wrote:
> yes, digiKam 1.3.0 support Mysql now.
>
> As you run svn trunk (1.4.0), some littel fixes have been introduced.
>
> There is nothing to do. Just go to Database setup panel, and swith to
> QMYSQL (mysql driver for Qt4)
>
> You have 2 options : using mysql in local, or in remote.
>
> In local mode, digiKam will setup all for you. In remote, you need to
> run a mysql server somewhere on you network.
>
> The advantage of remote server, is to share DB with another digiKam
> session on another computer (as in photo agency for ex, which use a
> NAS to host collections)
>
> All the best
>
> Gilles Caulier
>
> 2010/7/17 Elle Stone <l.elle.stone at gmail.com>:
>> Hi digiKam users,
>>
>> When I set up my digiKam 10.4 database, I installed mysql first,
>> because I wanted to created the database with mysql instead of sqlite.
>> My understanding is that mysql will scale better and perhaps be more
>> reliable. True? I am not well-versed in mysql, or sqlite, or digiKam
>> for that matter.
>>
>> For some reason digiKam couldn't connect to mysql. Is mysql actually
>> supported yet? I searched the internet and found references to qmysql.
>> But on Lucid Ubuntu the closest program I could find is
>> libqt4-sql-mysql, which is also installed.
>>
>> I added myself to the mysql users with what I think is full
>> privileges. But I didn't create an empty database.
>>
>> Does digiKam create its own mysql database? Are there instructions
>> somewhere? Does using mysql with digiKam require a full kde
>> environment? I checked the users manual and searched the mailing list
>> but didn't find a digiKam-mysql "how to".
>>
>> Thanking you for any enlightenment
>>
>> Elle
>> _______________________________________________
>> 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
>