[Digikam-users] digikam and mysql

[Elle Stone]

Max and Gilles,

Wow, 100,000 images! I will happily proceed with sqlite.

Thanks!

Elle



On 7/17/10, Max Bedacht <bedachtm at gmail.com> wrote:
> I am currently running with about 100,000 images with no problems. I am
> using Ubuntu 10.04 and DigiKam 1.2.0
>
> Regards
>
> On Sat, Jul 17, 2010 at 10:13 AM, Elle Stone <l.elle.stone at gmail.com> wrote:
>
>> 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
>> >
>> _______________________________________________
>> Digikam-users mailing list
>> Digikam-users at kde.org
>> https://mail.kde.org/mailman/listinfo/digikam-users
>>
>