Groups | Search | Server Info | Login | Register

Groups > linux.debian.maint.kde > #11988

KDEPIM with SQLite3

Show all headers | 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