Re: akonadi, mysql and sqlite

--nextPartb53HwQFSSPa-fvtUsvKvdQ
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: Re: [gentoo-user] akonadi, mysql and sqlite
Date: Thu, 18 Jun 2026 15:47:01 +0100
Message-ID: <[email protected]>
In-Reply-To: <[email protected]>
References: <[email protected]>
MIME-Version: 1.0

On Thursday, 18 June 2026 14:34:44 British Summer Time Peter Humphrey 
wrote:
> Greeings,
> 
> I've just found a reason not to switch to sqlite:
> 
> $ akonadictl vacuum
> Vacuum not supported for this database backend. (Sqlite backend)

It may need sqlite to have been built with USE="tools", or it may be 
akonadictl has/does not implement this function for sqlite.

However, if you shutdown kmail for good measure and then run:

sqlite3 ~/.local/share/akonadi/akonadi.db 'VACUUM;'

it seems to work.  :-/

With sqlite being the default database for kdepim, it is likely any 
needed features will be added as development progresses.


> Can I go back to mysql?

akonadi-db-migrator --newengine <ENGINE>

accepts the following values according to its --help page:

"sqlite", "mysql" and "postgres"


NOTES: 

1. Before you try to switch back to MySQL take a backup, just in case.

2. Set USE="mysql sqlite" and re-emerge dev-qt/qtbase and kde-apps/
akonadi-config.

Assuming the migration back to MySQL works, you can set USE="mysql 
-sqlite" for the above two packages.
--nextPartb53HwQFSSPa-fvtUsvKvdQ
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: This is a digitally signed message part.
Content-Transfer-Encoding: 7Bit

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

iQJPBAABCAA5FiEEXqhvaVh2ERicA8Ceseqq9sKVZxkFAmo0BOUbFIAAAAAABAAO
bWFudTIsMi41KzEuMTIsMiwyAAoJELHqqvbClWcZk4cQANInrKPlkQuOLHwNGuNO
rhEkGHJ8b13Whn0F2FMBwP47TLx9xwb/5RL9fEypT1EFkxgTInUZy/7vrva+GF66
eW66SUb1MjxPhh2dsgFIopU7Sb1OWuPa4gWVK4cXdsFBbdzbls+cb84aGj8+lrnz
hFcuU0pxjs0d138QIR0cU5/ow2FpTqyXRbcmzixBVVvwU5IoxTopTI0P0EQPKcJU
xkuG8rik0aocN2YtN67BbCfERB28aard2AFoSj2bYzWnCuh8o9vnXBHDqM19EK0Y
jLWSVoCsX8mSSra5ggd1/aBSjeysNjaGPpdU+YRA8sfIQJo0yvIPlKacRgwlHyQC
sOlKAMUe8zp+Rl1+lo/35pTuoRp2SXLSPoG1OIeUtGgM5Xfxh4G9XBk+M4LOEwU8
C31jphP0wxI6bp71O4DO+WRHy63reLtL2HDNVnlgz3yJMUs9Q60qY5hZfxRCojsu
pMGUwfTT1PY517MAKtllHcZIjIiRXoTHwM2ilQZ7s1jSzaUMzqK6xOZlMaExxCM0
o7aAMV2rlbvpx+Y8VYhKQSkTy7eM6Rwr3jIdfTVH7oW8OSzeG7jKlLnTEI2zM0Sq
cl4g92s81AXhLsLLP9OEyeqYnv7A+612JjcDKFxL0wxxM7gng7fOhggb1IdM+KP9
xkWqmdSNBP14M6lsxX5dACTT
=qvka
-----END PGP SIGNATURE-----

--nextPartb53HwQFSSPa-fvtUsvKvdQ--