Help proposal for Akregator

[Pablo Sanchez]

[ 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,
--
Pablo Sanchez - Blueoak Database Engineering, Inc
Ph:    819.459.1926        iNum:  883.5100.0990.1054