Be Excellent To Each Other

And, you know, party on. Dude.

All times are UTC [ DST ]




Reply to topic  [ 473 posts ]  Go to page Previous  1 ... 6, 7, 8, 9, 10  Next
Author Message
 Post subject: Re: Beex stats: posts and active posters per day
PostPosted: Fri Feb 19, 2016 12:35 
SupaMod
User avatar
Commander-in-Cheese

Joined: 30th Mar, 2008
Posts: 49232
Grim... wrote:
And for a lot of people using the Internet, "big" = "slow"


:hat:

_________________
GoddessJasmine wrote:
Drunk, pulled Craster's pork, waiting for brdyime story,reading nuts. Xz


Top
 Profile  
 
 Post subject: Re: Beex stats: posts and active posters per day
PostPosted: Fri Feb 19, 2016 12:38 
SupaMod
User avatar
Est. 1978

Joined: 27th Mar, 2008
Posts: 69507
Location: Your Mum
markg wrote:
Also that ignores any browser caching, in reality, after the first page most subsequent pages are a few tens of kb.

You can't cache script processing, though. I turned my cache on and hit up a random subpage, and it spent more than half a second on Scripting. Again, there was nothing on the page (beside the menu) that I could see that needed anything doing.

I'm going to stop now, because it looks like I'm having a go about your website, and I'm really not. I'm just saying that frameworks aren't efficient for the end user, and their popularity is a big reason as to why an average webpage is so big.

_________________
Grim... wrote:
I wish Craster had left some girls for the rest of us.


Top
 Profile  
 
 Post subject: Re: Beex stats: posts and active posters per day
PostPosted: Fri Feb 19, 2016 12:43 
User avatar

Joined: 30th Mar, 2008
Posts: 32619
Grim... wrote:
I'm just saying that frameworks aren't efficient for the end user, and their popularity is a big reason as to why an average webpage is so big.

On the other hand, suppose you are going to use 25% of the goodness of one of the big frameworks. Not a crappy bedroom project, but something solidly engineered. You have a choice: use 100% of the framework, or write the 25% yourself. Do you reckon you can write the 25% sufficiently well, on your own, that it's faster than loading 100% of the framework? In the process, will you avoid all the tricky security problems the framework folks have thought about that you've never heard of? Will you be as fast to write patches when new security problems are discovered? When you come to write v2 which needs something in the framework, taking you from 25% to 40%, will it take you months to build out the home-grown version rather than days to integrate some framework call that does the heavy lifting?

There's more factors at play than you're admitting here.


Top
 Profile  
 
 Post subject: Re: Beex stats: posts and active posters per day
PostPosted: Fri Feb 19, 2016 12:45 
User avatar
Gogmagog

Joined: 30th Mar, 2008
Posts: 48641
Location: Cheshire
Cras wrote:
Bamba wrote:
Cras wrote:
Not using Firefox is a good first step to resolving most issues.


Meh, I feel that's just giving a free pass to shite web development.


Kinda. But at the same time you're giving a free pass to shite browser development. It's like driving a car with square wheels and complaining about the state of the roads.


Heh. I was bitching like a sailor about the state of Bradford's road surfaces and then I found out the car had 2 snapped front coil springs.

_________________
Mr Chris wrote:
MaliA isn't just the best thing on the internet - he's the best thing ever.


Top
 Profile  
 
 Post subject: Re: Beex stats: posts and active posters per day
PostPosted: Fri Feb 19, 2016 12:46 
SupaMod
User avatar
Commander-in-Cheese

Joined: 30th Mar, 2008
Posts: 49232
Doctor Glyndwr wrote:
Grim... wrote:
I'm just saying that frameworks aren't efficient for the end user, and their popularity is a big reason as to why an average webpage is so big.

On the other hand, suppose you are going to use 25% of the goodness of one of the big frameworks. Not a crappy bedroom project, but something solidly engineered. You have a choice: use 100% of the framework, or write the 25% yourself. Do you reckon you can write the 25% sufficiently well, on your own, that it's faster than loading 100% of the framework? In the process, will you avoid all the tricky security problems the framework folks have thought about that you've never heard of? Will you be as fast to write patches when new security problems are discovered? When you come to write v2 which needs something in the framework, taking you from 25% to 40%, will it take you months to build out the home-grown version rather than days to integrate some framework call that does the heavy lifting?

There's more factors at play than you're admitting here.


Not really. What he said is exactly right. Frameworks aren't efficient for the end user, and they contribute to the size of a webpage. Your objection is from the perspective of the site author - which is fine, but not really particularly relevant.

_________________
GoddessJasmine wrote:
Drunk, pulled Craster's pork, waiting for brdyime story,reading nuts. Xz


Top
 Profile  
 
 Post subject: Re: Beex stats: posts and active posters per day
PostPosted: Fri Feb 19, 2016 12:48 
SupaMod
User avatar
Est. 1978

Joined: 27th Mar, 2008
Posts: 69507
Location: Your Mum
Doctor Glyndwr wrote:
Grim... wrote:
I'm just saying that frameworks aren't efficient for the end user, and their popularity is a big reason as to why an average webpage is so big.

On the other hand, suppose you are going to use 25% of the goodness of one of the big frameworks. Not a crappy bedroom project, but something solidly engineered. You have a choice: use 100% of the framework, or write the 25% yourself. Do you reckon you can write the 25% sufficiently well, on your own, that it's faster than loading 100% of the framework? In the process, will you avoid all the tricky security problems the framework folks have thought about that you've never heard of? Will you be as fast to write patches when new security problems are discovered? When you come to write v2 which needs something in the framework, taking you from 25% to 40%, will it take you months to build out the home-grown version rather than days to integrate some framework call that does the heavy lifting?

There's more factors at play than you're admitting here.

Oh, absolutely, but that's still all stuff that the end user couldn't care less about. I'm just saying all that shit be big.

(Also - yes ;) Also also - frameworks can cause as many problems as they solve, as I'm sure you've found out - mainly when you ask them to do something and they can't, so you have to add it yourself, then maintain it, etc, etc. Don't think I don't use them all the time, though. Libraries, too - I'm trying to wean myself off jQuery because it's fucking awful but I can't help myself)

_________________
Grim... wrote:
I wish Craster had left some girls for the rest of us.


Top
 Profile  
 
 Post subject: Re: Beex stats: posts and active posters per day
PostPosted: Fri Feb 19, 2016 12:49 
User avatar

Joined: 30th Mar, 2008
Posts: 32619
Cras wrote:
Not really. What he said is exactly right. Frameworks aren't efficient for the end user, and they contribute to the size of a webpage. Your objection is from the perspective of the site author - which is fine, but not really particularly relevant.

End users care just as much about how long it takes to write features and security, albeit indirectly. ("Why can't I do X" and "what the fuck you lost my credit card details?")

I think Grim...'s argument is against shit frameworks, rather than frameworks in general. Maybe all JavaScript frameworks are shit. Certainly, hardly any of them appear to be old enough to credibly claim to have matured out of the half-baked-stuff-thrown-on-github stage.


Top
 Profile  
 
 Post subject: Re: Beex stats: posts and active posters per day
PostPosted: Fri Feb 19, 2016 12:50 
SupaMod
User avatar
Est. 1978

Joined: 27th Mar, 2008
Posts: 69507
Location: Your Mum
Doctor Glyndwr wrote:
Cras wrote:
Not really. What he said is exactly right. Frameworks aren't efficient for the end user, and they contribute to the size of a webpage. Your objection is from the perspective of the site author - which is fine, but not really particularly relevant.

End users care just as much about how long it takes to write features and security, albeit indirectly.

I don't think they do. Remember that the end users aren't people like us :)

They might care about those things, but they don't give a fuck how you do them.

_________________
Grim... wrote:
I wish Craster had left some girls for the rest of us.


Top
 Profile  
 
 Post subject: Re: Beex stats: posts and active posters per day
PostPosted: Fri Feb 19, 2016 12:51 
Awesome
User avatar
Yes

Joined: 6th Apr, 2008
Posts: 12243
What's your take on a modular framework then, where you can strip out guff you don't need before downloading?

_________________
Always proof read carefully in case you any words out


Top
 Profile  
 
 Post subject: Re: Beex stats: posts and active posters per day
PostPosted: Fri Feb 19, 2016 12:52 
SupaMod
User avatar
Est. 1978

Joined: 27th Mar, 2008
Posts: 69507
Location: Your Mum
Mr Russell wrote:
What's your take on a modular framework then, where you can strip out guff you don't need before downloading?

The same, I guess, but not as bad.

Mind you, who doesn't just tick everything?

_________________
Grim... wrote:
I wish Craster had left some girls for the rest of us.


Top
 Profile  
 
 Post subject: Re: Beex stats: posts and active posters per day
PostPosted: Fri Feb 19, 2016 12:53 
SupaMod
User avatar
Commander-in-Cheese

Joined: 30th Mar, 2008
Posts: 49232
Mr Russell wrote:
What's your take on a modular framework then, where you can strip out guff you don't need before downloading?


Definitely better. But how many devs do strip out the guff? How many know to, especially when they're using a third party component that utilises that framework?

_________________
GoddessJasmine wrote:
Drunk, pulled Craster's pork, waiting for brdyime story,reading nuts. Xz


Top
 Profile  
 
 Post subject: Re: Beex stats: posts and active posters per day
PostPosted: Fri Feb 19, 2016 12:54 
Awesome
User avatar
Yes

Joined: 6th Apr, 2008
Posts: 12243
Also relatedly Grim..., what did you use to detect the unused css styles?

_________________
Always proof read carefully in case you any words out


Top
 Profile  
 
 Post subject: Re: Beex stats: posts and active posters per day
PostPosted: Fri Feb 19, 2016 12:54 
User avatar

Joined: 30th Mar, 2008
Posts: 32619
Grim... wrote:
I don't think they do. Remember that the end users aren't people like us :)

They might care about those things, but they don't give a fuck how you do them.

I added more in an edit.

Quote:
("Why can't I do X" and "what the fuck you lost my credit card details?")


Top
 Profile  
 
 Post subject: Re: Beex stats: posts and active posters per day
PostPosted: Fri Feb 19, 2016 13:00 
SupaMod
User avatar
Est. 1978

Joined: 27th Mar, 2008
Posts: 69507
Location: Your Mum
Doctor Glyndwr wrote:
Grim... wrote:
I don't think they do. Remember that the end users aren't people like us :)

They might care about those things, but they don't give a fuck how you do them.

I added more in an edit.

Quote:
("Why can't I do X" and "what the fuck you lost my credit card details?")

They still don't care how those things are done, though.

_________________
Grim... wrote:
I wish Craster had left some girls for the rest of us.


Top
 Profile  
 
 Post subject: Re: Beex stats: posts and active posters per day
PostPosted: Fri Feb 19, 2016 13:00 
SupaMod
User avatar
Commander-in-Cheese

Joined: 30th Mar, 2008
Posts: 49232
Doctor Glyndwr wrote:
Cras wrote:
Not really. What he said is exactly right. Frameworks aren't efficient for the end user, and they contribute to the size of a webpage. Your objection is from the perspective of the site author - which is fine, but not really particularly relevant.

End users care just as much about how long it takes to write features and security, albeit indirectly. ("Why can't I do X" and "what the fuck you lost my credit card details?")

I think Grim...'s argument is against shit frameworks, rather than frameworks in general. Maybe all JavaScript frameworks are shit. Certainly, hardly any of them appear to be old enough to credibly claim to have matured out of the half-baked-stuff-thrown-on-github stage.


I don't think it's about shit frameworks. It's about making the right choices.

Take the earlier example of Wordpress (like Grim..., I'm not dissing Wordpress or Wordpress sites - but it's an example of a tool that without competent oversight, is a bloat monster). You can use Wordpress to throw together a highly functional, good looking site in not much time. But if the dev is only looking to do that, and doesn't have the skills/experience/time/budget to get strong performance out of it, chances are it will be loaded with a load of unnecessary guff that hits performance. And there's a lot of devs out there whose prime driver is time to market, and nothing else.

_________________
GoddessJasmine wrote:
Drunk, pulled Craster's pork, waiting for brdyime story,reading nuts. Xz


Top
 Profile  
 
 Post subject: Re: Beex stats: posts and active posters per day
PostPosted: Fri Feb 19, 2016 13:04 
SupaMod
User avatar
Est. 1978

Joined: 27th Mar, 2008
Posts: 69507
Location: Your Mum
Mr Russell wrote:
Also relatedly Grim..., what did you use to detect the unused css styles?

A mess of JavaScript that I bunged into the console.

There's almost certainly plugins that can do the same thing, though.

_________________
Grim... wrote:
I wish Craster had left some girls for the rest of us.


Top
 Profile  
 
 Post subject: Re: Beex stats: posts and active posters per day
PostPosted: Fri Feb 19, 2016 13:05 
SupaMod
User avatar
Est. 1978

Joined: 27th Mar, 2008
Posts: 69507
Location: Your Mum
Here's one:
https://chrome.google.com/webstore/deta ... ikfgnngeik

[edit] Oh, 2 stars out of 5. Maybe not that one, then.

_________________
Grim... wrote:
I wish Craster had left some girls for the rest of us.


Top
 Profile  
 
 Post subject: Re: Beex stats: posts and active posters per day
PostPosted: Fri Feb 19, 2016 13:07 
SupaMod
User avatar
Est. 1978

Joined: 27th Mar, 2008
Posts: 69507
Location: Your Mum
Obviously having the one argument isn't enough, so I'm also going to say that Bootstrap is the fucking Devil, for pretty much the exact same reasons.

_________________
Grim... wrote:
I wish Craster had left some girls for the rest of us.


Top
 Profile  
 
 Post subject: Re: Beex stats: posts and active posters per day
PostPosted: Fri Feb 19, 2016 13:10 
Awesome
User avatar
Yes

Joined: 6th Apr, 2008
Posts: 12243
Grim... wrote:
Mr Russell wrote:
Also relatedly Grim..., what did you use to detect the unused css styles?

A mess of JavaScript that I bunged into the console.

There's almost certainly plugins that can do the same thing, though.

Oh ok, fair enough. I use the browser link and web essentials if I'm doing it in Visual Studio for a site, but didn't know of anything that could do it for a published site.

_________________
Always proof read carefully in case you any words out


Top
 Profile  
 
 Post subject: Re: Beex stats: posts and active posters per day
PostPosted: Fri Feb 19, 2016 13:11 
SupaMod
User avatar
Est. 1978

Joined: 27th Mar, 2008
Posts: 69507
Location: Your Mum
Turns out the Chrome Audit tab does it, too (this page has 87).

If you're interested in performance, I highly recommend getting to grips with Chrome's Timeline and Profiling capabilities, which are complicated but astoundingly powerful.

_________________
Grim... wrote:
I wish Craster had left some girls for the rest of us.


Top
 Profile  
 
 Post subject: Re: Beex stats: posts and active posters per day
PostPosted: Fri Feb 19, 2016 13:44 
Awesome
User avatar
Yes

Joined: 6th Apr, 2008
Posts: 12243
Grim... wrote:
Turns out the Chrome Audit tab does it, too (this page has 87).

If you're interested in performance, I highly recommend getting to grips with Chrome's Timeline and Profiling capabilities, which are complicated but astoundingly powerful.


I've seen the Chrome audit tab, but it only does the current page, which means you have to cross reference every page on the site to find that rule that's only used in one popup three screens deep or something.

Just had a look at the timeline tab. It's a bit like the yslow type analysis, I like it - cheers.

_________________
Always proof read carefully in case you any words out


Top
 Profile  
 
 Post subject: Re: Beex stats: posts and active posters per day
PostPosted: Fri Feb 19, 2016 13:51 
SupaMod
User avatar
Est. 1978

Joined: 27th Mar, 2008
Posts: 69507
Location: Your Mum
Mr Russell wrote:
I've seen the Chrome audit tab, but it only does the current page, which means you have to cross reference every page on the site to find that rule that's only used in one popup three screens deep or something.

Ah yes, you would indeed. Take a look at this: https://addyosmani.com/blog/removing-unused-css/

_________________
Grim... wrote:
I wish Craster had left some girls for the rest of us.


Top
 Profile  
 
 Post subject: Re: Beex stats: posts and active posters per day
PostPosted: Fri Feb 19, 2016 14:02 
Awesome
User avatar
Yes

Joined: 6th Apr, 2008
Posts: 12243
Grim... wrote:
Mr Russell wrote:
I've seen the Chrome audit tab, but it only does the current page, which means you have to cross reference every page on the site to find that rule that's only used in one popup three screens deep or something.

Ah yes, you would indeed. Take a look at this: https://addyosmani.com/blog/removing-unused-css/


They all look to be ones where you have access to the code that controls the site of course. I'm happy with my solution for that*, I just didn't know if you had something whizzy for doing other people's sites. Thanks for the links though, and especially the chrome stuff. Chrome has a lot of nifty stuff built in, and I find myself using it more and more recently.

*Web essentials in Visual Studio in case you missed my earlier post.

_________________
Always proof read carefully in case you any words out


Top
 Profile  
 
 Post subject: Re: Beex stats: posts and active posters per day
PostPosted: Fri Feb 19, 2016 14:16 
User avatar

Joined: 30th Mar, 2008
Posts: 32619
Grim... wrote:
Obviously having the one argument isn't enough, so I'm also going to say that Bootstrap is the fucking Devil, for pretty much the exact same reasons.

Of course it is, it's written in JavaScript. If you lie down with dogs, you get up with fleas.


Top
 Profile  
 
 Post subject: Re: Beex stats: posts and active posters per day
PostPosted: Fri Feb 19, 2016 14:40 
SupaMod
User avatar
Est. 1978

Joined: 27th Mar, 2008
Posts: 69507
Location: Your Mum
Mr Russell wrote:
They all look to be ones where you have access to the code that controls the site of course. I'm happy with my solution for that*, I just didn't know if you had something whizzy for doing other people's sites.

I'd need access to their code if I wanted to do anything to them, so nope, that's all I have :)

_________________
Grim... wrote:
I wish Craster had left some girls for the rest of us.


Top
 Profile  
 
 Post subject: Re: Beex stats: posts and active posters per day
PostPosted: Fri Feb 19, 2016 14:42 
SupaMod
User avatar
Est. 1978

Joined: 27th Mar, 2008
Posts: 69507
Location: Your Mum
Doctor Glyndwr wrote:
Grim... wrote:
Obviously having the one argument isn't enough, so I'm also going to say that Bootstrap is the fucking Devil, for pretty much the exact same reasons.

Of course it is, it's written in JavaScript. If you lie down with dogs, you get up with fleas.

Bootstrap isn't written in JavaScript. It uses it, like it uses CSS (yes, I know, SCSS really) and HTML.

That reminds me: Web folk - if you've not got to grips with SCSS then get started now and thank me in a couple of hours when you realise how great it is.

_________________
Grim... wrote:
I wish Craster had left some girls for the rest of us.


Top
 Profile  
 
 Post subject: Re: Beex stats: posts and active posters per day
PostPosted: Mon Apr 25, 2016 9:34 
SupaMod
User avatar
Est. 1978

Joined: 27th Mar, 2008
Posts: 69507
Location: Your Mum
Grim... wrote:
Very soon (if not already) the average size of a single web page will be bigger than the install image for Doom.

Turns out "very soon" is roughly now.

http://www.theregister.co.uk/2016/04/22 ... g_as_doom/

_________________
Grim... wrote:
I wish Craster had left some girls for the rest of us.


Top
 Profile  
 
 Post subject: Re: Beex stats: posts and active posters per day
PostPosted: Mon Apr 25, 2016 10:31 
User avatar

Joined: 30th Mar, 2008
Posts: 32619
Grim... wrote:
Grim... wrote:
Very soon (if not already) the average size of a single web page will be bigger than the install image for Doom.

Turns out "very soon" is roughly now.

http://www.theregister.co.uk/2016/04/22 ... g_as_doom/

Only the shareware version, though.


Top
 Profile  
 
 Post subject: Re: Beex stats: posts and active posters per day
PostPosted: Wed Sep 21, 2016 11:27 
Awesome
User avatar
Yes

Joined: 6th Apr, 2008
Posts: 12243
Attachment:
activeposters.png

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


You do not have the required permissions to view the files attached to this post.

_________________
Always proof read carefully in case you any words out


Top
 Profile  
 
 Post subject: Re: Beex stats: posts and active posters per day
PostPosted: Wed Sep 21, 2016 11:30 
User avatar

Joined: 31st Mar, 2008
Posts: 8648
I need to up my game.

And post more.


Top
 Profile  
 
 Post subject: Re: Beex stats: posts and active posters per day
PostPosted: Wed Sep 21, 2016 11:32 
Awesome
User avatar
Yes

Joined: 6th Apr, 2008
Posts: 12243
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.

_________________
Always proof read carefully in case you any words out


Top
 Profile  
 
 Post subject: Re: Beex stats: posts and active posters per day
PostPosted: Wed Sep 21, 2016 11:34 
SupaMod
User avatar
Est. 1978

Joined: 27th Mar, 2008
Posts: 69507
Location: Your Mum
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.

_________________
Grim... wrote:
I wish Craster had left some girls for the rest of us.


Top
 Profile  
 
 Post subject: Re: Beex stats: posts and active posters per day
PostPosted: Wed Sep 21, 2016 11:38 
User avatar
UltraMod

Joined: 27th Mar, 2008
Posts: 55716
Location: California
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.

_________________
I am currently under construction.
Thank you for your patience.


Image


Top
 Profile  
 
 Post subject: Re: Beex stats: posts and active posters per day
PostPosted: Wed Sep 21, 2016 11:40 
SupaMod
User avatar
Commander-in-Cheese

Joined: 30th Mar, 2008
Posts: 49232
The most important part of requirements gathering is the ability to reject bad requirements.

_________________
GoddessJasmine wrote:
Drunk, pulled Craster's pork, waiting for brdyime story,reading nuts. Xz


Top
 Profile  
 
 Post subject: Re: Beex stats: posts and active posters per day
PostPosted: Wed Sep 21, 2016 11:42 
User avatar
UltraMod

Joined: 27th Mar, 2008
Posts: 55716
Location: California
Cras wrote:
The most important part of requirements gathering is the ability to reject bad requirements.

You're a bad requirement

_________________
I am currently under construction.
Thank you for your patience.


Image


Top
 Profile  
 
 Post subject: Re: Beex stats: posts and active posters per day
PostPosted: Wed Sep 21, 2016 11:42 
Awesome
User avatar
Yes

Joined: 6th Apr, 2008
Posts: 12243
I'm a typical user. I don't know what I want until you give me the wrong thing.

_________________
Always proof read carefully in case you any words out


Top
 Profile  
 
 Post subject: Re: Beex stats: posts and active posters per day
PostPosted: Wed Sep 21, 2016 11:47 
SupaMod
User avatar
Est. 1978

Joined: 27th Mar, 2008
Posts: 69507
Location: Your Mum
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?

_________________
Grim... wrote:
I wish Craster had left some girls for the rest of us.


Top
 Profile  
 
 Post subject: Re: Beex stats: posts and active posters per day
PostPosted: Wed Sep 21, 2016 11:47 
SupaMod
User avatar
Est. 1978

Joined: 27th Mar, 2008
Posts: 69507
Location: Your Mum
I want inline code styling :(

_________________
Grim... wrote:
I wish Craster had left some girls for the rest of us.


Top
 Profile  
 
 Post subject: Re: Beex stats: posts and active posters per day
PostPosted: Wed Sep 21, 2016 11:57 
Awesome
User avatar
Yes

Joined: 6th Apr, 2008
Posts: 12243
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.

_________________
Always proof read carefully in case you any words out


Top
 Profile  
 
 Post subject: Re: Beex stats: posts and active posters per day
PostPosted: Wed Sep 21, 2016 12:03 
SupaMod
User avatar
Est. 1978

Joined: 27th Mar, 2008
Posts: 69507
Location: Your Mum
Call me insane, but I think allowing queries to be run against the database via an api isn't a smart idea ;)

_________________
Grim... wrote:
I wish Craster had left some girls for the rest of us.


Top
 Profile  
 
 Post subject: Re: Beex stats: posts and active posters per day
PostPosted: Wed Sep 21, 2016 12:03 
User avatar
UltraMod

Joined: 27th Mar, 2008
Posts: 55716
Location: California
No inner joins there, very disappointing.

_________________
I am currently under construction.
Thank you for your patience.


Image


Top
 Profile  
 
 Post subject: Re: Beex stats: posts and active posters per day
PostPosted: Wed Sep 21, 2016 12:04 
SupaMod
User avatar
Commander-in-Cheese

Joined: 30th Mar, 2008
Posts: 49232
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:

_________________
GoddessJasmine wrote:
Drunk, pulled Craster's pork, waiting for brdyime story,reading nuts. Xz


Top
 Profile  
 
 Post subject: Re: Beex stats: posts and active posters per day
PostPosted: Wed Sep 21, 2016 12:07 
SupaMod
User avatar
Est. 1978

Joined: 27th Mar, 2008
Posts: 69507
Location: Your Mum
Why stop there? I could just exec some PHP, that way you can open up the server with `shell_exec()`.

_________________
Grim... wrote:
I wish Craster had left some girls for the rest of us.


Top
 Profile  
 
 Post subject: Re: Beex stats: posts and active posters per day
PostPosted: Wed Sep 21, 2016 12:08 
User avatar
Comfortably Dumb

Joined: 30th Mar, 2008
Posts: 12034
Location: Sunny Stoke
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. :)

_________________
Consolemad | Under Logic
Curse, the day is long
Realise you don't belong


Top
 Profile  
 
 Post subject: Re: Beex stats: posts and active posters per day
PostPosted: Wed Sep 21, 2016 12:22 
Awesome
User avatar
Yes

Joined: 6th Apr, 2008
Posts: 12243
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.

_________________
Always proof read carefully in case you any words out


Top
 Profile  
 
 Post subject: Re: Beex stats: posts and active posters per day
PostPosted: Wed Sep 21, 2016 12:24 
SupaMod
User avatar
Est. 1978

Joined: 27th Mar, 2008
Posts: 69507
Location: Your Mum
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:

_________________
Grim... wrote:
I wish Craster had left some girls for the rest of us.


Top
 Profile  
 
 Post subject: Re: Beex stats: posts and active posters per day
PostPosted: Wed Sep 21, 2016 12:46 
SupaMod
User avatar
"Praisebot"

Joined: 30th Mar, 2008
Posts: 17019
Location: Parts unknown
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?


Top
 Profile  
 
 Post subject: Re: Beex stats: posts and active posters per day
PostPosted: Wed Sep 21, 2016 12:49 
User avatar
Sleepyhead

Joined: 30th Mar, 2008
Posts: 27343
Location: Kidbrooke
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.

_________________
We are young despite the years
We are concern
We are hope, despite the times


Top
 Profile  
 
 Post subject: Re: Beex stats: posts and active posters per day
PostPosted: Wed Sep 21, 2016 12:55 
User avatar
Hibernating Druid

Joined: 27th Mar, 2008
Posts: 49136
Location: Standing on your mother's Porsche
There used to be loads more pictures of DocG.

_________________
SD&DG Illustrated! Behance Bleep Bloop

'Not without talent but dragged down by bass turgidity'


Top
 Profile  
 
 Post subject: Re: Beex stats: posts and active posters per day
PostPosted: Wed Sep 21, 2016 15:36 
User avatar
Unpossible!

Joined: 27th Jun, 2008
Posts: 38458
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.


Top
 Profile  
 
Display posts from previous:  Sort by  
Reply to topic  [ 473 posts ]  Go to page Previous  1 ... 6, 7, 8, 9, 10  Next

All times are UTC [ DST ]


Who is online

Users browsing this forum: Majestic-12 [Bot] and 0 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search within this thread:
You are using the 'Ted' forum. Bill doesn't really exist any more. Bogus!
Want to help out with the hosting / advertising costs? That's very nice of you.
Are you on a mobile phone? Try http://beex.co.uk/m/
RIP, Owen. RIP, MrC.

Powered by a very Grim... version of phpBB © 2000, 2002, 2005, 2007 phpBB Group.