Be Excellent To Each Other
https://www.beexcellenttoeachother.com/forum/

Beex stats: posts and active posters per day
https://www.beexcellenttoeachother.com/forum/viewtopic.php?f=3&t=3414		 Page 10 of 10
Author:  Mr Russell [ Wed Sep 21, 2016 11:32 ]
Post subject:  Re: Beex stats: posts and active posters per day
I want Grim... to implement some kind of API so I can scrape the database and do graphs of people who were most active each month, or who talked about PCs the most over time, or who had the longest gaps between consecutive posts, things like that. It would be the awesome.
Author:  Grim... [ Wed Sep 21, 2016 11:34 ]
Post subject:  Re: Beex stats: posts and active posters per day
Be more specific, and I'll see what I can do.

Things about post contents (ie. "talking about PCs") are unlikely to happen though, because of the large amount of data involved.
Author:  myp [ Wed Sep 21, 2016 11:38 ]
Post subject:  Re: Beex stats: posts and active posters per day
Grim... wrote:
Be more specific, and I'll see what I can do.

Things about post contents (ie. "talking about PCs") are unlikely to happen though, because of the large amount of data involved.

That's loser talk. Up your game.
Author:  Cras [ Wed Sep 21, 2016 11:40 ]
Post subject:  Re: Beex stats: posts and active posters per day
The most important part of requirements gathering is the ability to reject bad requirements.
Author:  myp [ Wed Sep 21, 2016 11:42 ]
Post subject:  Re: Beex stats: posts and active posters per day
Cras wrote:
The most important part of requirements gathering is the ability to reject bad requirements.

You're a bad requirement
Author:  Mr Russell [ Wed Sep 21, 2016 11:42 ]
Post subject:  Re: Beex stats: posts and active posters per day
I'm a typical user. I don't know what I want until you give me the wrong thing.
Author:  Grim... [ Wed Sep 21, 2016 11:47 ]
Post subject:  Re: Beex stats: posts and active posters per day
Well, let's start with this:

Code:
http://www.beexcellenttoeachother.com/forum/api.php?f=

`f` can be one of `uid`, `userdeets` and `idandname`.

That's enough for you to use Beex as a login authenticator for other websites. I mean, I wouldn't recommend it, but that's how the calendar, MeatUp and Peex websites work.

So I guess the question is - what other data do you need to get your graphs?
Author:  Grim... [ Wed Sep 21, 2016 11:47 ]
Post subject:  Re: Beex stats: posts and active posters per day
I want inline code styling :(
Author:  Mr Russell [ Wed Sep 21, 2016 11:57 ]
Post subject:  Re: Beex stats: posts and active posters per day
Grim... wrote:
Well, let's start with this:

Code:
http://www.beexcellenttoeachother.com/forum/api.php?f=

`f` can be one of `uid`, `userdeets` and `idandname`.

That's enough for you to use Beex as a login authenticator for other websites. I mean, I wouldn't recommend it, but that's how the calendar, MeatUp and Peex websites work.

So I guess the question is - what other data do you need to get your graphs?

Heh, nice one.

I suppose for getting graphs it's more like running queries against the database, such as
Code:
SELECT TOP 50 AuthorName, PostCount from Posts where LastVisitedDate > @Date ORDER BY PostCount DESC
or
Code:
SELECT TOP 50 AuthorName, PostCount from Posts where PostDate BETWEEN @DateStart AND @DateEnd ORDER BY PostCount DESC
or
Code:
SELECT TOP 50 AuthorName, PostCount from Posts where PostContent LIKE '%' + @Keyword + '%' ORDER BY PostCount DESC
that kind of thing, and then I'd come up with queries depending on what whims I had, like posts as a percentage of totals or compared to other posters and things like that.
Author:  Grim... [ Wed Sep 21, 2016 12:03 ]
Post subject:  Re: Beex stats: posts and active posters per day
Call me insane, but I think allowing queries to be run against the database via an api isn't a smart idea ;)
Author:  myp [ Wed Sep 21, 2016 12:03 ]
Post subject:  Re: Beex stats: posts and active posters per day
No inner joins there, very disappointing.
Author:  Cras [ Wed Sep 21, 2016 12:04 ]
Post subject:  Re: Beex stats: posts and active posters per day
Grim... wrote:
Call me insane, but I think allowing queries to be run against the database via an api isn't a smart idea ;)


Who needs an API? Just have a text box on a page with ENTER YOUR SQL HERE AND I'LL RUN IT FOR YOU:
Author:  Grim... [ Wed Sep 21, 2016 12:07 ]
Post subject:  Re: Beex stats: posts and active posters per day
Why stop there? I could just exec some PHP, that way you can open up the server with `shell_exec()`.
Author:  devilman [ Wed Sep 21, 2016 12:08 ]
Post subject:  Re: Beex stats: posts and active posters per day
Joans wrote:
I need to up my game.

And post more.


I wasn't expecting to be where I was in the chart after not posting for three years. I guess it shows how little work I've done in the past. :)
Author:  Mr Russell [ Wed Sep 21, 2016 12:22 ]
Post subject:  Re: Beex stats: posts and active posters per day
Grim... wrote:
Call me insane, but I think allowing queries to be run against the database via an api isn't a smart idea ;)

Well that depends on how well written the API is:

Surely you'd just expose a service and let me pass in a parameter to that service, and then return JSON or XML though, not let me pass in my own SQL.
Author:  Grim... [ Wed Sep 21, 2016 12:24 ]
Post subject:  Re: Beex stats: posts and active posters per day
Mr Russell wrote:
Grim... wrote:
Call me insane, but I think allowing queries to be run against the database via an api isn't a smart idea ;)

Well that depends on how well written the API is

I think you'd have to consider the quality of the API to be quite high on a scale of "zero" to "oh my holy fuck what were you doing" to allow entire queries to be run.

Mr Russell wrote:
Surely you'd just expose a service and let me pass in a parameter to that service, and then return JSON or XML though, not let me pass in my own SQL.

Well, yes.

:boots:
Author:  TheVision [ Wed Sep 21, 2016 12:46 ]
Post subject:  Re: Beex stats: posts and active posters per day
Mr Russell wrote:
Attachment:
activeposters.png

Top 50 posters once you remove anyone who hasn't visited this year.


Has anyone made a "pull your trousers up!" joke to Trousers yet?
Author:  Curiosity [ Wed Sep 21, 2016 12:49 ]
Post subject:  Re: Beex stats: posts and active posters per day
TheVision wrote:
Mr Russell wrote:
Attachment:
activeposters.png

Top 50 posters once you remove anyone who hasn't visited this year.


Has anyone made a "pull your trousers up!" joke to Trousers yet?


We were waiting for you to do it.
Author:  Zardoz [ Wed Sep 21, 2016 12:55 ]
Post subject:  Re: Beex stats: posts and active posters per day
There used to be loads more pictures of DocG.
Author:  DavPaz [ Wed Sep 21, 2016 15:36 ]
Post subject:  Re: Beex stats: posts and active posters per day
devilman wrote:
Joans wrote:
I need to up my game.

And post more.


I wasn't expecting to be where I was in the chart after not posting for three years. I guess it shows how little work I've done in the past. :)

3 years? Blimey.
Author:  Trousers [ Wed Sep 21, 2016 16:53 ]
Post subject:  Re: Beex stats: posts and active posters per day
Curiosity wrote:
TheVision wrote:
Mr Russell wrote:
Attachment:
activeposters.png

Top 50 posters once you remove anyone who hasn't visited this year.


Has anyone made a "pull your trousers up!" joke to Trousers yet?


We were waiting for you to do it.


I shall makes great strides to be better.
Author:  Sir Taxalot [ Wed Sep 21, 2016 23:24 ]
Post subject:  Re: Beex stats: posts and active posters per day
DOOMED
Author:  Bobbyaro [ Thu Sep 22, 2016 12:28 ]
Post subject:  Re: Beex stats: posts and active posters per day
Trousers wrote:
Curiosity wrote:
TheVision wrote:
Mr Russell wrote:
Attachment:
activeposters.png

Top 50 posters once you remove anyone who hasn't visited this year.


Has anyone made a "pull your trousers up!" joke to Trousers yet?


We were waiting for you to do it.


I shall makes great strides to be better.

ISWYDT.
Page 10 of 10 All times are UTC [ DST ]
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group
http://www.phpbb.com/