Bug 233762 - SETUP : Provide reasonable defaults and help for the database settings page
Summary: SETUP : Provide reasonable defaults and help for the database settings page
Status: RESOLVED FIXED
Alias: None
Product: digikam
Classification: Applications
Component: Setup-Database (show other bugs)
Version: 1.3.0
Platform: Arch Linux Unspecified
: NOR wishlist
Target Milestone: ---
Assignee: Digikam Developers
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2010-04-08 19:54 UTC by Johannes Wienke
Modified: 2015-11-20 15:15 UTC (History)
1 user (show)

See Also:
Latest Commit:
Version Fixed In: 5.0.0
Sentry Crash Report:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
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