scripting/feedBase

Friday work

Opened this issue · 6 comments

scripting commented

Good morning feedBase followers! 🚀

More ground will be broken this morning, Murphy-willing.

Here's my next query.

select username from subscriptions where feedurl="http://scripting.com/rss.xml";

In case you are a SQL newbie as I was a few short days ago, what that means is show me the usernames of people who subscribe to Scripting News.

Back with a User Experience for this...

Dave

jystervinou commented

maybe adding some ORDER BY username, or ORDER BY whenupdated DESC so that the resulting list has some consistency, as more data will be available.

scripting commented

JY -- yes for sure! ;-)

scripting commented

Okay the "feed graph" is beginning to take shape. (Attn @DPurdy)

Here's a link to the page for Daring Fireball.

http://feedbase.io/?feedurl=http%3A%2F%2Fdaringfireball.net%2Ffeeds%2Fmain

Note that there's a list of subscribers. Click on one of their names.

http://feedbase.io/?username=davewiner

Now you see the feeds he's subscribed to.

You can click forever! ;-)

Note that the UNDEFINED column is for the follower count. My code isn't producing that value (yet) for these lists.

Lots of roughness, please no need to report. I just got this working and now have to go out for a meeting. But this is really starting to take shape beautifully.

scripting commented

I have uploaded the latest version of the server, v0.4.15, so @jystervinou we will have the same code to reference.

jystervinou commented

You can click forever! ;-)

Tell us when we can stop clicking! ;-P