SQLite to become default backend (was: Fwd: Re: March/April KDE PIM summary blog post)

[Martin Steigerwald]

Hi there!

Yay! SQLite to become default backend in the future.

No more MariaDB or PostgreSQL database administration anymore.

I do hope that SQLite can run without user intervention.

Before any official announcement that SQLite is the new default backend,
consider on your own risk whether to switch just yet. FreeBSD developers
already switched and I heard reports that it is working well here as well.
But in case you like to be on the safe side, wait for any official
announcement I'd say, before you switch.

On systems I maintain I switched to SQLite on all systems that do not
make heavy use of Akonadi - i.e. where Thunderbird does mail. But on
the systems I use Akonadi heavily I use PostgreSQL. I am willing to 
switch to SQLite tough, as it would spare me the regular major upgrade
hassle.

Whether existing setups will be switched automatically I do not know.
Might be difficult to get right for all setups and may come unexpected.
If it can be done, probably better after asking first :)

Thanks,
Martin


----------  Weitergeleitete Nachricht  ----------

Betreff: Re: March/April KDE PIM summary blog post
Datum: Donnerstag, 27. April 2023, 09:09:32 CEST
Von: Daniel Vrátil <dvratil at kde.org>
An: kde-pim at kde.org

Hi,

# Akonadi

The SQLite support has been improved by enabling the WAL mode and disabling 
shared cache mode. I also removing old legacy code implemented to support 
ancient versions of SQLite. The intention is to remove the custom fork of the 
QSQLITE SQL driver that we had for over a decade, and make SQLite the default 
database backend in the near future. (Might be worth mentioning that FreeBSD 
has already taken the hint [0]).

A potential crash on shutdown has been fixed (BUG: 462692) as well as a curious 
race condition that was causing instabilities in our test suite.

# KOrganizer

Fixed some smaller issues in KOrganizer:

* it's now possible to copy events from read-only calendars (BUG: 415774)
* KOrganizer won't crash when you drag and event out side of the events view 
(BUG: 461413)
* Adding a new iCal calendar should now sync properly (BUG: 425460)

/Dan

[0] https://euroquis.nl//freebsd/2023/04/24/akonadi.html



On Tuesday, 25 April 2023 17:38:11 CEST Volker Krause wrote:
> Hello everyone,
> 
> it's time for the bi-monthly blog post again :)
> 
> If you have contributed in March or April, a summary of your most noteworthy
> changes would be helpful, bonus points for corresponding screenshots or
> links to already existing blog posts. If you noticed something noteworthy
> during the past two months, feel free to add that as well of course!
> 
> To help refresh your memories and to make sure we aren't missing anything
> important, there's two files attached here, an auto-generated detailed
> changelog (this tends to be 30-50% of the commits, using David F's changelog
> scripts for KF5 releases), and basic commit stats for the PIM repositories.
> 
> The last one was edited by me
> (https://volkerkrause.eu/2023/03/08/kde-pim-january-february-2023.html),
> any volunteers for this one?
> 
> Thanks for your help!
> Volker


-------------------------------------------------------------
-- 
Martin