[Digikam-users] digikam and mysql

Max Bedacht bedachtm at gmail.com
Sat Jul 17 14:32:47 BST 2010


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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.kde.org/pipermail/digikam-users/attachments/20100717/3521ba59/attachment.html>


More information about the Digikam-users mailing list