Bayesian classifier for TTRSS

Development-related discussion, including bundled plugins
User avatar
fox
^ me reading your posts ^
Posts: 6318
Joined: 27 Aug 2005, 22:53
Location: Saint-Petersburg, Russia
Contact:

Re: Bayesian classifier for TTRSS

Postby fox » 19 Jun 2015, 00:27

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

nameless
Bear Rating Master
Bear Rating Master
Posts: 126
Joined: 28 Aug 2013, 20:33

Re: Bayesian classifier for TTRSS

Postby nameless » 19 Jun 2015, 14:57

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    |                   |

User avatar
fox
^ me reading your posts ^
Posts: 6318
Joined: 27 Aug 2005, 22:53
Location: Saint-Petersburg, Russia
Contact:

Re: Bayesian classifier for TTRSS

Postby fox » 19 Jun 2015, 15:11

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

nameless
Bear Rating Master
Bear Rating Master
Posts: 126
Joined: 28 Aug 2013, 20:33

Re: Bayesian classifier for TTRSS

Postby nameless » 19 Jun 2015, 17:56

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.

User avatar
fox
^ me reading your posts ^
Posts: 6318
Joined: 27 Aug 2005, 22:53
Location: Saint-Petersburg, Russia
Contact:

Re: Bayesian classifier for TTRSS

Postby fox » 19 Jun 2015, 18:06

maybe it still isnt the right db, try a few more times

nameless
Bear Rating Master
Bear Rating Master
Posts: 126
Joined: 28 Aug 2013, 20:33

Re: Bayesian classifier for TTRSS

Postby nameless » 19 Jun 2015, 18:20

it is. i checked my config.php

User avatar
fox
^ me reading your posts ^
Posts: 6318
Joined: 27 Aug 2005, 22:53
Location: Saint-Petersburg, Russia
Contact:

Re: Bayesian classifier for TTRSS

Postby fox » 20 Jun 2015, 11:25

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

pcause
Bear Rating Master
Bear Rating Master
Posts: 144
Joined: 23 Aug 2013, 19:52

Re: Bayesian classifier for TTRSS

Postby pcause » 23 Jun 2015, 18:51

haven't turned this on yet and am curious as to how folks using it find it works.

rknobbe-other
Bear Rating Trainee
Bear Rating Trainee
Posts: 13
Joined: 11 Jun 2015, 22:37

Re: Bayesian classifier for TTRSS

Postby rknobbe-other » 24 Jun 2015, 06:16

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.

User avatar
fox
^ me reading your posts ^
Posts: 6318
Joined: 27 Aug 2005, 22:53
Location: Saint-Petersburg, Russia
Contact:

Re: Bayesian classifier for TTRSS

Postby fox » 24 Jun 2015, 10:31

i'm gonna link your post in the op

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

pcause
Bear Rating Master
Bear Rating Master
Posts: 144
Joined: 23 Aug 2013, 19:52

Re: Bayesian classifier for TTRSS

Postby pcause » 24 Jun 2015, 15:10

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?

User avatar
fox
^ me reading your posts ^
Posts: 6318
Joined: 27 Aug 2005, 22:53
Location: Saint-Petersburg, Russia
Contact:

Re: Bayesian classifier for TTRSS

Postby fox » 24 Jun 2015, 15:29

it could probably be an option in the plugin, i dunno

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

pcause
Bear Rating Master
Bear Rating Master
Posts: 144
Joined: 23 Aug 2013, 19:52

Re: Bayesian classifier for TTRSS

Postby pcause » 24 Jun 2015, 18:41

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.

User avatar
fox
^ me reading your posts ^
Posts: 6318
Joined: 27 Aug 2005, 22:53
Location: Saint-Petersburg, Russia
Contact:

Re: Bayesian classifier for TTRSS

Postby fox » 24 Jun 2015, 19:15

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.

pcause
Bear Rating Master
Bear Rating Master
Posts: 144
Joined: 23 Aug 2013, 19:52

Re: Bayesian classifier for TTRSS

Postby pcause » 24 Jun 2015, 20:07

Thanks for the information Fox. Guess I'll have to skip using this on my system.


Return to “Development”

Who is online

Users browsing this forum: No registered users and 11 guests