Bug 233762

Summary: SETUP : Provide reasonable defaults and help for the database settings page
Product: [Applications] digikam Reporter: Johannes Wienke <languitar>
Component: Setup-DatabaseAssignee: Digikam Developers <digikam-bugs-null>
Status: RESOLVED FIXED    
Severity: wishlist CC: caulier.gilles
Priority: NOR    
Version: 1.3.0   
Target Milestone: ---   
Platform: Arch Linux   
OS: Unspecified   
Latest Commit: http://commits.kde.org/digikam/4a5e7cef1f15d62701a6fa7c1366f3303a687616 Version Fixed In: 5.0.0
Sentry Crash Report:

Description Johannes Wienke 2010-04-08 19:54:07 UTC 
Version:           trunk (using KDE 4.4.2)
Installed from:    Archlinux Packages

The new setup page to chose between the different database backends does not provide good defaults. If you initially switch to mysql from sqlite, no defaults are provided except for the schema names. They are filled with the location of the old sqlite database, which is completely wrong. Especially the port should be set to the default mysql port.

Moreover, no "What is" texts are defined. Some questions that need to be answered:
 * Why do I need to different schemas for data and thumbnails?
 * Can thumbnails-db and album-db be the same schema?
Comment 1 Johannes Wienke 2010-04-08 20:00:00 UTC 
I just noticed that an empty host name defaults to localhost. This should be visible in the gui.
Comment 2 Johannes Wienke 2010-04-08 20:00:59 UTC 
I just noticed that an empty host name defaults to localhost. This should be visible in the gui.
Comment 3 caulier.gilles 2011-12-15 09:47:00 UTC 
>Why do I need to different schemas for data and thumbnails?

To host DB thumbnails to a separate place. Whith huge collection, DB file will bloat quickly.

Gilles Caulier
Comment 4 Johannes Wienke 2011-12-15 09:48:35 UTC 
(In reply to comment #3)
> >Why do I need to different schemas for data and thumbnails?
> 
> To host DB thumbnails to a separate place. Whith huge collection, DB file will
> bloat quickly.

So add this to the tooltip. This will definitely help.
Comment 5 caulier.gilles 2015-11-20 15:15:42 UTC 
Git commit 4a5e7cef1f15d62701a6fa7c1366f3303a687616 by Gilles Caulier.
Committed on 20/11/2015 at 14:54.
Pushed by cgilles into branch 'master'.

New database setup config widget with more details about Mysql initial configuration and more help to tune settings.
The MySQl Internal is now handle as a main database type config.
Screenshots :

https://www.flickr.com/photos/digikam/23121578776
https://www.flickr.com/photos/digikam/23147681465
https://www.flickr.com/photos/digikam/22851871180
Related: bug 337443, bug 262321, bug 342124

FIXED-IN: 5.0.0

M  +2    -2    CMakeLists.txt
M  +4    -2    app/main/digikamapp.cpp
M  +7    -7    libs/album/albummanager.cpp
M  +3    -3    libs/database/coredb/coredbschemaupdater.cpp
M  +1    -1    libs/database/engine/dbenginebackend.cpp
M  +1    -1    libs/database/engine/dbengineguierrorhandler.cpp
M  +32   -32   libs/database/engine/dbengineparameters.cpp
M  +7    -7    libs/database/engine/dbengineparameters.h
M  +239  -134  libs/database/utils/dbsettingswidget.cpp
M  +22   -10   libs/database/utils/dbsettingswidget.h
M  +2    -2    libs/settings/applicationsettings.h
M  +6    -6    libs/settings/applicationsettings_database.cpp
M  +1    -1    tests/database/testdatabase.cpp
M  +14   -18   utilities/setup/setupdatabase.cpp

http://commits.kde.org/digikam/4a5e7cef1f15d62701a6fa7c1366f3303a687616