Friday work

[scripting]

Good morning feedBase followers! :rocket:

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]

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]

JY -- yes for sure! ;-)

[scripting]

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]

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

[scripting]

Changes --

https://github.com/scripting/feedBase/commit/59ca2665294ab5953775061cff86f555b1cd85d7#diff-37ed9f574cf75afffb27a510967992f0

[jystervinou]

You can click forever! ;-)

Tell us when we can stop clicking! ;-P