The Official Status Thread
-
So are we talking vegetarian vs pescatarian then?
-
I have no idea, he completely changed my quote.
-
I live in Washington State. I don't own an umbrella.
I was born and raised in the North East of England and never owned an umbrella. If I was going out (i.e. out drinking) then I'd just get wet like everyone else. If I was going out in a non-pub situation then I'd wear a waterproof jacket.
I now live in Brisbane and still don't own an umbrella.
-
Nope, not fish. Vegetarians don't eat animals. If they do, then they're not vegetarians.
Aren't the set of things that are like "fish-eating vegetarians" why we got the term "vegan"?
-
If I was going out (i.e. out drinking) then I'd just get wet like everyone else.
That seems--and I am not meanig to mock here--rather peasantish.
-
Aren't the set of things that are like "fish-eating vegetarians" why we got the term "vegan"?
You're thinking of episcopalians.
I bet that someone whooshes this
-
You're thinking of episcopalians.
I'm trying to decide if you think I didn't restrict my set enough, or you meant "piscopalians."
-
I'm trying to decide if you think I didn't restrict my set enough, or you meant "piscopalians."
Don't think about it too hard.
-
-
@RTapeLoadingError said:
If I was going out (i.e. out drinking) then I'd just get wet like everyone else.
That seems--and I am not meaning to mock here--rather peasantish.
It's the way of the North East. The basic reasoning seemed to be that you were going to be indoors in the pub so you dressed for that. The fact that it was teeming with rain or -5c or a blizzard was worth enduring so that you didn't have to deal with a jacket or umbrella when you got there.
Or something.
-
I'm trying to decide if you think I didn't restrict my set enough, or you meant "piscopalians."
And here was me thinking you meant pescatarians.
-
Let's see if this works...
- paycheck
- insurance
- AC
-
Let's see if this works...
- paycheck
- insurance
- AC
You were expecting Discourse to behave? WHAT THE HELL IS WRONG WITH YOU
-
Oddly enough, it behaved exactly as I expected.
-
Even in the quote?
-
Yeah, I did expect that formatting to be stripped.
-
Yeah, I did expect that formatting to be stripped.
wut. You mean, it behaved exactly as you expected in all respects?
WHAT THE HELL IS WRONG WITH DISCOURSE
-
I think they're ready for Version 2.0, now.
-
-
WHAT THE HELL IS WRONG WITH DISCOURSE
Yeah, when you think you've figured out its disfunction is when it attacks and does things the way a sane person would expect.
-
Yeah, when you think you've figured out its disfunction is when it attacks and does things the way a sane person would expect.
How I expect it to act and the way a sane person would expect it to act are two separate things.
-
Status: whoa... Steam has a MUSIC PLAYER? WTF seriously.
-
Steam is a good OS, lacking only a decent game organiser.
-
But it's sort of
bordering onluminous greeny-yellow.That stuff is a color that doesn't exist in nature. It looks like it came from a glow stick¹.
¹It doesn't really glow in the dark, but looks like it should.
-
That stuff is a color that doesn't exist in nature. It looks like it came from a glow stick¹.
¹<small><small>It doesn't really glow in the dark, but looks like it should.
Exactly my point. Mt Dew looks unnatural. It's like Slurm.
-
But growing up we never refrigerated pop
I never refrigerated my pop, either. I think he would have objected.
-
I don't own an umbrella. No true Washingtonians do.
I own a couple. I don't use them.
-
the Seattle area broke the all-time rain record for this date.
We had 4 highly-paid engineers looking out the window at the ripples in the water flowing through our parking lot.
-
https://upload.wikimedia.org/wikipedia/en/6/6c/Version2.0front.jpg
?
Filed under: The official logo of Discourse 2.0
-
We had 4 highly-paid engineers looking out the window at the ripples in the water flowing through our parking lot.
What else did you expect them to do?
And admit it ... you were the first one standing there
-
Status: pretty drunk on record rain day, wooo. Drinking Dry Fly Washington Wheat Whiskey, BUY YOUR BOOZE LOCAL!!!
-
Status: Considering automating which threads should be excluded from certain queries rather than hard-coding them in the queries, since there's currently 21 queries that have topics hard-coded in them...
Filed under: c09fa970-5a9a-11e4-8ed6-0800200c9a66
-
I've just traveled to the US and couldn't get a cup of tea for a few days (Earl Grey doesn't do it for me and that seems to be the only 'black tea' available in most places).
I got bad headaches and was rather snippy for a while, thankfully the coffee was pretty good so that worked as an acceptable caffeine-replacement-therapy.We have an informal tea-rotation setup at my current place. If you're thirsty you make tea for everyone. It results in drinking upwards of 6 cups during working hours...possibly a little too much maybe.
Edit: As my first trip to the States from the UK it was amusing seeing how false the stereotypes were.
-
Considering automating which threads should be excluded from certain queries
Hmmm. One for the bad-ideas thread? (Most of this was there to begin with - the top
exclusions
is what I'm considering adding):[postgres@sofa ~]$ sql_tdwtf too_much_time # Who's got this badge? WITH exclusions AS ( SELECT user_id, id, topic_id, post_number FROM posts WHERE raw LIKE '%c09fa970-5a9a-11e4-8ed6-0800200c9a66%' AND user_id IN ( SELECT gu.user_id FROM group_users gu WHERE group_id IN( SELECT g.id FROM groups g WHERE g.name IN ('admins') ) ) ), LastMonth AS ( SELECT row_number() OVER (ORDER BY count(*) DESC, bp.user_id), u.username, bp.user_id, count(*) FROM badge_posts bp JOIN users u on u.id=bp.user_id AND bp.user_id NOT IN ( SELECT gu.user_id FROM group_users gu WHERE group_id IN( SELECT g.id FROM groups g WHERE g.name IN ('bots') ) ) WHERE topic_id NOT IN ( SELECT topic_id FROM badge_posts GROUP BY topic_id HAVING count(topic_id) <4 ) AND topic_id NOT IN ( SELECT topic_id FROM exclusions ) AND bp.created_at > CURRENT_DATE - INTERVAL '1 month' GROUP BY u.username, bp.user_id HAVING count(*) > 1 ORDER BY count(*) DESC, bp.user_id ), TotalUsers AS ( SELECT max(row_number) from LastMonth ) SELECT username, row_number, count, CURRENT_DATE granted_at FROM LastMonth, TotalUsers WHERE row_number = 1 username | row_number | count | granted_at ----------+------------+-------+------------ FrostCat | 1 | 1531 | 2014-10-23 (1 row) Elapsed: 1.214s Backup taken: 2014-10-23 09:37:24.220612 [postgres@sofa ~]$
-
you should possibly consider having a second UUID that reverses the effect of the first one, in case an admin makes a topic not count and then wants to reverse it but can't be bothered to find their original post and edit it.....
right, right, i know. the evil ideas thread is over that way.....
-
Merely searching for the UUID will bring it up.
Editing the post to remove it is a no-brainer.
And the intention is to only require one occurrence in each of the few threads concerned.
-
right, right, i know. the evil ideas thread is over that way.....
yeah i realized my mistake about half way through, but the idea was funny enough in my head that i posted it anyway.
turns out it was way funnier in my head.
... sorry about that.
-
turns out it was way funnier in my head.
I think PJHs idea of adding cyborgs to the bot list is funnier.
-
I think PJHs idea of adding cyborgs to the bot list is funnier.
just read that.
it wouldn't be entirely inaccurate.
I know i'm not the only person who runs some sort of bot on their account, but i think i'm the only one that has theirs liking /t/1000
-
WHERE g.name IN ('admins')
Shame ... I was about to go spamming c09fa970-5a9a-11e4-8ed6-0800200c9a66 in some random topic
-
@PJH said:
WHERE g.name IN ('admins')
Shame ... I was about to go spamming c09fa970-5a9a-21e4-8ed6-0800200c9a66 in some random topic
Well it was initially going to be simply
where user_id=20
. but if/when we get other admins, it'll save having to edit the queries, yet again.
-
if/when we get other admins, it'll save having to edit the queries, yet again.
How proactive!
-
How proactive!
Saves me looking up @dhromed's id as well for when he comes back...
And, having thought about the whole concept, I could use the same mechanism to award things such as the Pedantry badges and actually have the badges link to the posts that they got awarded for...
-
Saves me looking up @dhromed's id as well for when he comes back...
it's 16: http://what.thedailywtf.com/users/dhromed.json
an interesting idea for @_sockbot, query user info.... :-D
-
WHERE raw LIKE '%c09fa970-5a9a-11e4-8ed6-0800200c9a66%' AND
This seems like a terrible thing for performance. Better to create a single account whose only purpose is to post in the Threads That Shall Not Count and let admins impersonate it as needed. I'm assuming that the
user_id
on posts is indexed, of course.
-
Status: Considering automating which threads should be excluded from certain queries rather than hard-coding them in the queries, since there's currently 21 queries that have topics hard-coded in them...
- Create a hidden post with a comma separated list of excluded IDs
- Change the 21 queries to anti semi join on a CTE made from splitting the list into rows
- Hope no other admin finds the post and changes it
- ???
- Profit
-
This seems like a terrible thing for performance.
First thing I checked before even posting here. It's not that bad actually - it's a small proportion of the query as a whole.
-
Create a hidden post with a comma separated list of excluded IDs
Should I just move this post to the right thread?...
-
I guess they must have some sort of full text index kind of thing going on. Which they probably need for searching.
-
I saw after posting that you'd already come up with a similarly crazy idea. I think you should do both