[KDE-pim] New Install: AKONADI wit PostgreSQL

[Erik Quaeghebeur]

On donderdag 31 december 2020 12:39:51 CET, Martin Steigerwald wrote:
> I think it is too much to ask from the user of a PIM suite to deal with 
> database administration tasks of any kind. […]

I agree. That is why I switched to the SQLite backend (it, also, is an 
improvement over the default MySQL). There are all kinds of warnings strewn 
around the internet that it isn't up to the task for Akonadi, but any 
issues I have are never reducible to SQLite. It's (failed) syncing to and 
from the remote that typically causes problems for me, because Akonadi 
doesn't seem capable of recovering. (It seems to use some out-of-database 
files thrown into the configuration directory for the backlog of unsynced 
local stuff…)

A PIM suite needs some database backend for searching and filtering. But 
something like SQLite should be up to the task in the single-user-at-a-time 
case. (‘Ad’ from sqlite.org: “For device-local storage with low writer 
concurrency and less than a terabyte of content, SQLite is almost always a 
better solution. SQLite is fast and reliable and it requires no 
configuration or maintenance. It keeps things simple. SQLite "just 
works".”) It is used in many applications that put quite some load on it. 
It includes many features that could be leveraged (views, triggers, full 
text search, json fields).

Focusing on just one database engine (SQLite, effectively an industry 
standard for non client-server relational databases) could reduce the 
maintenance burden on the developers and the upgrade woes of users, and 
could allow for using functionality specific to that engine that otherwise 
requires extra dependencies or custom code.


Just some New-Year's day opinions,

Erik