Tavern on the Meta

12:12 AM

Oh. also @Gerry your domain name has nothing to do whether its https or not too

its entirely at the server level (and I use the same certs for my web server, and other things)

(I've been playing with letsencrypt)

in fact you can host http and https on the same server with the same content, or get it to redirect http to https (which you need to do in production)

user315433

Well. It's a good thing that I'm not hosting anything, then.

Shog9

afaik, the issue here is that the code wasn't running on our server, so moving it to https would've been problematic. We could've (and did, for a time) leave it as http, an island in the growing sea of https, but that's not a great long-term plan.

Journeyman Geek

12:39 AM

heh. I have a bunch of stuff for personal use I really need on the wider internet, and firefox is kinda naggy when you type passwords into non https sites ;p

user315433

12:56 AM

The 30 most mentioned books on Stack Overflow -- the post does not explain how these were determined (based on the data dump, apparently), but may be interesting anyway.

Journeyman Geek

@Gerry dev-books.com

says so on the saucy sauce

user315433

SO has 35.4M posts right now, though.

user315433

> We analysed more than 40 000 000 questions and answers

user315433

And deleted ones aren't in the dump

user202362

1:48 AM

current stats on my new mail server: 6 testing emails, 1 relevant email & 1 spam

user202362

amazed at how fast spam found it

Journeyman Geek

2:07 AM

heh

@JasonC There's something to be said about people who hang around on meta looking for things to answer. There's something oddly pointless about it...yet some fools do it ;p

Jason C

@JourneymanGeek It's one of the best tools in my procrastination toolbox.

Journeyman Geek

;p

Though at some point I need to work out the etiquette of duplicates here.

On one hand, my answers get a ton of votes, so I suppose they are useful. On the other, so much stuff's dupes, I wonder if I should check before I answer rather than FGITWing em

Jason C

ShadowWizard usually comes to the rescue for dupes.

Journeyman Geek

yup

Jason C

2:30 AM

@TimStone Why is data.stackexchange.com/meta.stackexchange/query/… in JSON format and not in an actual table? This has always bothered me greatly.

user202362

cat json

Jason C

2:48 AM

@JourneymanGeek data.stackexchange.com/meta.stackexchange/query/662754 probably displays number of dupe votes cast by users.

At least, as much as possible, given that questions closed for conflicting reasons still attribute the majority reason to all the closevoters.

Journeyman Geek

@JasonC its less "its closed" and more "should I answer?" ;p

I mean, no one seems to mind of course

Jason C

Well, I just wanted data to support my "ShadowWizard to the rescue" claim, lol.

Journeyman Geek

lol

Jason C

Oh whoa

Has "next tag badge" always been displayed in the rep pane on the profile page?

Ohh you can pick and it automatically happens if you have no privileges left

Wow I've always wanted that, that's awesome

Journeyman Geek

yup

> it automatically happens if you have no privileges left

#humblebrag

user202362

3:07 AM

anyone hosting their own website?

user202362

why is that I changed some graphics by deleting and uploading new ones but the website still reflect the old ones?

user202362

oh wait, reloading didn't clear cache

Shog9

shouldiblamecaching.com

Journeyman Geek

Yup, and its probably caching.

user202362

also 1 wrong uppercase

user202362

3:33 AM

The National Oceanic and Atmospheric Administration predicts sea levels will rise as much as 91 centimetres in Miami by 2060. By the end of the century, according to projections by Zillow, some 934,000 existing Florida properties, worth more than $US400 billion, are at risk of being submerged.

user202362

Relative sea levels in South Florida are roughly 10 centimetres higher now than in 1992.

user315433

3:45 AM

ok my cat just lost his leg. — ruggedbuteducated May 20 '13 at 5:46

user315433

user315433

Um... too chatty?

user315433

Or too catty?

Shadow Wizard

7:19 AM

...derp Yes, I'll get those fixed right up. Thanks... 😒 — rossipedia ♦ 7 hours ago

@derp you allowed him to use your name? ^

rene

7:33 AM

Well, I admit editing it to try and see what happens. user is banned for breaking the system ...

Shadow Wizard

lol

Actually they took it pretty nicely. See? There are nice devs. ;)

(Jeff would have kicked my butt for such a trick... ;))

rene

8:29 AM

53 secs for a PHP question on MSE to be deleted by Oded. He must really hate PHP ...

Journeyman Geek

lol

Shadow Wizard

lol

@rene and OP suspended on MSE. And OP is question banned on SO and trying to ask questions via answers there. Can't be more desperate or pathetic than that. lol

Journeyman Geek

@ShadowWizard they could ask on entirely unrelated sites

like I donno, underwaterbasketweaving.stackexchange.com.

rene

I was just about to propose that on A51 ...

Shadow Wizard

> Couldn't find underwaterbasketweaving.stackexchange.com

> The Q&A site underwaterbasketweaving.stackexchange.com doesn't seem to exist…yet.

:(

Journeyman Geek

8:47 AM

Clearly that is underserved

Shadow Wizard

Heh, noticed a new symbol for the first time today... ⚦

Stijn

9:03 AM

@ShadowWizard what symbol is that?

Mithrandir

@ShadowWizard Yes. I repcapped. On Meta.SE. O_O

Journeyman Geek

@Mithrandir sweet

Mithrandir

@Stijn transgender symbol

Why does the /reputation page show repcapped events in [brackets]?

Journeyman Geek

I guess so you know you get no rep for em?

I've never noticed tho :(

Mithrandir

@JourneymanGeek it shows a zero, though, so...

Journeyman Geek

9:17 AM

[2]

Makes sense there ;p

Shadow Wizard

@Stijn what @Mithrandir said, I noticed it while looking for an icon on Font Awesome, lol. fontawesome.io/icon/mars-stroke

Funny they use "mars" instead of "male" too... :D

There are several icons for transgenders actually. Not fair, ordinary male got only one icon. :P

@Mithrandir what @Journeyman said is probably true, just to make it easier to distinguish.

Journeyman Geek

@ShadowWizard there's a redicloulus amount of variety in gender-identification

Shadow Wizard

1

Q: What does it mean the braces "[ ]" in the reputation summary?

I was taking a look at http://stackoverflow.com/reputation and I saw something like this: 2 4391811 (10) 2 4580949 (10) 2 4580630 [2] I noticed that I have just another reputation log with [ ] and I wonder what it means. Just curiosity. (in the case above, I didn't accepted any answer...

support

@JourneymanGeek that's true... and it's all pretty new I guess, i.e. 20 years ago there were males and females, and that's it.

(officially, of course. :))

Journeyman Geek

@ShadowWizard most of them were probably too scared to come out

Shadow Wizard

@JourneymanGeek yeah... would be interesting to know what triggered the change, or who. Meaning the first meaningful event/movement in that direction.

Journeyman Geek

9:38 AM

@ShadowWizard no one thing I guess

though i guess hormone therapy is a relatively recent thing

Fawad

11:06 AM

@Telkitty it need hugs..

Journeyman Geek

it needs a fistbump

rene

You clicked the edit link by mistake. You should have clicked the delete link. — rene 19 secs ago

2

@Bart @ShadowWizard ^ delete pls

Stijn

@rene that's savage

M.A.R.

@rene Never change

Journeyman Geek

@rene I can smell the burn.

Almost at my first non reversal gold badge on MSE ._.

M.A.R.

11:10 AM

@JourneymanGeek Lunatic or electorate?

Journeyman Geek

~~Lunatic~~ Fanatic.

M.A.R.

Welcome to the list of loonies

Journeyman Geek

(I have 4 Reversal badges here. And none on SU :p)

M.A.R.

Unsurprising

Journeyman Geek

Its more the posts arn't deleted before I get it

and People love zee snark

M.A.R.

11:15 AM

I have one reversal

Happily, it was a delicious enough drama to garner enough votes before I got the reversal

Journeyman Geek

lol

Only one of my reversals was deleted

and it was someone complaining about my moderation ;)

M.A.R.

Well, mine was Charcoal-related drama

rene

It didn't want to ignite?

Journeyman Geek

ah

I don't like drama.

When I do, I want to make sure I crush the perpetrators with truth, logic and style ;)

M.A.R.

@JourneymanGeek I like drama if I'm in the right

Not that much though

Only a once a month dose

Too much drama can cause pulmonary fibrosis

Journeyman Geek

11:29 AM

Some people on RA's convinced I have a magic ability to defuse stuff just by being around ;p

M.A.R.

@SmokeDetector Unsure

Journeyman Geek

Smells like spammer to me.

Fawad

@JourneymanGeek lunatic?

Journeyman Geek

@Fawad @M.A.R. MAKE FUNNY.

M.A.R.

Make fun, not make funny

Journeyman Geek

11:36 AM

MAKE. FUNNY.

M.A.R.

Learn English, doggy

Journeyman Geek

woof.

Stijn

12:01 PM

Journeydoggy would be a good name

Journeyman Geek

@Stijn If I ever decide to get real reputation on my sock, I might do that ;p

user202362

1:54 PM

M.A.R.

pwned

Fawad

2:16 PM

@Telkitty you no manners dog. Respect cat family of tigers

@Stijn or journeydoggie ?;)

Stijn

@Fawad that's work too :)

user315433

4:12 PM

user315433

Marc's self-similar tweet.

user315433

Including userpic in Github oneboxes usually doesn't work that well... a tweet says "check this out, looks really nice" with someone's mug shot attached.

Elephant

4:24 PM

It's Marception!

Jason C

6:40 PM

@TimStone Is it completely impractical to allow people to create functions in SEDE (just like I can create procedures now)? Is there some way that can work or would it just completely break everything? (I don't really know how databases work.)

Tim Stone

See Can we have functions in SEDE?. The answer being no because SQL Server doesn't have temporary functions, but @rene has a workaround that might help for certain tasks

RE: the JSON output of PostHistory, I have no idea why it's that way other than that I assume it's stored that way in the source data too

(there's variation in the types of banner notices so I guess that approach was just easiest)

Feeds

7:15 PM

Podcast #106: Data Team Assemble!

Jess Pardue on April 25, 2017

Welcome back to the Stack Overflow podcast episode #106 recorded live on Thursday, April 20th at SO headquarters in NYC. We are honored to have Anil Dash, CEO of Fog Creek, leading today’s antics while Joel is away. We are also joined by the entire SO Data Team; Kevin Montrose, Jason Punyon, Dr Julia Silge, Nick Larsen, and Dr Dave Robinson.

In today’s episode you will find: mystery, intrigue, and mangoes! As well as…

Kevin drinks two whole unicorn fraps.

Jay rants about the people who rant about babies on planes. …

Anonymous

8:04 PM

23

Q: Wrong way on a bike lane?

Is it OK to ride the opposite way on a designated bike lane? I'm in Louisville, Kentucky, USA. The reason I ask is because most of the lanes near me are only on one side of the road. The picture below is an example of the type of lane. The law where I live allows me to ride on the road, bike l...

safety

Anonymous

This seems like a pretty self-evident question.

Anonymous

but I was flabbergasted by how many people at Google did not understand this.

Anonymous

Like every week there'd be a post on the mailing lists asking people to please ride on the right side of the road.

Anonymous

against fast busy traffic, in many cases

user315433

@JeremyBanks Bike speed being in between cars and pedestrians, some people are unsure from where to take the rules when extrapolating. Pedestrians are advised to walk opposite traffic direction when there are no sidewalks.

rene

8:11 PM

so they can jump away from oncoming traffic. On a bike this becomes already impossible.

Anonymous

[testing new keyboard]

user315433

Yes, I know the logic doesn't apply; just pointing out a possible source of confusion.

user315433

Now that I think of it, there is no SE site for pedestrians...

rene

I like how that last answer brings in The Netherlands as an example. As if we're sane with our laws here, like legalized drugs. They assume our traffic regulations are OK as well then ...

Elephant

So many emojis

20

Q: Why is 👩‍👩‍👧‍👦 treated so strangely in Swift strings?

I must start out by saying that I know how strange "👩‍👩‍👧‍👦" is (family with two women, one girl, and one boy). This is encoded as such: U+1F469 WOMAN, ‍U+200D ZWJ, U+1F469 WOMAN, U+200D ZWJ, U+1F467 GIRL, U+200D ZWJ, U+1F466 BOY So it's very interestingly-encoded; the perfect target for a ...

swift string contains string-parsing

rene

8:16 PM

@JasonC I'm not sure what you hope to achieve but running a function in a where clause will cause a full table scan. Don't expect records from PostHistory on SO in that case.

user315433

@Elephant A comment asserts that the question is interesting. I investigated: there are 195 interesting questions on SO.

user315433

I expected more... perhaps this is a kind of comments that Andy's bot picks up on.

Jason C

8:53 PM

@rene Oh interesting. Well I found a better way to do what I wanted without a procedure/function at all. I wanted to parse image links out of a string, and I knew how to do it with a recursive cte for a scalar input, but I wanted to do it for every row in a query.

And I knew that I could do cross apply like with e.g. split_string so I was trying to make something that took a string input and returned a table.

But it turns out the entire thing can be built into the recursive query. I didn't realize it would behave properly with multiple rows as the initial condition.

So

Yay

(the root of this is i needed a split_string that took a string as a delimiter instead of a single char).

user315433

Are you trying to parse JSON in SQL?

Jason C

No, even better, parsing html

data.stackexchange.com/meta.stackexchange/query/663001/… it actually worked really well

user315433

Hm, a lot of gravatars embedded in ancient town hall chat digests... November 2011 Moderator Election - Town Hall Chat Digest #1

Jason C

Yeah I saw that

I was initially surprised at how popular gravatar links were I thought it was a bug.

user315433

Such gems there, like @Jeremy's shenanigans from way back when.

user315433

9:04 PM

Actually unclear how far back, because the timestamps are all "X hours ago".

Anonymous

9:17 PM

Anonymous

That incident partially kick-started my meta participation.

user315433

9:30 PM

If you like historical novels, check out the answer to How did mathematics end up with two Stack Exchange sites, while Physics only got one?

Shokhet

@ShadowWizard I forget if you can ping close voters on a closed question, so...

@Sha slightly different -- that one wants the full wikis in the apps (which is also a good idea); this one asks for the wiki excerpts when asking/editing a question. — Shokhet 1 min ago

user315433

Today is the 5th anniversary of the ~~bloodiest~~ largest mass-closure in SE history: When a Site Grows Quiet

Shadow Wizard

9:46 PM

@Shokhet you can ping only the last, or the single user who closed in case of moderator or hammer wielder... :)

Jason C

How do you tell if a post was made by a registered vs unregistered user in sede?

Shadow Wizard

But yeah, got your ping there. Faster than here, as it takes 15 minutes until it becomes a notification. :)

Jason C

It looks like null owneruserid means a deleted user, so I don't think that's it.

Shadow Wizard

@JasonC not possible.

36

Q: Please add UserType to Stack Exchange Data Explorer

So that we can construct queries which take into account whether a user is registered or unregistered, please add the UserType field to Data Explorer. Currently there is no way to do this, since the field is not exposed: Note that I'm not asking to see the user's employee status; it's probabl...

feature-request data-explorer

Jason C

Laaame

Shadow Wizard

9:48 PM

yeah

Needs screen scraping to really know.

user315433

@ShadowWizard Only those users who had a binding vote: mods or hammer wielders. Not the last one.

user315433

Unless that was changed?

Shadow Wizard

@Gerry oh. Thanks. Though it's bugged a bit.

8

Q: No notification for comment reply when using Dupe Hammer along with other close voters

User who cast a binding close vote on a question should be notified when someone comment-reply him/her, even without ever leaving a comment. This still works fine when I am the only close voter, e.g. here (tried with my sock and deleted the comment already), however this fails to work when I'm n...

bug notifications comment-replies dupehammer

(it works when I'm the only close voter.)

Shokhet

10:08 PM

@ShadowWizard Got it, thx :)

Shadow Wizard

:)

Shokhet

...@ShadowWizard, how does a non-CM/employee get a gold star in feature-request, anyway?

...you're not even a top 20 answerer for the tag :0

But you are the #5 all time asker.

Jason C

@Shokhet By making a lot of demands, lol

And also politely telling people "your feature request sucks, do this instead".

Shokhet

@JasonC Not really. Unless I'm mistaken, don't tag badges only take # of answers into account?

@JasonC More likely.

Jason C

It's an impressive badge

Shokhet

10:16 PM

...make that "a lot of people."

@JasonC Certainly.

Jason C

I'm about half way to a silver discussion badge, that's all I got. Long way to go.

Shokhet

Nice.

animuson

I had the gold feature-request badge before I ever got hired. The gold bug badge was the only one I was missing.

Shokhet

Wow. (Does that mean that @ShadowWizard is a candidate for hiring?)

Jason C

The gold stackoverflow badge on MSE has kind of a legendary quality to it. I don't think anybody will ever get one again. Or even silver ones.

Shokhet

10:21 PM

@JasonC There's only one.

Jason C

@Shokhet Yes that's how the SE hiring system works, so I hear. You don't actually have to apply. You don't even have to want to work there. Once you get a certain number of gold badges they send in the drones to grab you and ship you off to the... "re-education center" for programming and reconditioning.

Yeah

animuson

@JasonC I shall find a way! I'm over half way towards it.

Shokhet

@JasonC ...would be hard to get, anyway. Right now, most stackoverflow questions should be posted on MSO, right?

@JasonC Lol :)

Jason C

@animuson Ha, I dunno, man. That's a bold mission.

animuson

I should answer more review questions. I already have the score required for gold, just not the # of answers... :P

Jason C

10:25 PM

@Shokhet Lol, I'm picturing a group of old guys (possibly only their heads, in giant glass tubes, lots of fog) sitting around in a hidden room under the subway tunnels in manhattan watching the badges, speaking in slow, excessively reverbed voices. "We have a candidate." "Who are they?" "152859" "Excellent"

Shokhet

@JasonC ROTFL

"Excellent"

Jason C

Gendo and Seele - Evangelion 2.22 You Can (NOT) Advance

►

user202362

11:45 PM

So trump is not going to build that wall so it seems, lol

Transcript for