#LyX 1.5.4 created this file. For more info see http://www.lyx.org/ \lyxformat 276 \begin_document \begin_header \textclass article \language english \inputencoding auto \font_roman default \font_sans default \font_typewriter default \font_default_family default \font_sc false \font_osf false \font_sf_scale 100 \font_tt_scale 100 \graphics default \paperfontsize default \papersize default \use_geometry false \use_amsmath 1 \use_esint 1 \cite_engine basic \use_bibtopic false \paperorientation portrait \secnumdepth 3 \tocdepth 3 \paragraph_separation indent \defskip medskip \quotes_language english \papercolumns 1 \papersides 1 \paperpagestyle default \tracking_changes false \output_changes false \author "" \end_header \begin_body \begin_layout Title FireStats RSS Statistics support \end_layout \begin_layout Part* Requirements \end_layout \begin_layout Itemize Be able to produce a reliable (As possible) subscribers count \end_layout \begin_layout Itemize Be able to create a breakdown of RSS readers used \end_layout \begin_layout Itemize WordPress integration \end_layout \begin_layout Itemize Simple to integrate with other systems that produce RSS feeds \end_layout \begin_layout Itemize Supports subscribers, feed-id and all that other non-standard crap \end_layout \begin_layout Itemize Keep enough data to create a graph of subscribers over time \end_layout \begin_layout Itemize Automatically archive old data to reduce database size \end_layout \begin_layout Standard Unlike regular hits, a raw log of RSS subscribers is not very interesting (because typically the polls are automated). \newline Subscribers table will have this form: \end_layout \begin_layout Standard \begin_inset Tabular \begin_inset Text \begin_layout Standard firestats_rss_subscribers \end_layout \end_inset \begin_inset Text \begin_layout Standard \end_layout \end_inset \begin_inset Text \begin_layout Standard \end_layout \end_inset \begin_inset Text \begin_layout Standard \end_layout \end_inset \begin_inset Text \begin_layout Standard \end_layout \end_inset \begin_inset Text \begin_layout Standard \end_layout \end_inset \begin_inset Text \begin_layout Standard \series bold name \end_layout \end_inset \begin_inset Text \begin_layout Standard idenitier \end_layout \end_inset \begin_inset Text \begin_layout Standard url_id \end_layout \end_inset \begin_inset Text \begin_layout Standard num subscribers \end_layout \end_inset \begin_inset Text \begin_layout Standard useragent id \end_layout \end_inset \begin_inset Text \begin_layout Standard time stamp \end_layout \end_inset \begin_inset Text \begin_layout Standard \series bold type \end_layout \end_inset \begin_inset Text \begin_layout Standard varchar(150) \end_layout \end_inset \begin_inset Text \begin_layout Standard int \end_layout \end_inset \begin_inset Text \begin_layout Standard int \end_layout \end_inset \begin_inset Text \begin_layout Standard int \end_layout \end_inset \begin_inset Text \begin_layout Standard datetime \end_layout \end_inset \begin_inset Text \begin_layout Standard \series bold comment \end_layout \end_inset \begin_inset Text \begin_layout Standard identifier, either a feed id or a textual ip address \end_layout \end_inset \begin_inset Text \begin_layout Standard url id in urls table \end_layout \end_inset \begin_inset Text \begin_layout Standard nubmer of subcribers for this feed. (from user agent or 1 if no count in useragent) \end_layout \end_inset \begin_inset Text \begin_layout Standard useragent id in useragents table \end_layout \end_inset \begin_inset Text \begin_layout Standard last access time for this subscriber \end_layout \end_inset \end_inset \end_layout \begin_layout Standard RSS archive will have this form: \end_layout \begin_layout Standard \begin_inset Tabular \begin_inset Text \begin_layout Standard firestats_subscribers_archive \end_layout \end_inset \begin_inset Text \begin_layout Standard \end_layout \end_inset \begin_inset Text \begin_layout Standard \end_layout \end_inset \begin_inset Text \begin_layout Standard \end_layout \end_inset \begin_inset Text \begin_layout Standard \end_layout \end_inset \begin_inset Text \begin_layout Standard \series bold name \end_layout \end_inset \begin_inset Text \begin_layout Standard range_id \end_layout \end_inset \begin_inset Text \begin_layout Standard url_id \end_layout \end_inset \begin_inset Text \begin_layout Standard useragent id \end_layout \end_inset \begin_inset Text \begin_layout Standard subscrivers count \end_layout \end_inset \begin_inset Text \begin_layout Standard \series bold type \end_layout \end_inset \begin_inset Text \begin_layout Standard int \end_layout \end_inset \begin_inset Text \begin_layout Standard int \end_layout \end_inset \begin_inset Text \begin_layout Standard int \end_layout \end_inset \begin_inset Text \begin_layout Standard int \end_layout \end_inset \begin_inset Text \begin_layout Standard \series bold comment \end_layout \end_inset \begin_inset Text \begin_layout Standard range id in ranges table \end_layout \end_inset \begin_inset Text \begin_layout Standard url id in urls table \end_layout \end_inset \begin_inset Text \begin_layout Standard useragent id in useragents table \end_layout \end_inset \begin_inset Text \begin_layout Standard sum of subscribers for the specified range, url_id and useragent_id \end_layout \end_inset \end_inset \end_layout \end_body \end_document