KDEPIM with SQLite3

Path	csiph.com!fu-berlin.de!bofh.it!news.nic.it!robomod
From	Martin Steigerwald <martin@lichtvoll.de>
Newsgroups	linux.debian.maint.kde
Subject	KDEPIM with SQLite3
Date	Wed, 18 Dec 2024 18:50:01 +0100
Message-ID	<JV6lj-yjy-7@gated-at.bofh.it> (permalink)
X-Mailbox-Line	From debian-kde-request@lists.debian.org Wed Dec 18 17:46:13 2024
Old-Return-Path	<martin@lichtvoll.de>
X-Amavis-Spam-Status	No, score=-6.998 tagged_above=-10000 required=5.3 tests=[BAYES_00=-2, LDO_WHITELIST=-5, RCVD_IN_VALIDITY_CERTIFIED_BLOCKED=0.001, RCVD_IN_VALIDITY_RPBL_BLOCKED=0.001] autolearn=ham autolearn_force=no
Authentication-Results	mail.lichtvoll.de; auth=pass smtp.auth=martin@lichtvoll.de smtp.mailfrom=martin@lichtvoll.de
MIME-Version	1.0
Content-Transfer-Encoding	quoted-printable
Content-Type	text/plain; charset="utf-8"
X-Mailing-List	<debian-kde@lists.debian.org> archive/latest/41655
List-ID	<debian-kde.lists.debian.org>
List-URL	<https://lists.debian.org/debian-kde/>
List-Archive	https://lists.debian.org/msgid-search/1990536.PYKUYFuaPT@lichtvoll.de
Approved	robomod@news.nic.it
Lines	41
Organization	linux.* mail to news gateway
Sender	robomod@news.nic.it
X-Original-Date	Wed, 18 Dec 2024 18:45:54 +0100
X-Original-Message-ID	<1990536.PYKUYFuaPT@lichtvoll.de>
Xref	csiph.com linux.debian.maint.kde:11988

Show key headers only | View raw

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

Back to linux.debian.maint.kde | Previous | Next — Next in thread | Find similar

Thread

KDEPIM with SQLite3 Martin Steigerwald <martin@lichtvoll.de> - 2024-12-18 18:50 +0100
  Re: KDEPIM with SQLite3 Martin Steigerwald <martin@lichtvoll.de> - 2024-12-18 19:00 +0100
    Re: KDEPIM with SQLite3 Eike Lantzsch ZP5CGE / KY4PZ <zp6cge@gmx.net> - 2024-12-18 22:40 +0100
      Re: KDEPIM with SQLite3 Martin Steigerwald <martin@lichtvoll.de> - 2024-12-19 09:30 +0100
        Re: KDEPIM with SQLite3 Frank Mehnert <frank.mehnert@gmail.com> - 2024-12-21 18:10 +0100
          Re: KDEPIM with SQLite3 Martin Steigerwald <martin@lichtvoll.de> - 2024-12-21 19:10 +0100
            Re: KDEPIM with SQLite3 Hefee <hefee@debian.org> - 2024-12-21 20:00 +0100
            Fonts in message look "rough" (was: KDEPIM with SQLite3) Frank Mehnert <frank.mehnert@gmail.com> - 2024-12-22 12:20 +0100
              Re: Fonts in message look "rough" (was: KDEPIM with SQLite3) Martin Steigerwald <martin@lichtvoll.de> - 2024-12-22 12:40 +0100
              KMail: fonts in message view look "rough" (was: Re: KDEPIM with SQLite3) Martin Steigerwald <martin@lichtvoll.de> - 2024-12-22 12:30 +0100
                Re: KMail: fonts in message view look "rough" (was: Re: KDEPIM with SQLite3) Martin Steigerwald <martin@lichtvoll.de> - 2024-12-22 12:40 +0100
              Re: KMail: fonts in message view look "rough" Martin Steigerwald <martin@lichtvoll.de> - 2024-12-22 14:10 +0100
                Re: KMail: fonts in message view look "rough" Frank Mehnert <frank.mehnert@gmail.com> - 2024-12-22 17:00 +0100
                Re: KMail: fonts in message view look "rough" Dietz Pröpper <dietz@rotfl.franken.de> - 2024-12-22 17:10 +0100
                Re: KMail: fonts in message view look "rough" Frank Mehnert <frank.mehnert@gmail.com> - 2024-12-22 18:00 +0100
                Re: KMail: fonts in message view look "rough" Martin Steigerwald <martin@lichtvoll.de> - 2024-12-22 18:00 +0100
                Re: KMail: fonts in message view look "rough" Frank Mehnert <frank.mehnert@gmail.com> - 2024-12-22 18:20 +0100
                Re: KMail: fonts in message view look "rough" (upstream bug found) Martin Steigerwald <martin@lichtvoll.de> - 2024-12-22 19:10 +0100
                Re: KMail: fonts in message view look "rough" (upstream bug found) Luigi Toscano <luigi.toscano@tiscali.it> - 2024-12-23 00:20 +0100
                Re: KMail: fonts in message view look "rough" (upstream bug found,  fixed in Qt 6.8) Martin Steigerwald <martin@lichtvoll.de> - 2024-12-23 00:50 +0100
                Re: KMail: fonts in message view look "rough" Dietz Pröpper <dietz@rotfl.franken.de> - 2024-12-23 14:10 +0100
                Re: KMail: fonts in message view look "rough" (was: Re: KDEPIM with SQLite3) Frank Mehnert <frank.mehnert@gmail.com> - 2024-12-22 16:50 +0100
                  Re: KMail: fonts in message view look "rough" (was: Re: KDEPIM with SQLite3) Frank Mehnert <frank.mehnert@gmail.com> - 2024-12-22 17:00 +0100
                Re: KMail: fonts in message view look "rough" Martin Steigerwald <martin@lichtvoll.de> - 2024-12-22 17:00 +0100
            Re: KDEPIM with SQLite3 MERLIN Philippe <phil-deb1.merlin@laposte.net> - 2024-12-23 10:30 +0100
            Re: KDEPIM with SQLite3 Martin Steigerwald <martin@lichtvoll.de> - 2024-12-23 10:50 +0100
          Re: KDEPIM with SQLite3 Dietz Pröpper <dietz@rotfl.franken.de> - 2024-12-21 23:10 +0100
            Re: KDEPIM with SQLite3 yaros <yaros42@posteo.net> - 2025-01-13 11:00 +0100
            Re: KDEPIM with SQLite3 yaros <yaros42@posteo.net> - 2025-02-28 09:00 +0100
              Re: KDEPIM with SQLite3 Martin Steigerwald <martin@lichtvoll.de> - 2025-02-28 10:20 +0100
                Re: KDEPIM with SQLite3 Martin Steigerwald <martin@lichtvoll.de> - 2025-02-28 10:30 +0100
                Re: KDEPIM with SQLite3 Martin Steigerwald <martin@lichtvoll.de> - 2025-03-01 11:00 +0100

csiph-web