digikam and mysql

[Elle Stone]

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
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-users

[Gilles Caulier-4]

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 <[hidden email]>:

> 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
> [hidden email]
> https://mail.kde.org/mailman/listinfo/digikam-users
>

_______________________________________________
Digikam-users mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-users

[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 <[hidden email]> 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 <[hidden email]>:
>> 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
>> [hidden email]
>> https://mail.kde.org/mailman/listinfo/digikam-users
>>
> _______________________________________________
> Digikam-users mailing list
> [hidden email]
> https://mail.kde.org/mailman/listinfo/digikam-users
>

_______________________________________________
Digikam-users mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-users

[Gilles Caulier-4]

2010/7/17 Elle Stone <[hidden email]>:
> 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.

There is no real limit. I remember that some users handle more than
70.000 items with sqlite.

Probably some peoples play with more...

Gilles caulier
_______________________________________________
Digikam-users mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-users

[Max Bedacht]

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 <[hidden email]> 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 <[hidden email]> 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 <[hidden email]>:
>> 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
>> [hidden email]
>> https://mail.kde.org/mailman/listinfo/digikam-users
>>
> _______________________________________________
> Digikam-users mailing list
> [hidden email]
> https://mail.kde.org/mailman/listinfo/digikam-users
>
_______________________________________________
Digikam-users mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-users

_______________________________________________
Digikam-users mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-users

[Elle Stone]

Max and Gilles,

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

Thanks!

Elle



On 7/17/10, Max Bedacht <[hidden email]> 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 <[hidden email]> 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 <[hidden email]> 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 <[hidden email]>:
>> >> 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
>> >> [hidden email]
>> >> https://mail.kde.org/mailman/listinfo/digikam-users
>> >>
>> > _______________________________________________
>> > Digikam-users mailing list
>> > [hidden email]
>> > https://mail.kde.org/mailman/listinfo/digikam-users
>> >
>> _______________________________________________
>> Digikam-users mailing list
>> [hidden email]
>> https://mail.kde.org/mailman/listinfo/digikam-users
>>
>

_______________________________________________
Digikam-users mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-users

[Johannes Wienke-3]

Am 17.07.2010 15:51 schrieb Elle Stone:
> Wow, 100,000 images! I will happily proceed with sqlite.

From my experience I can say that the start-up time increases with the
number of images. I don't how how many thousand images I manage with
sqlite right now but starting already consumes a bit of time.

Johannes


_______________________________________________
Digikam-users mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-users

[Julien Narboux]

Hi,

I manage 60000 images using sqlite. The startup time is about 10 seconds.
But my albums do not have icons, I remember in old versions of Digikam having icons for many albums increased significantly the startup time. I don't know if this has been solved. Johannes, what do you mean by "a bit of time" ?

Julien


Le 17/07/2010 15:55, Johannes Wienke a écrit :

Am 17.07.2010 15:51 schrieb Elle Stone:
  

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

From my experience I can say that the start-up time increases with the
number of images. I don't how how many thousand images I manage with
sqlite right now but starting already consumes a bit of time.

Johannes

  

_______________________________________________
Digikam-users mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-users
  

_______________________________________________
Digikam-users mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-users

[Johannes Wienke-3]

Am 17.07.2010 16:47 schrieb Julien Narboux:
> I manage 60000 images using sqlite. The startup time is about 10 seconds.
> But my albums do not have icons, I remember in old versions of Digikam
> having icons for many albums increased significantly the startup time. I
> don't know if this has been solved. Johannes, what do you mean by "a bit

For me it was about one minute when the db was read. No album icons.


_______________________________________________
Digikam-users mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-users

[Gilles Caulier-4]

Johannes,

I think it's true at first startup in a KDE session. When you close
digiKam and restart it, it don't start more faster ?

Gilles Caulier

2010/7/17 Johannes Wienke <[hidden email]>:

> Am 17.07.2010 16:47 schrieb Julien Narboux:
>> I manage 60000 images using sqlite. The startup time is about 10 seconds.
>> But my albums do not have icons, I remember in old versions of Digikam
>> having icons for many albums increased significantly the startup time. I
>> don't know if this has been solved. Johannes, what do you mean by "a bit
>
> For me it was about one minute when the db was read. No album icons.
>
>
> _______________________________________________
> Digikam-users mailing list
> [hidden email]
> https://mail.kde.org/mailman/listinfo/digikam-users
>
>

_______________________________________________
Digikam-users mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-users

[Johannes Wienke-3]

Am 17.07.2010 17:43 schrieb Gilles Caulier:
> I think it's true at first startup in a KDE session. When you close
> digiKam and restart it, it don't start more faster ?

Somehow the caching didn't work since some months. May be related to the
mysql integration, but I am not sure and didn't have time to investigate
further.

Regards,
Johannes


_______________________________________________
Digikam-users mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-users