Charcoal HQ - 2017-08-09 (page 3 of 3)

« first day (1361 days earlier) ← previous day next day → last day (2459 days later) »

4:00 PM

probably not a big deal, they're just using it as an example of what it might look like in code I guess

oop they took it out

[ SmokeDetector | MS ] Bad keyword in answer: What is a person that works with make-up called? by Mia on ell.SE

fp- by J F

sd - n

ehh

well

You don't need to remove the link. Just say it's your work :) — DavidPostill 20 secs ago

It just needs the fluff edited out of it

Nisse Engström

@quartata Why n?

4:07 PM

Mostly the last parts of it

it's not something I'd flag for NAA but it needs to be edited

[ SmokeDetector | MS ] Bad keyword with a link in answer, blacklisted website in answer, link at end of answer: disable wordpress canonical tag meta by Jason on wordpress.SE

tpu- by DavidPostill

sd - k

Restart: API quota is 18244.

[ SmokeDetector | MS ] Bad keyword with a link in answer, blacklisted website in answer: disable wordpress canonical tag meta by Matt on wordpress.SE

tpu- by J F

4:31 PM

Head on over to ye olde tavern, it's where the town is holding a hall:

Tavern on the Meta

MY GOD, IT'S FULL OF STARS AND BACKLOG! General friendly chit-...

is it that time of the week already

It’s that time of the biweekly already.

2

That feeling when shog agrees with your point...

2

4:50 PM

that feeling when Undo is almost half the starboard

3

5:06 PM

that feeling when the last three messages have two stars each and you feel like you have to live up to them...

see I was tempted but I was never going to make it

5:37 PM

[ SmokeDetector | MS ] Mostly non-Latin answer: search Unicode Text in Stored Procedure Using SQL by user3651043 on stackoverflow.com

tpu- by J F

5:56 PM

[ SmokeDetector | MS ] Bad keyword in answer, bad keyword with email in answer, email in answer, pattern-matching email in answer: Can I take out a loan and invest it at higher interest? by Ferdinand Leo on money.SE

tpu- by J F

6:09 PM

[ SmokeDetector | MS ] Few unique characters in answer, repeating characters in answer: How to tell if an image is copyrighted by user13081 on law.SE

tpu- by J F

@SmokeDetector Yup, that image is copyrighted.

6:27 PM

[ SmokeDetector | MS ] Bad keyword with a link in answer: How do I compare screenshots taken in pyscreenshot with saved screenshots? by Gareth France on stackoverflow.com

naa- by J F

7:02 PM

I've just reached out to SE to see if I can get that data from them if I sign an NDA.

7:21 PM

Or just ping @Pops

How?

@TajyMany I believe Quartata just did

Oh does it ping him if @Pops isn't part of the room?

Hrm, actually it didn't

for moderators at least, not sure about SE employees but I think yes

7:28 PM

@tripleee I don't think it will if he hasn't been in the room recently

^

If his name doesn't autocomplete, he's not pingable here.

Well, except by moderators but that's a different kind of ping.

He's pingable in the Tavern right now, BTW.

Probably leftover from the town hall.

Yes, he was active there.

Ah interesting, thanks.

11

A: What are the rules for when chat messages appear in a user's inbox?

To use you as an example: @TonyMeyer, i.e. an exact match will cause a notification if you've been in the room in the past seven days. @Tony, i.e. a first name match (to be precise, a word boundary match) will cause a notification if you've been in the room in the past two days. @Ton will notif...

7:38 PM

@Glorfindel Should I ping him about this in the Tavern?

Tough question. I don't know what the rules about pinging CMs for non-urgent matters are. (Yes, I should know them but I'm still learning the ropes of mod-ship.)

He pops (pun intended) in here now and then, but not on a schedule.

If he were, I'd wait until that happens, but with bad luck that can take 6-8 weeks.

I hope some of our more veteran members are able to give advice on this.

To quote Frodo Baggins: Ask not the elves for advice, because they will tell you both 'yes' and 'no'.

[ SmokeDetector | MS ] Pattern-matching website in body: PHP CODE TO DISPLAY FEATURED IMAGE ON THE LEFT SIDE OF POST TITLE by Ratheesh Rathu on stackoverflow.com

fp- by Glorfindel

Haha. I hope we have good luck :P

I've reached out on the SE contact anyway, though.

Have you ever done that? Do you know how long they take?

Yeah, that's the normal route, but I have no idea how fast that is.

[ SmokeDetector | MS ] Few unique characters in answer: Getting shipping and billing addresses from a guest-checkout order by master on magento.SE

tpu- by Glorfindel

7:51 PM

Is anyone here an SQL "expert"?

There's a really complex (from my POV) query I want to run

SELECT * FROM [bigquery-public-data:stackoverflow.post_links] WHERE link_type_id=3 gives me the post IDs of all duplicates.

But I want the bodies of the duplicates.

So I need to refer to [bigquery-public-data:stackoverflow_posts]

Is there a way to do that?

You need to INNER JOIN it with the table containing the post body. I don't know which one that is, though.

It's [bigquery-public-data:stackoverflow.post_links]

Could you please help out :P

I want to attempt a quick Duplicate Question matching challenge

Apparently, I can get 483,213 rows of data, google BigQuery says.

That'll be very good for me.

test

[ SmokeDetector | MS ] Username similar to website in answer: Combinatorics problem related to Motzkin numbers with prize money I by FindStat on mathoverflow.net

This might work:

SELECT p.body FROM [bigquery-public-data:stackoverflow.post_links] AS l INNER JOIN [bigquery-public-data:stackoverflow_posts] AS p ON l.postid = p.id WHERE l.link_type_id=3

but I don't know the column names.

You should definitely learn how JOINs work. It's one of the most basic tools in SQL.

I don't know of a good tutorial, but I guess any tutorial would work.

7:58 PM

I haven't used SQL in around 2-3 years at this point. You're right, I should relearn.

Play around with SEDE a bit, it'll help

^ indeed, this kind of data is also available on SEDE.

@SmokeDetector f

But someone should probably leave a comment

Does Stack Exchange Data Explorer expand?

@Mithrandir expand what?

@Glorfindel I wrote [data.se], sorry, this isn't the sandbox ;)

8:04 PM

Oh, so it does.

Stack Exchange Data Explorer

Nice!

It doesn't onebox though

@Glorfindel Here's my table. I've got 2 post IDs, and I need to replace them both with bodies from [bigquery-public-data:stackoverflow_posts].

user image

Anyone got any experience with DLNA for apple products? I got a nas which is a DLNA server and i'd like to receive the stream on my MacBook. Possible? :O

@TajyMany new try:

SELECT p.body FROM [bigquery-public-data:stackoverflow.post_links] AS l INNER JOIN [bigquery-public-data:stackoverflow_posts] AS p ON l.post_id = p.id WHERE l.link_type_id=3

I found this: apple.stackexchange.com/questions/335/…

8:06 PM

Thanks. I'll try again :)

@Henders and you've tried all mentioned solutions :P Sorry, I'm not much of a help when it comes to DLNA.

But where do you match related_post_id to a body

i need the bodies for related_post_id and post_id from that table

@Glorfindel No but none of them look that legit so I was kinda hesitant...

@TajyMany you need both post bodies?

Yep

8:09 PM

SELECT p.body, r.body FROM [bigquery-public-data:stackoverflow.post_links] AS l INNER JOIN [bigquery-public-data:stackoverflow_posts] AS p ON l.post_id = p.id INNER JOIN [bigquery-public-data:stackoverflow_posts] AS r ON l.related_post_id = r.id WHERE l.link_type_id=3

Thanks! Just ran the query :)

It worked! Thank you very much!

user image

took some time though haha

You're welcome! And my comment about learning JOINs still stands :)

Interesting. How did you get that to work when it told me the response was too large?

there was me doing it in blocks of 50k

Of course, I'll be learning about Joins ;)

I use Google BigQuery

Not SEDE

Aye, so am I

8:19 PM

then tell it to export to table and allow large results

then export the table to CSV

Export to which table, though? There's no options

user image

See where it says "my first project" on the left

click the arrow beside it

and click on "new dataset"

name it anything

then when you get here:

It doesn't - it says SO data

[ SmokeDetector | MS ] Username similar to website in answer: Facebook SDK PHP publicar en Página by PrimeMonkey on es.stackoverflow.com

Can you send me a screenshot?

8:23 PM

Ah, I found a way to create one

Great

...except Google roles and permissions are now being difficult

Ugh.

Quick question: How many spam posts on SO per day?

on average, that is

Somewhere around 188?

Or 170?

Also, how many regular posts per day on stack overflow?

@TajyMany much less, according to metasmoke

36915 spam flags total cast over 7 months

8:35 PM

@TajyMany 8k questions.

8,000 questions per day?

on just SO?

Yes.

Wow.

Alright

[ SmokeDetector | MS ] Bad keyword with email in answer: Recording same person as foster and adoption parent in Ancestry.com tree? by Michelle Lutach on genealogy.SE

tpu- by Glorfindel

Answers I don't know exactly, but according to this query the Q:A ratio is about 2:3.

8:39 PM

Got it.

Thanks

Which year is the Google bigquery data from?

IDK, I forgot it existed until you mentioned it.

ah it's updated on a quarterly basis

oh lol

8:53 PM

[ SmokeDetector | MS ] Mostly dots in answer: The locus of the point of trisection of all the double ordinates of the parabola $y^2= lx$ by PRINCE RAJ on math.SE

fp- by Glorfindel

(but VLQ)

naa- by ByteCommander

[ SmokeDetector | MS ] Mostly dots in answer: Running all expansions in AOE 3 from a single exe by Daniel Pez on gaming.SE

@Glorfindel ?

naa- by Glorfindel

@TajyMany I just mentioned that I flagged as VLQ.

8:55 PM

ah ok sorry

Never mind. The only stupid questions are those which aren't asked.

@Glorfindel I need your help again :P

I need to grab pairs of bodies from [bigquery-public-data:stackoverflow.stackoverflow_posts] where the post IDs of those bodies don't appear as pairs in [bigquery-public-data:stackoverflow.post_links]

but how do you want to pair them, then?

randomly

random pairs

that are not duplicates

ooh, that's tricky. I don't know if Google's Big Data supports that.

I mean, there's probably a RAND function somewhere but I'm not a SQL wizard.

And I need to sleep right now. Unlike you, I don't like watching the sun rise :)

Good luck with your adventures!

9:11 PM

haha. It's 5 PM where I am right now. Thank you very much!

[ SmokeDetector | MS ] Pattern-matching website in answer: Issues in interfacing relay with Arduino by Amol Shah on arduino.SE

naa- by J F

@TajyMany Do they have to be random, or does it matter if they're in some sort of order as long as they're not duplicates?

@ArtOfCode As long as they're not duplicates, it's fine.

Presumably you'll just shuffle them afterwards

9:27 PM

[ SmokeDetector | MS ] Pattern-matching website in answer: Solution for simple multi-Arduino communication network (or alternative?) by Amol Shah on arduino.SE

@ArtOfCode Does SQL provide what I'm asking for, though?

It can probably be done, but the query ain't gonna be pretty

I'm currently looking at two levels of subqueries

Could you please help me out :)

Thanks!

uhhhh

my query broke google

quite literally

wow

how

9:34 PM

Trying to run it gets me a 500 server error

SELECT
  posts.body AS source_body,
  matched_posts.body AS matched_body
FROM [bigquery-public-data:stackoverflow.stackoverflow_posts] AS posts
INNER JOIN [bigquery-public-data:stackoverflow.stackoverflow_posts] AS matched_posts
  ON matched_posts.id = FIRST((
    SELECT duplicates.target_id FROM (
      SELECT
        source_posts.id AS source_id,
        related_posts.id AS target_id
      FROM [bigquery-public-data:stackoverflow.post_links] AS post_links
      INNER JOIN [bigquery-public-data:stackoverflow.stackoverflow_posts] AS source_posts

You're quite an SQL Wizard!

I blame metasmoke

But MS uses ActiveRecord

Yeah, but you have to know your SQL to be able to use AR

Basically everything in AR corresponds directly to something in SQL; if you don't know SQL, you won't be able to use AR

10:11 PM

Restart: API quota is 14478.

@ArtOfCode Any success yet?

user image

@TajyMany Nope. Any variation of that query errors out. Honestly, I'd download the lot and do it in Python, or Ruby, or something.

failed for me too lol

I'll import the XML of SO Dump into MySQL and do it locally then.

10:29 PM

test

test

[ SmokeDetector | MS ] Bad pattern in URL body: apache 2.4 virtual host brings me to "Index of /" by ETfraXoR on stackoverflow.com

fp- by J F

10:57 PM

@SmokeDetector why

@JohnMiliter Post - Bad fragment in link maketecheasier.com/apache-server-ssl-support

@SmokeDetector f

Is there a torrent link to the data dump? I need it quickly.... Downloading raw files is hard :(

11:24 PM

@TajyMany here meta.stackexchange.com/questions/224873/…

Thank you @rene!

11:54 PM

@ArtOfCode FINALLY I've got it local!

Trying out the query with a low limit... now.

Expect errors

I couldn't debug it because of the server error

!!/report stackoverflow.com/a/45602137/563532

[ SmokeDetector | MS ] Manually reported answer: What does "++=" mean in Scala by vfes on stackoverflow.com

« first day (1361 days earlier) ← previous day next day → last day (2459 days later) »

Transcript for

Aug '179

Charcoal HQ

Where smoke is detected, diamonds are made, and we break thing...

dev-on-prod flag-based-fraternity programmatic-crowbars

join this room
about this room

00:00

06:00

12:00

18:00

all times are UTC

site design / logo © 2024 Stack Exchange Inc; legal

mobile