Heads up for kdepim/kmail database change

--nextParthneWoFAeRPi2HI946nEPQw
Content-Transfer-Encoding: 7Bit
Content-Type: text/plain; charset="utf-8"; protected-headers="v1"
From: Michael <[email protected]>
To: [email protected]
Reply-To: [email protected]
Subject: Heads up for kdepim/kmail database change
Date: Sat, 06 Jun 2026 10:25:43 +0100
Message-ID: <[email protected]>
MIME-Version: 1.0

I came across news item "KDE PIM 26.04.1 default backend changes to 
sqlite" which explains the change of the default database used as a 
backend for kdepim.

The news item explains clearly what needs to be done to switch from 
mysql, or postgresql, to sqlite.

However, there is a potential sequence of actions which may trip you up:

If you are not logged in your desktop make sure you DO NOT run 'emerge 
--depclean' until you have first logged in and completed the akonadi 
database migration for each and every user on your system.  The 
migration to sqlite requires akonadi to be running using the existing 
SQL database.  The depclean option will remove a number of packages in 
use by akonadi and therefore akonadi will not be able to launch when you 
return to your desktop.  In this case you'll have to re-install the 
cleaned packages in order to restart akonadi.  The packages selected by 
depclean on my system were:

=================================================
>>> These are the packages that would be unmerged:

 virtual/mysql
    selected: 8.0 
   protected: none 
     omitted: none 

 dev-db/mariadb
    selected: 11.8.3-r2 
   protected: none 
     omitted: none 

 sys-libs/liburing
    selected: 2.9 
   protected: none 
     omitted: none 

 dev-perl/DBD-MariaDB
    selected: 1.240.0 
   protected: none 
     omitted: none 

 dev-db/mysql-init-scripts
    selected: 2.3-r8 
   protected: none 
     omitted: none 

 dev-perl/DBI
    selected: 1.647.0 
   protected: none 
     omitted: none 

 acct-user/mysql
    selected: 0-r3 
   protected: none 
     omitted: none 

 virtual/perl-Sys-Syslog
    selected: 0.360.0-r5 
   protected: none 
     omitted: none 

 dev-perl/PlRPC
    selected: 0.202.0-r4 
   protected: none 
     omitted: none 

 acct-group/mysql
    selected: 0-r3 
   protected: none 
     omitted: none 

 virtual/perl-Storable
    selected: 3.370.0 
   protected: none 
     omitted: none 

 dev-perl/Net-Daemon
    selected: 0.490.0 
   protected: none 
     omitted: none 

All selected packages: =virtual/mysql-8.0 =dev-db/mysql-init-
scripts-2.3-r8 =virtual/perl-Storable-3.370.0 =acct-group/mysql-0-r3 
=dev-perl/PlRPC-0.202.0-r4 =acct-user/mysql-0-r3 =dev-perl/DBD-
MariaDB-1.240.0 =dev-db/mariadb-11.8.3-r2 =sys-libs/liburing-2.9 =dev-
perl/Net-Daemon-0.490.0 =dev-perl/DBI-1.647.0 =virtual/perl-Sys-
Syslog-0.360.0-r5

>>> 'Selected' packages are slated for removal.
>>> 'Protected' and 'omitted' packages will not be removed.

Would you like to unmerge these packages? [Yes/No]    
========================================================

PS.  I always thought having to run a full blown mysql database just to 
read my emails was burdensome and unwelcome, especially on resource 
constrained systems.  I setup mysql years ago when KDE devs advised 
against using sqlite.  I found mysql buggy/unreliable, so I switched to 
postgresql instead.  However, in principle I preferred sqlite, which 
alas was not man enough for the job.  Having come full circle now, I am 
so far quite impressed by the performance of sqlite.  It appears to be 
faster and more responsive than mariadb has ever been, both on fast and 
slower PCs.
--nextParthneWoFAeRPi2HI946nEPQw
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: This is a digitally signed message part.
Content-Transfer-Encoding: 7Bit

-----BEGIN PGP SIGNATURE-----

iQJPBAABCAA5FiEEXqhvaVh2ERicA8Ceseqq9sKVZxkFAmoj55cbFIAAAAAABAAO
bWFudTIsMi41KzEuMTIsMiwyAAoJELHqqvbClWcZO24QANx0d/swO6M7Cv0IRYT2
gCv+xWVYdAz0ciD4RClAkykuI4EYpQcXrGZoigRDSkOfhp2mSRXs8zULFNoValmd
r3REPN+uS8+zia2aZ20stJjl5Pj9USaemHuaJykGszTdOtHkh/ZNirW3XW326Zwx
iamwvO9zbBYAmoZ0q8mRDCvA0TyLMaqT9oyB7QsZNAJp08kNjgcP0Lgn88qG3s5R
vaAdhyDU+WU4gkhvgqDZVl1GqI3xy4fY0JJuZuceRaWsUZgQ02xwerD2jKHpOxpc
VEDiZ1ynA/fQGfgO7GOkDe7xS2OQ8PFjIlM2Wsgae5YmF6/kXMtWNhXghxhCDlEb
dyKxFFBzZPCeECANv0VenSIxgaBQm9fcZDXnejgkVLfv8P48XVCMluxcFxtt4Zra
WiB+iHTQkKKc/V8W96JH4oB9yBzW4SvPzlcgpXmKHzRi8R0SBXAuvWEEMUfhYcGR
owq6sntbhmPJuSFy4sO3wbs95sqcGinNajXDvF9BNP6pp6KODsFLQc5dD4dkVtSb
kFYkAwoGa0kwK9IzGZ0ejLLDlkIBqMY3uYhtKJIyq0pnp08PYVXqxhMBVTasv+wP
xGWr5s8kj/hMAgBUPwU5/GQIYpX0FO2M6YSQvz5SJv45zmYKtQnZEtDKhUxIYqhH
3uE+vWS4baPcYqSBhuXF+5D/
=X09h
-----END PGP SIGNATURE-----

--nextParthneWoFAeRPi2HI946nEPQw--