Page 4 of 5

Re: Bayesian classifier for TTRSS

Posted: 19 Jun 2015, 00:27
by fox
png is a legit thing i guess i forgot to add it to git, as for the content thing read the thread.

e: https://tt-rss.org/forum/viewtopic.php? ... =15#p20105

Re: Bayesian classifier for TTRSS

Posted: 19 Jun 2015, 14:57
by nameless
Did that didn't help
For what i can tell i dont have ttrss_plugin_af_sort_bayes_references

this is what /z return

Code: Select all

 Schema |              Name              |   Type   | Access privileges | Column access privileges
--------+--------------------------------+----------+-------------------+--------------------------
 public | ttrss_access_keys              | table    |                   |
 public | ttrss_access_keys_id_seq       | sequence |                   |
 public | ttrss_archived_feeds           | table    |                   |
 public | ttrss_cat_counters_cache       | table    |                   |
 public | ttrss_counters_cache           | table    |                   |
 public | ttrss_enclosures               | table    |                   |
 public | ttrss_enclosures_id_seq        | sequence |                   |
 public | ttrss_entries                  | table    |                   |
 public | ttrss_entries_id_seq           | sequence |                   |
 public | ttrss_entry_comments           | table    |                   |
 public | ttrss_entry_comments_id_seq    | sequence |                   |
 public | ttrss_error_log                | table    |                   |
 public | ttrss_error_log_id_seq         | sequence |                   |
 public | ttrss_feed_categories          | table    |                   |
 public | ttrss_feed_categories_id_seq   | sequence |                   |
 public | ttrss_feedbrowser_cache        | table    |                   |
 public | ttrss_feeds                    | table    |                   |
 public | ttrss_feeds_id_seq             | sequence |                   |
 public | ttrss_filter_actions           | table    |                   |
 public | ttrss_filter_types             | table    |                   |
 public | ttrss_filters2                 | table    |                   |
 public | ttrss_filters2_actions         | table    |                   |
 public | ttrss_filters2_actions_id_seq  | sequence |                   |
 public | ttrss_filters2_id_seq          | sequence |                   |
 public | ttrss_filters2_rules           | table    |                   |
 public | ttrss_filters2_rules_id_seq    | sequence |                   |
 public | ttrss_labels2                  | table    |                   |
 public | ttrss_labels2_id_seq           | sequence |                   |
 public | ttrss_linked_feeds             | table    |                   |
 public | ttrss_linked_instances         | table    |                   |
 public | ttrss_linked_instances_id_seq  | sequence |                   |
 public | ttrss_plugin_storage           | table    |                   |
 public | ttrss_plugin_storage_id_seq    | sequence |                   |
 public | ttrss_prefs                    | table    |                   |
 public | ttrss_prefs_sections           | table    |                   |
 public | ttrss_prefs_types              | table    |                   |
 public | ttrss_sessions                 | table    |                   |
 public | ttrss_settings_profiles        | table    |                   |
 public | ttrss_settings_profiles_id_seq | sequence |                   |
 public | ttrss_tags                     | table    |                   |
 public | ttrss_tags_id_seq              | sequence |                   |
 public | ttrss_user_entries             | table    |                   |
 public | ttrss_user_entries_int_id_seq  | sequence |                   |
 public | ttrss_user_labels2             | table    |                   |
 public | ttrss_user_prefs               | table    |                   |
 public | ttrss_users                    | table    |                   |
 public | ttrss_users_id_seq             | sequence |                   |
 public | ttrss_version                  | table    |                   |

Re: Bayesian classifier for TTRSS

Posted: 19 Jun 2015, 15:11
by fox
i'm not sure wtf you're doing exactly but i can't imagine how would an insert query into nonexisting table fail because of a not-null constraint

i mean it's rather strange don't you think

e: are you sure you're connected to the right database

Re: Bayesian classifier for TTRSS

Posted: 19 Jun 2015, 17:56
by nameless
good observation, i actaully posted the tables of an old outdated db.
nevertheless i altered a table in the right database (i double checked) my issues still haven't resolved.

Re: Bayesian classifier for TTRSS

Posted: 19 Jun 2015, 18:06
by fox
maybe it still isnt the right db, try a few more times

Re: Bayesian classifier for TTRSS

Posted: 19 Jun 2015, 18:20
by nameless
it is. i checked my config.php

Re: Bayesian classifier for TTRSS

Posted: 20 Jun 2015, 11:25
by fox
so you're telling me you have error messages about inserts failing because of a constraint on a field which is not present in the database

you might need an exorcist

Re: Bayesian classifier for TTRSS

Posted: 23 Jun 2015, 18:51
by pcause
haven't turned this on yet and am curious as to how folks using it find it works.

Re: Bayesian classifier for TTRSS

Posted: 24 Jun 2015, 06:16
by rknobbe-other
pcause wrote:haven't turned this on yet and am curious as to how folks using it find it works.


Seems to work well for me, but training is a little slow on my PPC Mac Mini server. YMMV.

Tips:
  • Score lots of articles before expecting magic to happen.
  • Use "Default" Sort Article order, this incorporates the score into the sort order
  • Turn off "Group Headlines in virtual feeds"
  • Enjoy "Fresh Articles" showing those articles which ought to most closely match those that you've liked at the top of the list.

Another nice touch would be adding the like/dislike buttons to the Android app so you can score on the road (or on the toilet).

Anyway, seems to be doing exactly what it's supposed to be doing.

Re: Bayesian classifier for TTRSS

Posted: 24 Jun 2015, 10:31
by fox
i'm gonna link your post in the op

e: i guess you're the op and i hijacked your thread lol

Re: Bayesian classifier for TTRSS

Posted: 24 Jun 2015, 15:10
by pcause
Fox, I'd think that when I mark an article as publish or star it should be equivalent to clocking the thumbs up on the article. After all, if you are sharing or starring you must think the article is important in some way. Can the plugin add the capability to mark an article good if either of those actions happens?

Re: Bayesian classifier for TTRSS

Posted: 24 Jun 2015, 15:29
by fox
it could probably be an option in the plugin, i dunno

e: there's however no hook on star/unstar

Re: Bayesian classifier for TTRSS

Posted: 24 Jun 2015, 18:41
by pcause
I enabled the classifier and things seemed fine. Was going through feeds and marking things up/down for about 20+ minutes. I then got a message that my updater was not updating / taking too long in the browser. Killed the updater script and restarted but no difference. Started again, with logging and it seemed that the script would get to a feed and seem to stop updating. Killed again, did a force update and restarted. Got the the second feed and seemed to hang. Ran the top command on my linux box and postgresql is using 50% CPU. Killed update script, disabled the classifier and started update again and behavior is back to normal. I have all tt-rss updates from git as of yesterday. Postgresql is 9.3. Sorry I can't provide more information but nothing in any other log files.

Re: Bayesian classifier for TTRSS

Posted: 24 Jun 2015, 19:15
by fox
bayes stuff is rather slow (especially in the php + rdbms combination i imagine) so your server might not be up to task here.

there's a supposedly faster implementation which uses redis key/value store someone might adapt it instead.

Re: Bayesian classifier for TTRSS

Posted: 24 Jun 2015, 20:07
by pcause
Thanks for the information Fox. Guess I'll have to skip using this on my system.