Akregator on SQLite − who wants to test ?

[Pierre]

Hi

As I said in a previous email, I've got now a fully working Akregator on 
SQLite, and I would like to know if anybody here would want to give it a try. 
I use Akregator quite a lot, but I'm sure I don't use every feature, and 
considering the changes there may be some regressions.
There is still from my point of view a lot to do (the models/views 
implementation is completely sub-optimal and fetches every article from the 
current feed, making it a huge bottleneck and memory-hog for big feeds), but 
the memory usage has been divided by 2 to 5 by removing the article 'caching' 
and allowing fetching a feed without loading every article. And I am not sure 
it would be wise to throw in a huge model/view refactoring, the changes are 
already quite extensive.

So, if you want to test, here's how. You will need QtSql and the SQLite driver 
of course.

git clone 
git://anongit.kde.org/clones/akregator/ducroquet/akregator.git
cd akregator
git checkout sqlstorage
mkdir build
cd build
cmake ..
make -j 8

If you don't want to do a full install, do that copy manually :
cp ../plugins/sqlstorage/akregator_sqlstorage_plugin.desktop ~/.local/share/
kservices5/akregator_sqlstorage_plugin.desktop

You will then have in the bin folder an akregatorstoragemigrator binary. You 
can launch it if you want to keep your current archives.
/bin/akregatorstoragemigrator metakit SQL
This will take some time (~3 minutes for 750000 articles)
Then you can alter manually your archive configuration
$EDITOR ~/.config/akregatorrc
Add the following

[Advanced]
Archive Backend=SQL

(Do not use the configuration dialog for that so far, it's completely 
unusable)

And now you can launch akregator
/bin/akregator


Feel free to report any bug or suggestion!

 Pierre
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 833 bytes
Desc: This is a digitally signed message part.
URL: <http://mail.kde.org/pipermail/kde-pim/attachments/20180508/a8ed7d0d/attachment.sig>