Tavern on the Meta

Meta Andrew T.

2:20 AM

Morning...

blub

rene

4:45 AM

→ 34 messages moved to Chimney

Tinkeringbell

@MetaAndrewT. Blub! Morning to you too :)

rene

drowning

Stormblessed

hi

bye!

Shadow The Dragon Wizard

6:17 AM

@rene kaboom

Parsing JSON with SQL... fun times...

@404 CC-By-SE 5?

Meta Andrew T.

Copy-Cut By Stack Exchange?

rene

@ShadowTheDragonWizard JSON_VALUE ? Done that: meta.stackexchange.com/a/326899/158100

Meta Andrew T.

Better than parsing SQL in JSON...

rene

certainly true

Tinkeringbell

@rene Drills a hole in the bottom of the flower pot. Does that help?

Shadow The Dragon Wizard

6:31 AM

:(

rene

@ShadowTheDragonWizard are you on LEVEL 130? SQL SERVER 2016

Shadow The Dragon Wizard

meh, not going to mess with levels for that

15 minutes and I'll have a function to parse what I need. ;)

Also server might have SQL Server 2014, not sure

@Tinkeringbell now it's easier for him to use toilets, no need to drop the pants. :P

rene

@ShadowTheDragonWizard json_value was introduced on sql 2016 ... :(

Happy CharIndex to you ...

Tinkeringbell

7:05 AM

Big news: Just found out the bigger paper cups at the office can hold a double dose of coffee :D

Mithrandir

Uh-oh. She's caffeinated.

rene

I always redefine "hold" for smaller cups.

Shadow The Dragon Wizard

CREATE FUNCTION [dbo].[ExtractUserDetail]
(
	@RawDetails nvarchar(1024),
	@DetailTitle nvarchar(50)
)
RETURNS nvarchar(256)
AS
BEGIN
	Declare @TitleIndex int;
	Declare @CommaIndex int;
	Declare @LookFor nvarchar(60);
	Declare @UserDetail nvarchar(256);
	Set @UserDetail='';
	Set @LookFor='"' + @DetailTitle + '":';
	Select @TitleIndex=CHARINDEX(@LookFor, @RawDetails);
	If @TitleIndex>0 Begin
		Set @TitleIndex=@TitleIndex+Len(@LookFor)
		Select @CommaIndex=CHARINDEX(',', @RawDetails, @TitleIndex);

Not perfect and pretty basic but fits my needz. :D

(the user details come in JSON format)

Meta Andrew T.

7:22 AM

CodeReview.SE welcomes you...

Shadow The Dragon Wizard

lol

Never posted there

Tinkeringbell

@Mithrandir Just a little. I need at least one more ;)

Shadow The Dragon Wizard

@Tinkeringbell and smaller? ;)

Tinkeringbell

@ShadowTheDragonWizard Nope. Just a double regular dose. But yeah, a single serving is small ;)

rene

@ShadowTheDragonWizard No ',' in that userdetails field, ever?

Meta Andrew T.

7:38 AM

CSV's nightmare...

rene

exactly

You need a parser :(

Shadow The Dragon Wizard

@Tinkeringbell machine?

@rene shouldn't be, it should be encoded in that case

(it's going through JSON.stringify of node.js)

hmm... not sure though

@rene ShadowParser 2.0

rene

8:05 AM

@ShadowTheDragonWizard nope, {"field":"break Shadows, code", "foo":"bar"}

is valid JSON

Shadow The Dragon Wizard

oh my

hoping client won't choose names with a comma

Optimus Prime

8:41 AM

\•

Shadow The Dragon Wizard

8:52 AM

@OptimusPrime long time no •!

one of the more weird trolls/spammers I've seen lately...

Tinkeringbell

9:05 AM

@ShadowTheDragonWizard Yep.

Shadow The Dragon Wizard

9:58 AM

@Tinkeringbell free of any cost? ;)

BTW why did you not delete the confidence question? Any reason? Usually you delete right away after posting the welcome comment.

No? Or is it only Mr. Geek? ;)

Tinkeringbell

@ShadowTheDragonWizard Oh... I got distracted :)

Is gone now ;)

Shadow The Dragon Wizard

lol

Tinkeringbell

@ShadowTheDragonWizard Yep, free coffee!

Shadow The Dragon Wizard

Who distracted you?!

:D

Tinkeringbell

Coworkers, work, and other chatrooms ;)

There's a lot of distractions here!

Shadow The Dragon Wizard

10:01 AM

@Tinkeringbell nice! Actually someone brought a machine here too, but for some reason nobody is using it.

Tinkeringbell

Well, these are paid for by the office... so we don't have to clean them ourselves XD

Journeyman Geek

10:15 AM

@ShadowTheDragonWizard sometimes we get distracted

or can't write a comment ;p

Shadow The Dragon Wizard

@JourneymanGeek no excuse can justify not deleting off topic question!!!1!!one!!!1!!!

:P

Tinkeringbell

@ShadowTheDragonWizard Oh? What are you going to do if I don't delete? XD

Should I be scared now?

rene

do you want to be scared?

Tinkeringbell

It's not Halloween yet. It can wait ;)

Meta Andrew T.

10:30 AM

I want to be cared :(

Shadow The Dragon Wizard

@Tinkeringbell paint all your socks in the same color. :-D

Tinkeringbell

@ShadowTheDragonWizard Nooo!

Shadow The Dragon Wizard

@rene whatever sails her boat..... :P

Meta Andrew T.

... her hair?

Shadow The Dragon Wizard

I'm (almost?) sure there are people who actually enjoy being scared. ;)

Tinkeringbell

10:33 AM

Oh... talking about boats...

i.stack.imgur.com/DWbbF.jpg I got to steer a 100 year old wooden one last week! :D

Shadow The Dragon Wizard

You go on a cruise?

With Tom?! :D

@Tinkeringbell ohhh nice!

Tinkeringbell

@ShadowTheDragonWizard What do I need Tom for? All I'd do is end up cleaning up after yet another guy.

Shadow The Dragon Wizard

Missed it on Twitter. @Tink

Unless you didn't post it there? lol

Tinkeringbell

@ShadowTheDragonWizard Didn't post it there :) (Not yet). Picture was just shared at work this morning :)

Shadow The Dragon Wizard

@Tinkeringbell he's famous

And rich

And some say handsome

Tinkeringbell

10:35 AM

@ShadowTheDragonWizard I don't need paparazzi or more money. and for looking at him I can get a poster.

Shadow The Dragon Wizard

lolz

You can't touch a poster

oh wait

Journeyman Geek

@ShadowTheDragonWizard oh they will be. Eventually....

Tinkeringbell

@ShadowTheDragonWizard Pic is on Twitter now too :)

Shadow The Dragon Wizard

I think he's beyond paparazzi these days... he's not the center of attention for quite a few years, so you should be safe. :P

Tinkeringbell

I'm fine all by myself ;)

Shadow The Dragon Wizard

10:36 AM

:)

404

12:29 PM

A question to add to SO Developer Survey: what license covers the user-contributed content on SO?

I think "MIT" will be among the leaders.

After all, it says here in bold that Starting Feb 1, 2016, all new code contributions to Stack Overflow and Stack Exchange will be covered by the MIT License.

And the yellow thing on top looks like an AdSense text ad, so is mostly invisible.

Tinkeringbell

Or is that a bad idea?

(It has a migration history. never mind)

404

I think dealing with posts like that should be up to SE staff, in any event.

They could have edited it - by way of severe truncation - so that any confusing bold statements are in revision history for those who want to see the history.

Tinkeringbell

@404 There's... quite some mess in older questions... Not sure how much effort they're really worth too ;)

404

It's a bit different when a post demonstrably leads people to believe that their contributions are covered by MIT license.

Tinkeringbell

@404 Well, animuson did an edit on the follow up post just striking things through. Perhaps that's an option for this one too, with additional links to the follow up post....

That way you don't really 'deface' the post as much as by hiding everything in the revision history...

404

12:35 PM

Yeah, I think a strikethrough would be an improvement

Especially when the link to followup has text "The promised follow-up is here, requiring attribution and postponing the change to March 1, 2016." -- after reading this, why would I click, I already understand what the follow-up says.

Tinkeringbell

@404 Yeah, changing that to 'indefinitely' is probably better too...

Feel free to fix it if you feel it's worth the effort.

Timeline shows enough activity to perhaps warrant spending some effort there...

404

Well it's not my users who are getting confused by that announcement, so.

Tinkeringbell

@404 Hey, you want to help out or not! :P

Aibobot

@Tinkeringbell I think he just wants to see the world burn

and have a cold beer in its glowing embers

Tinkeringbell

I guess that falls under 'not' :P

Meta Andrew T.

12:56 PM

Watching the world burn by saving them? :O

Tinkeringbell

Doesn't @Sonic like to edit stuff? :P

I'm too lazy to do it myself (and still at work ;) )

404

30 mins ago, by 404

I think dealing with posts like that should be up to SE staff, in any event.

It's their announcement. Those were once supposed to be untouchable with a special tag.

Tinkeringbell

@404 Oh really? That's from before my time XD

404

-37

Q: We're Implementing an "announcement" Tag for Direct Communication From the Team

Update (Feb 17) We're going to scrap this idea as presented. This is something that had been kicked around a bit for the last few months as we considered ways to communicate "This is what we've been doing and thinking about" types of things here on meta. We're going to develop the idea a bit mo...

Tinkeringbell

Oh... Okay.

404

1:06 PM

Preventing edits wasn't mentioned there, although that would make more sense.

Tinkeringbell

Hmmm. Maybe I'll remember to look into it more tonight...

404

> We're going to develop the idea a bit more and then propose something more thought out.

Which was apparently: post on the blog instead.

Mithrandir

Oh, I remember that... that was a ... fun time.

404

Tavern: old timers reminiscing about the stands they took or gave or were given, once upon a time.

Tinkeringbell

Time to mow the lawn...

Mithrandir

1:09 PM

On a different note, I can either call or Facebook message the army. Guess which one I'm opting for...

Facebook :P

Bingo!

Time to stand?

No, I'm going to keep sitting. I'm a lazy developer and I don't really like standing desks.

Aibobot

lol

I sometimes walk around

Tinkeringbell

1:20 PM

@Aibobot Oh, me too! To the coffee machine, or the toilet. Or even to a meeting room sometimes ;)

Aibobot

@Tinkeringbell oh inside my office too

We have a window!

Tinkeringbell

@Aibobot We too! Pretty nice view too, of the train tracks. I don't usually take the time to stand in front of it though...

Aibobot

@Tinkeringbell oh, ours has... a road

but in day time, natural light maaaan

Tinkeringbell

@Aibobot That can be nice too! Especially if it's a busy one and dark outside :D

Aibobot

@Tinkeringbell oh it can be

Meta Andrew T.

1:21 PM

I like natural light, but the sun shines directly at me in the morning at the office :/

Tinkeringbell

One of the offices of this company has a view of the busy road too, and in winter it's really fun to watch all the headlights. Especially if there's traffic :)

Aibobot

or all hell's broken lose and there's a traffic jam ;p

Tinkeringbell

That too! But it needs to keep moving a bit to be really mesmerizing :)

Mithrandir

If I go too long without moving I get restless. I have a swivel chair at my desk in my bedroom, and I'm always swiveling around when I'm at my computer...

Meta Andrew T.

I'm swinging(?) my body back and forth instead...

Tinkeringbell

1:25 PM

@Mithrandir That's usually how you can see I'm about to visit the bathroom XD

@MetaAndrewT. I play with the cords from my shirts or necklaces.

Catija

I use a standing desk most of the time but it's not adjustable so sometimes I sit in a comfy chair in my living room with my laptop in my lap.

Once the house is done I'll finally get a real desk/chair setup.

Aibobot

@Catija dosen't SE include an awesome chair in the hiring package? ;p

Tinkeringbell

@Catija The perks of working from home! In summer, you can setup outside too :D

Aibobot

(That said, I'm inordinately fond of my current chair)

Catija

@Aibobot Herman Miller Aeron chair or something... yeah. But I didn't get it or the desk yet because I had nowhere to put it since my house is going through major renovations... they started in September last year and they're nearly done now.

Aibobot

1:39 PM

@Catija had one a few jobs ago

they're insanely nice

Catija

@Tinkeringbell You don't know much about the temps in Texas, do you... ;) It's hitting 37 c most days for the last two months.

Tinkeringbell

@Catija But that's a completely different heat than 37 degrees over here! (at least, that's what everyone taking sun vacations says here XD)

Hahaha I'd stay inside too, unless I could somehow set myself up in a pool :)

Catija

Dunno... I spent Wed-Sat in Redwood City and it was nice... spent as much time outside as I could.

Tinkeringbell

@Catija Oh yeah, how was the .. summit? conference? thingus?

Aibobot

she got socks

Catija

1:43 PM

I did not, sadly.

Only two yoyos.

Aibobot

:/

Catija

I did get a book and an e-book.

Tinkeringbell

@Catija Don't let anyone tell you those are worse than socks :P

Catija

I told Jeff the socks are pretty... that doesn't mean I got one (or a pair), sadly. :(

Tinkeringbell

@Catija Of course you're not getting socks... Master doesn't give Dobby a sock, lest Dobby becomes free! :P

Catija

1:44 PM

I still have a ton of SO stickers left over.

@Tinkeringbell Y'a know... SO has socks, too. :P

Tinkeringbell

@Catija Yeah, I saw that on Twitter a long time back.

Books and e-books are always great too btw ;)

Catija

One of the books is about learning how to not get distracted...

Tinkeringbell

Step 1: Close all browser tabs ;)

And okay, hint taken. I'll go back to work! :P

Catija

I was talking about myself! :P

Tinkeringbell

You don't seem distracted? ;)

Catija

1:48 PM

Oh, wait... I got two books and an e-book.

Tinkeringbell

Nice!

Catija

amazon.com/Indistractable-Control-Your-Attention-Choose/dp/…

Tinkeringbell

Oh, that's distractingly yellow.

Catija

amazon.com/Story-10x-Turn-Impossible-Inevitable/dp/1989025587

Tinkeringbell

And that one reminds me of that 10x developer thing on Twitter a while back XD

Catija

1:50 PM

HAHAHA that was an utter failure!

Tinkeringbell

Yeah, that one was almost as funny as sharpie-gate!

I think there's still people stuck with handles referring to that 10x thing

Aibobot

lol

Jeff not master ;p

Tinkeringbell

@Aibobot Doesn't matter. Thought still counts! Catija doesn't get socks, and doesn't get set free :P

Aibobot

@Tinkeringbell that was... depressing ;p

the 10x thing

I mean I KNOW THE UNDERLYING MINDSET IS A THING

but its still kinda messed up to see

Catija

Hmmmm. I can't find the cards for the third book. :/

I hope Andy didn't toss them.

Gus might have eaten them...

Tinkeringbell

1:53 PM

@Aibobot Oh, the fact that it's a thing is already messed up enough I guess...

Aibobot

0_0

@Tinkeringbell well, its vaguely 'my' culture

and I have a cousin who works HR

and I complain a lot about the environment where IT folks are disposable contractors

and honestly, my job really sucks this week ;p

I can't do annnnnyyyttthiingggggg

Catija

Found it! - amazon.com/…

Tinkeringbell

@Aibobot That sucks. I had three months of that before my vacation. It's a bit better for now :)

Aibobot

@Catija this would worry me ;p

Catija

Gus likes eating paper.

Journeyman Geek

2:09 PM

I don't think humans can digest paper that well 😁

Catija

Don't you know... babies aren't human. :P

Aibobot

pretty sure they are

only smol

Tinkeringbell

@Aibobot And sticky.

Aibobot

eh, what was that?

Keep one end full and the other end dry?

Catija

Did you know that you don't have your sinuses until you're in your teens.

Tinkeringbell

2:22 PM

I do now? :P

Aibobot

@Catija can I give them back? ;p

Catija

IKR!

Aibobot

(I have fun random allergy attacks)

Catija

Sounds like a superpower.

Aibobot

@Catija If not being able to see out of your right eye cause its swollen is a superpower

Catija

2:25 PM

You know... when I was a kid my dad told me once that I was too young to have a headache... I wonder if this is why he thought that...

Aibobot

oh and that sinus above my eyes....

eeeeeeg

Aibobot

3:13 PM

hmm science

thetakeout.com/which-candies-taste-best-frozen-1837816896

Feeds

3:37 PM

stackoverflow.blog/2019/09/10/…

Kevin B

zzz

Meta Andrew T.

4:01 PM

@Feeds stack-overflow-blog-one-box-fail/

Mithrandir

Dropping this here so that I remember to look at it later... twitter.com/bevylabs/status/1171217512052273156?s=20

Journeyman Geek

@MetaAndrewT. honestly that annoys me a lot

And feels borderline unprofessional :/

404

@Feeds FR: a way to filter out posts by people with "Content Writer" in their job title.

Sincerely, a Content Reader.

Aibobot

@404 the blog is still, very fundamentally a marketing tool

I'd actually love them going back to having seperate blogs for seperate functions - like the SREs using blog.serverfault (serverfault.blog?)

Meta Andrew T.

5:32 PM

Better than "Discontent Writer" with "Discontent Reader"...

404

Dear Sir or Madam, will you read my post?
It took me hours to write, will you click the blog?
It's based on a story of a man named Wolf,
And I need a job,
So I want to be a Content Writer.

Aibobot

6:07 PM

eh, That dosen't seem very nice to the person who wrote it :/

I mean, I'm as much a critic of the blog as anyone, but that seems really close to ... well insulting the writer. Not cool

Kevin B

6:25 PM

i'd just rather there be a bit more... curation on what does and doesn't take up that top bilboard spot.

Aibobot

@KevinB the SO blog has been mainly that for quite a bit

On one hand, moving announcements into that is a 'reversion' to how Jeff used to do it. On the other, I suspect that its almost always going to be a certain amount of... well advertising

Kevin B

i'm a bit biased of course though, i despise the jobs tool.

Aibobot

eh

I'm not a big fan, also considering the history of it

Kevin B

i feel like 2 out of every 3 posts include at least a mention of it, if not an ad that takes up my whole monitor

but i'm just more sensitive to seeing it

Aibobot

Well, used to be all the posts

Its one of those... works in progress?

On one hand, well

these things keep SE funded

on the other hand, well, SE has gotten a little too distracted by careers in the past ;p

Sonic the Anonymous Hedgehog

8:04 PM

@Tinkeringbell I happened to come across the exact same post and had the exact same thought, but couldn't figure it out at the time.

Optimus Prime

9:15 PM

@ShadowTheDragonWizard was busy for 5-6 months until I realised that I wasn't actually busy but I'm sleeping 15-16 hours per day and browsing Facebook rest of the day. Decided to start freelancing again now.

Sonic the Anonymous Hedgehog

10:43 PM

Fun fact: in 2009, Wikipedia also went through a licensing update between two incompatible licenses: from the GNU Free Documentation License (GFDL) to CC BY-SA 3.0.

The way they went about it was that Wikimedia Foundation specifically lobbied the Free Software Foundation to change the GFDL (in version 1.3) so that it allows previous content (published before November 2008) to be re-licensed under CC BY-SA 3.0 without the consent of the authors.

The clause that allowed this has since expired, but the fact that such a clause was added at the behest of the WMF is interesting.

Wikipedia:Licensing update

As per the licensing update vote result and subsequent (May 2009) Wikimedia Foundation Board resolution, any content on Wikimedia Foundation projects available under the GNU Free Documentation License 1.2 with the possibility of upgrading to a later version was made available additionally under Creative Commons Attribution-ShareAlike 3.0 Unported License (CC-BY-SA). Specifically with regard to text, since this update, only dual-licensed content or CC-BY-SA-compatible content can be added to the projects, any GFDL-only submissions will no longer be accepted. In other words, CC-BY-SA is the primary...

Transcript for