The behavior poses an unnecessary burden on users' storage devices, particularly solid state drives, which come with a finite amount of write capacity.
It's somewhat ironic that since SSDs are completely silent and so much faster at these sorts of writes, it's far easier for huge amounts of unneeded accesses to go unnoticed. The lack of disk activity lights on a lot of newer computers doesn't help matters either.
With spinning-platter drives and HDD lights, constant accesses would be very noticeable, both audibly and visually, and perhaps even more people would press for a fix sooner.
A few months ago I discovered that spotify was causing my laptop battery to drain whenever it was open and I was not using it. I didn't bother to dig into it further but I guess that's what was causing the problem. I don't use Spotify ever so I wound up deleting it.
It's a bug. They were issuing VACUUM to the SQLite database way too often. Which, apparently, reacreates the database from scratch, since SQLite is by design rather simplistic.
