Search found 27 matches

by ldidry
16 Feb 2017, 12:19
Forum: Development
Topic: SQL improvment
Replies: 4
Views: 2760

Re: SQL improvment

thanks but please use the normal contribution process via gitlab Well, I followed the contribution instructions on https://tt-rss.org/gitlab/fox/tt-rss/wikis/HowToContribute : 1. Post your brilliant idea on the forums, ask to be given developer privileges. Preferably post diffs if you got them. Don...
by ldidry
16 Feb 2017, 11:04
Forum: Development
Topic: SQL improvment
Replies: 4
Views: 2760

SQL improvment

Hello, Informations : TTRSS 16.8 with PostgreSQL 9.1 and PHP7. I manage a TTRSS instance with 250 users and a SQL query in the update_feedbrowser_cache function (include/rssfuncs.php) is taking too much time and CPU. I managed to modify the query in order to reduce the query time from 1,387,000ms (y...
by ldidry
22 Jan 2017, 18:26
Forum: Unsupported platforms
Topic: How to migrate from MySQL to PostgreSQL?
Replies: 8
Views: 5439

Re: How to migrate from MySQL to PostgreSQL?

I didn't test it for a ttrss migration but used it for a Drupal MySQL to PostgreSQL migration but you may try pgloader (http://pgloader.io/).
by ldidry
14 Jan 2017, 14:12
Forum: Support
Topic: GoGomics removed RSS feeds for their comics !!
Replies: 20
Views: 7939

Re: GoGomics removed RSS feeds for their comics !!

Fetchs *only* the last comic.

My PR has been merged, so you can update your rss-bridge if you have one.
by ldidry
14 Jan 2017, 11:31
Forum: Support
Topic: GoGomics removed RSS feeds for their comics !!
Replies: 20
Views: 7939

Re: GoGomics removed RSS feeds for their comics !!

I think when I have some free time I'll make a bridge for gocomics with this, seems interesting. Don't bother, I just wrote one. I'll make a PR on github in a few minutes. But my bridge fetchs the last comic, so if you want to improve it, you're welcome :wink: https://github.com/ldidry/rss-bridge/b...
by ldidry
08 Sep 2016, 14:37
Forum: Everything else
Topic: Dedicated Server Recommendation
Replies: 11
Views: 5041

Re: Dedicated Server Recommendation

Nope, I'm not afraid. I never encountered any data corruption, and if there was, I'm using barman (http://pgbarman.org) to continuously backup the data, so I would be able to retrieve a safe backup anytime.
by ldidry
07 Sep 2016, 10:03
Forum: Everything else
Topic: Dedicated Server Recommendation
Replies: 11
Views: 5041

Re: Dedicated Server Recommendation

At Framasoft ( https://framasoft.org ), we provide 2 TTRSS instances (on https://framanews.org ). We are using a dedicated EX40SSD server ( https://www.hetzner.de/en/hosting/produkte_rootserver/ex40ssd ) (i7, 32GiB RAM, 2x256GiB disk) to host ±500 users, with a maximum number of 100 RSS feeds. I don...
by ldidry
10 Mar 2016, 12:54
Forum: Support
Topic: Is it possible to disable pgsql full-text search
Replies: 2
Views: 1473

Re: Is it possible to disable pgsql full-text search

Ok, thank you very much.
by ldidry
10 Mar 2016, 10:59
Forum: Support
Topic: Is it possible to disable pgsql full-text search
Replies: 2
Views: 1473

Is it possible to disable pgsql full-text search

Hello, I'm a member of Framasoft, an non-profit association that proposes, among other services, a free instance of TTRSS. We were running out of space on our server and I saw that the index for pgsql full-text search (ttrss_entries_tsvector_combined_idx) is taking a lot of place (±57GB). As I activ...
by ldidry
08 Dec 2013, 13:27
Forum: Support
Topic: Text cut off at UTF Emoticons
Replies: 7
Views: 2020

Re: Text cut off at UTF Emoticons

I saw a little heart in your message body in TTRSS. Maybe your database encoding isn't correct?
by ldidry
09 Oct 2013, 00:42
Forum: Support
Topic: Problem with 1.10 and lock files
Replies: 16
Views: 3934

Re: Problem with 1.10 and lock files

Simple : you have another update process which is already running. Your feeds take more than 15 minutes to update ; your cron launchs a new update which is aborted ; your first end ; you cron launchs a new update which goes well and so ever, and so ever. Try to change your cron to update every 30 mi...
by ldidry
12 Sep 2013, 16:35
Forum: Support
Topic: [1.9] - Stopped working on Chrome/Linux
Replies: 11
Views: 1798

Re: [1.9] - Stopped working on Chrome/Linux

Tested with Chromium 29.0.1547.57 Debian jessie/sid, I got no problems.
Extensions : Adblock Plus 1.5.5 and SPDY indicator 0.4.0
by ldidry
04 Sep 2013, 00:21
Forum: Support
Topic: Sync Thunderbird and TT-RSS
Replies: 80
Views: 16151

Re: Sync Thunderbird and TT-RSS

Really. I'd like to see a person for whom gmail filtering is somehow not enough. Me. Gmail is a fucking box of shit. I mean, 1/4 of my "spams" are real emails. Thank you Gmail. I hate Gmail for deciding "Oh, this mail looks important, let's tag it". Dude. I put an "importan...
by ldidry
01 Sep 2013, 21:33
Forum: Themes and plugins
Topic: Plugin master index on the wiki
Replies: 19
Views: 22611

Re: Plugin master index on the wiki

Here's a plugin to embed content from Tapastic rss streams :

https://github.com/ldidry/af_tapastic.git
by ldidry
30 Aug 2013, 02:42
Forum: Themes and plugins
Topic: My EnyoJS based UI for tt-rss
Replies: 20
Views: 13983

Re: My EnyoJS based UI for tt-rss

Try the second link, in the first page.

Go to advanced search