Help proposal for Akregator

[Pierre]

On Thursday, May 3, 2018 3:28:51 PM CEST Pablo Sanchez wrote:
> [ Comments below, in-line ]
> 
> On Thu, 03 May 2018 12:35:18 +0200, Pierre wrote:
> >> Are you planning to store the entire articles in the SQL database? I'm
> >> wondering how that's gonna scale with lots of large articles...
> > 
> > I plan to do that yes. I don't think it's going to be worse than
> > what we currently have (the Metakit files already store the entire
> > articles).  For huge archives (>2GB maybe ?) SQLite may hit some
> > limits and something stronger like PostgreSQL could be helpful.  But
> > I don't see how it could not be far better than our current
> > Metakit. I also think that the current system has huge performance
> > issues that we will solve using SQL queries to order articles
> > instead of fetching every article, filtering and sorting using
> > QSortFilterProxyModel. This will take a few months, but after I
> > write a data migration solution I hope to be quickly able to
> > demonstrate the final benefits using my archives.
> 
> Hi Pierre,
> 
> I can help you with the database side.  'Se habla' MySQL, PostgreSQL,
> etc.  ;)
> 
> If you're interested, you can email me directly and/or we can chat on
> IRC (pablo_s).
> 
> Cheers,

Hi

Thanks a lot for the offer.
I am a daytime PostgreSQL DBA so there is no problem with the big ones, I just 
don't have as much an extensive training on SQLite so far… So if you have deep 
knowledge of SQLite, that could come in handy.

Regards

 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/20180503/a4aeaa6b/attachment.sig>