{"id":346,"date":"2006-05-25T16:43:00","date_gmt":"2006-05-25T22:43:00","guid":{"rendered":"http:\/\/www.mooreds.com\/wordpress\/?p=346"},"modified":"2006-05-25T16:43:00","modified_gmt":"2006-05-25T22:43:00","slug":"bloglines-and-sql","status":"publish","type":"post","link":"https:\/\/www.mooreds.com\/wordpress\/archives\/346","title":{"rendered":"Bloglines and SQL"},"content":{"rendered":"<p>I moved from my own personal RSS reader (coded in perl by yours truly) to <a href='http:\/\/www.bloglines.com'>Bloglines<\/a> about a year ago.  The main reason is that Bloglines did everything my homegrown reader did and was free (in $ and in time to maintain it).  <\/p>\n<p>But with over <a href='http:\/\/www.bloglines.com\/about\/news#96'>1 billion articles served<\/a> as of Jan 2006, I always wondered why Bloglines didn&#8217;t do more collaborative filtering.  They do have a &#8216;related feeds&#8217; tab, but it doesn&#8217;t seem all that smart (though it does seem to get somewhat better as you have more subscribers).  I guess there are a number of possible reasons:<\/p>\n<ul>\n<li>It&#8217;s easier to find feeds that look like they&#8217;d be worth reading (I have 180 feeds that I attempt to keep track of)<\/li>\n<li>blogrolls provide much of this kind of filtering at the user level<\/li>\n<li>privacy concerns?<\/li>\n<li>No demand from users<\/li>\n<\/ul>\n<p>But <a href='http:\/\/radar.oreilly.com\/archives\/2006\/04\/database_war_stories_2_bloglin.html\n'>this article<\/a>, one of a series about data management in well known web applications, gives another possible answer: the infrastructure isn&#8217;t set up for easy querying.  Sayeth Mark Fletcher of bloglines:<\/p>\n<blockquote><p>As evidenced by our design, traditional database systems were not appropriate (or at least the best fit) for large parts of our system. There&#8217;s no trace of SQL anywhere (by definition we never do an ad hoc query, so why take the performance hit of a SQL front-end?), we resort to using external (to the databases at least) caches, and a majority of our data is stored in flat files.<\/p><\/blockquote>\n<p>Incidentally, all of the articles in the &#8216;Database War Stories&#8217; series are worth reading.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>I moved from my own personal RSS reader (coded in perl by yours truly) to Bloglines about a year ago. The main reason is that Bloglines did everything my homegrown [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[],"class_list":["post-346","post","type-post","status-publish","format-standard","hentry","category-technology"],"_links":{"self":[{"href":"https:\/\/www.mooreds.com\/wordpress\/wp-json\/wp\/v2\/posts\/346","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.mooreds.com\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.mooreds.com\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.mooreds.com\/wordpress\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.mooreds.com\/wordpress\/wp-json\/wp\/v2\/comments?post=346"}],"version-history":[{"count":0,"href":"https:\/\/www.mooreds.com\/wordpress\/wp-json\/wp\/v2\/posts\/346\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.mooreds.com\/wordpress\/wp-json\/wp\/v2\/media?parent=346"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.mooreds.com\/wordpress\/wp-json\/wp\/v2\/categories?post=346"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.mooreds.com\/wordpress\/wp-json\/wp\/v2\/tags?post=346"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}