KDEPIM with SQLite3
Hi!
As KDEPIM 24.12 comes to unstable, I thought I'd write something up
about this:
As I told before about KDEPIM 24.08 in experimental already: Using
SQLite3 as database engine I faced a great deal of improved performance.
The improvement has been impressive. And that compared to the already
probably faster than MariaDB PostgreSQL engine I was using.
I have been migrating the hard way. But there is a migrator available
meanwhile:
https://kontact.kde.org/blog/2024/2024-03-01-kde-pim-january-february-2024/
As far as I know this migrator is stable. However… I did not use it.
As SQLite3 is the new recommended engine, it might be good to migrate
at some point in time. But right now I can mostly only tell about my
own experience… so if someone feels adventurous, give it a try and please
report back. You help to get a clearer picture on how well it works in
general. If you rather like to keep your current engine… sure I fully
sympathize. Never change (and possibly break) a running system :)
I am at least happy not having to upgrade PostgreSQL clusters again.
SQLite3 should be pretty maintenance free. Digikam is using it. Firefox
is using it for a ton of things and so on…
In case you give it a try: *Make a backup first*! Ideally of your complete
home directory while Akonadi is not running. And probably also with
the import/export tool I mentioned before:
KDE PIM data exporter
https://lists.debian.org/debian-kde/2024/12/msg00065.html
--
Martin - please no carbon copy to me
Reply to: