Tavern on the Meta

Mechanical snail

00:13

Is the racist downvotes thing the same issue as last time?

Pekka

Yup, the same guy.

Looks like a troll to me.

jadarnel27

05:23

The bad part about having three jobs in one year is taxes.

mamdouh alramadan

05:34

@jadarnel27 - hi

jadarnel27

Howdy, mamdouh.

mamdouh alramadan

I have a question and i'm not sure If it should be asked here..

but, I need to access the data of php question on SO. for data mining purpose, can I?

and if yes, how??

jadarnel27

I believe there are some general guidelines for crawling SO on Meta, but the preferred method would be to use the API.

Tim Yi Jiang

You can either grab the API, or grab the dump

mamdouh alramadan

@TimYiJiang - the dump??

where from?

jadarnel27

05:38

@mamdouhalramadan Here is the documentation for the API.

But yeah, @TimYiJiang is onto something with the data dump. If you're consuming a lot of the data, you might want to use that.

Tim Yi Jiang

10

Q: Where is Stack Overflow's public data dump?

I see a lot of talk around here regarding the Stack Overflow public data dump. Where is it? How can I play with it? Return to FAQ index

mamdouh alramadan

thank you guys. but one more question. how often do you update the dump?

and does it contain all the Q&A in SO?

Tim Yi Jiang

It does, yes, so it's rather big

mamdouh alramadan

just 589MB not that big actually. I though it might goes in TB's

If I have technical questions about the dump DB, where can I ask about them?

Tim Yi Jiang

On Meta. There's a tag for it, search it first

@mamdouhalramadan That's because it's compressed. It should come out to several GB after unzipping it

Remember that it's all text - there's no blobs in there

jadarnel27

05:48

@mamdouhalramadan Most of your questions are probably answered in this post: Database schema documentation for the public data dump and Data Explorer

mamdouh alramadan

@TimYiJiang - great, thnx guys :)

@jadarnel27 - thank you :)

jadarnel27

No probz.

My grandpa asked me how much money I make the other day. Who does that? Old people are weird.

Tim Yi Jiang

@jadarnel27 ONE MEEEEEEEEEEEEELLLION DOLLARS

jadarnel27

Hahaha

Yes, that's what I should have told him.

Instead, I just told him that if he asked me an impertinent question like that again, that I'd hide his insulin.

Which made the rest of Christmas morning really uncomfortable, for some reason.

Tim Yi Jiang

07:56

Runtime error? RUNTIME ERROR!?

SnareChops

I got one earlier today too... random

Tim Yi Jiang

UNACCEPTABLE

Seriously though, where's the usual error page? YSOD don't usually happen

Tim Stone

11:55

13

A: Intermittent site failure?

Windows 2008 R2 server clustering on top of which SQL 2012 Always on Availability groups are built is buggy as hell. We're tracking down the YSOD cause now and attempting to fix before doing the next patch round. To add to the fun, we've had memory and/or a processor memory controller fail in a...

Tim Yi Jiang

@TimStone Sounds like Nick might be a DF player. He has an interesting definition of !!FUN!!

Strangely enough, the question Mystical is referring to didn't get that many hits

43k within one day (though the question has been around for two now) appears to be around 1% of the visits per day SO gets

Tim Stone

13:35

@TimYiJiang I'm also rather confused by those numbers, since the compressed August data dump is 7.68 GB for the whole network, of which 6.12 of that is Stack Overflow :P

Oded

@TimStone - Can you help out with this?

-3

Q: I want to switch from C# to c++/qt is it a good decision?

Due to Microsoft's unusual decisions about future of .net and more specifically since Microsoft environment is more like working with limited number technologies and tools offers by Microsoft specially in developing winforms(I don't want to use WPF) In other side I am totally familiar with jav...

c++ .net qt

OP doesn't seem to get what I am trying to say.

Tim Stone

is not the Tim you're looking for, cc: @TimPost

Oded

Whoops.

Sorry @TimStone

Tim Stone

Not a problem, no one had confused us yet this week, so it was expected to happen at some point. ;)

Oded

And its only Monday.

Tim Stone

13:45

It is indeed Monday, ugh.

Luke

14:06

5

Q: All mods are equal, but some mods are more equal

All mods are equal, right? Except for Kiamlaluno. Real funny... Bug found here. I'm using Chrome 23.0.1271.97

bug moderators stackexchange.com

The wheel of blame gave me the dev team

No joke

Lance Roberts

16:43

Can someone get me the link to a recently deleted question on SO that starts "What are the valuable lessons of history in programming and"?

balpha

@LanceRoberts stackoverflow.com/questions/620984/…

Lance Roberts

@balpha, Thanks a bunch.

I sure wish the deleters would slow down in their quest for SO (and Meta) purity.

bfavaretto

19:03

The SO websockets (live updates) seem to be failing for me right now. Anyone else having problems with that?

Daniel Fischer

I've been having problems today too, but I blamed my flaky internet connection.

bfavaretto

I was too, but then I connected from a different place and the problem persists. I didn't realize it would make such a difference to use the site without that feature!

Daniel Fischer

Maybe you're too young to remember, but there should be an F5 key somewhere on your keyboard, give it a try.

bfavaretto

Haha, I do remember, the problem is my fingers are starting to hurt. The main problem is, I'm missing comments when they come in in a fast pace.

Martijn Pieters

@bfavaretto: Yup, I have to keep refreshing.

It seems to have abated a little now.

I think we switched and/or got a CSS update.

The blue text in the top bar is lighter now, after a brief moment of no CSS at all.

scratch that, websockets are still not playing ball.

bfavaretto

19:19

So I guess we'll get a js update soon, too. Or it's something on the servers.

Oded

Same problem here.

Martijn Pieters

They are simply not connecting.

perhaps something to do with the upgrades?

We are aware of errors being seen, an unfortunate side-effect of some upgrades. We'll try and keep the outages to a minimum tonight.

Tweeted by StackStatus on January 14, 2013 at 2:38 AM

16 hours ago though.

Dinner time; hopefully things will be better later on.

Oded

I am only seeing a single failed request on page load.

balpha

It works for me. Are you behind some crazy proxy?

Oded

Nope. Home network.

Fails on:

engine.adzerk.net/z/8277/adzerk2_2_17_45

Which I can get directly on the browser.

balpha

19:28

oh, I meant the socket problem

Oded

Well, I can't tell - how can I tell if they are erroring? I know that I am not seeing updates without refreshing.

Tim Stone

There's some intermittent connectivity issue, it seems.

balpha

hmm yeah, I see a few 503 in the logs

I'm going to blame it on the DC move for now, but we'll keep an eye on it

Oded

I can see intermittent problems - several requests pending. The successful ones are 5 and 17 seconds (!)

amanaP lanaC A nalP A naM A

20:53

Shalom all

Oded

Salam

amanaP lanaC A nalP A naM A

@Oded Whats up?

Oded

Snowing today and the block boiler for the shared heating and all hot water broke this morning.

amanaP lanaC A nalP A naM A

@Oded oy... so what are you doing?

Oded

No showers ;) But we do have our own central heating. There is only one small shared radiator in the house, so it's not a huge problem on the heat side of things.

amanaP lanaC A nalP A naM A

20:57

@Oded oy... I am sorry.

did it stop snowing at least?

Oded

The cold water is killing me though (cleaning dishes, showers etc...).

There is a bunch of guys at the basement now, clearing out... asbestos. Which is why the plumbers can't go in and fix the boiler.

amanaP lanaC A nalP A naM A

wow.

Oded

Yeah. Living in an old building is... fun. The lift with an inner grate... That if not closed means the lift won't move...

amanaP lanaC A nalP A naM A

....

sorry man

Oded

It's cool. Couldn't give the kids a bath though. And the boiler should be back on tomorrow, so it turns out to be mostly a short lived inconvenience.

amanaP lanaC A nalP A naM A

21:03

@Oded lol oy. a teapot? :-P

Oded

Would love one. Thanks for offering ;)

amanaP lanaC A nalP A naM A

@Oded HA

Oded

It is, however, somewhat surreal to see a bunch of burly guys walking in and out of the basement in hazmat suites. And having a trailer with "Decontamination Unit" pasted on the site parked outside.

amanaP lanaC A nalP A naM A

@Oded lol

Well at least twill be over soon, no? @Oded

Oded

Twill. I do wonder what the neighbours are thinking :)

amanaP lanaC A nalP A naM A

21:08

@Oded RUN AWAY!!! THEY HAVE BEEN CONTAMINATED!!!

Oded

Well... I can only imagine what someone walking past might be thinking...

amanaP lanaC A nalP A naM A

1 min ago, by amanaP lanaC A nalP A naM A

@Oded RUN AWAY!!! THEY HAVE BEEN CONTAMINATED!!!

^_^

Oded

hehe

amanaP lanaC A nalP A naM A

@Oded did u see the blog I started last week?

Oded

The javascript one?

amanaP lanaC A nalP A naM A

21:11

ya

I guess u did lol

reddit.com/r/javascript/comments/16k6uj/…

Oded

I always though fibonacci was a good example of recursion, but lacked real world impetus.

amanaP lanaC A nalP A naM A

@Oded hence I added my last example :-)

Oded

And when it comes to recursion in interviews, my favourite line (after cracking a recursive question) is to say "but of course, every recursive algorithm can be written using a stack based solution".

amanaP lanaC A nalP A naM A

@Oded baah. but they are not always as efficient

Oded

Yeah. Though the tradeoffs between recursion and a simple stack/loop I think are not always well understood.

Dunno. It is easier to blow the stack with recursion :)

amanaP lanaC A nalP A naM A

21:16

:-P

I LIEK DESTROYING THE JS STAK!

Oded

Glad you don't blog like you chat

amanaP lanaC A nalP A naM A

lol what do you mean?

Oded

Oh, nothing (spelling, cough, cough)

Gee. Someone with the username Dragon Warrior. Makes me feel old :(

amanaP lanaC A nalP A naM A

I did that on porpoise ^_^ @Oded

Oded

And I strike out again with my sense of humor.

amanaP lanaC A nalP A naM A

21:24

Wow my internet is going sloooow...

Oded

Your shark is missing its lasers.

amanaP lanaC A nalP A naM A

@Oded that is a porpoise :-P

twas part of my joke, but it came in late haha

Oded

As you may have guessed, I did that on porpoise myself. Possibly jumped the shark.

waiting for the room to empty, users fleeing in horror.

amanaP lanaC A nalP A naM A

HA

Transcript for