This also makes me wonder what amount of bad content slips in at moments like this, would considerably be useful if someone checked out the last nights activity in the morning or something. Another thing to think about...
@TomWijsman I am curious to know how fast moderation takes place on these things (mean, std deviation, max, min) in terms of deletion by whatever method for offensive. Don't think such data is available though
@soandos There probably is, although they will make it much harder. For the API you are really limited in what you can ask and you would still have to process the data locally.
For Data.SE it might be possible to write a complex SQL query.
September 2011
Posts
Id
PostTypeId
Question
Answer
Tag wiki
AcceptedAnswerId (only present if PostTypeId is 1)
ParentID (only present if PostTypeId is 2)
CreationDate
Score
ViewCount
Body
OwnerUserId (present only if user has not been deleted; always -1 for tag wiki entries (i.e., the comm...
PostHistoryTypeId to indicate if it was closed, Comment to see why.
@soandos: A good idea is to use Google to find some queries containing these things to get an idea. Searching for PostHistoryTypeId Comment Join site:data.stackexchange.com could already give some useful joins such that you don't have to write them yourself.
Eventually you'll want to have a table that has the columns the post date, the close date and the close type; perhaps as well deletion of both questions / answers if possible. Then you just filter them into separate files, get one question with all the "not a real question", and so on. Import each into Excel and plot the difference between the dates or something, or at least compute it.
In MSSQL 2008 I have table and data which looks like this
create table #tempData
(user_id int,type varchar(10),ts datetime)
insert into #tempData
select 1,'ENTER','2011-01-30 15:00:00'
union all
select 1,'EXIT','2011-01-31 16:00:00'
union all
select 1,'ENTER','2011-02-1 18:00:00'
union all
sele...
@AshutoshDave When I had my old Dell laptop which had horrible cooling, I would just set up a desk fan to blow across the laptop when I played games. It was in a laptop stand so it was raised up off the desk. It actually did a very good job of improving the cooling...
@JourneymanGeek I just purchased a new 3D monitor... >.>
It's a 3D monitor/HDTV, and it looks all futuristic. So I think I'll like it. And it's a Samsung, and I swear by their TVs, so hopefully it works well...
It's a good monitor, but the glasses aren't syncing perfectly with it, which apparently is common... that and I only can get 3D over HDMI1.4a, which means I get a max refresh rate of 24Hz. That's fine for movies, but crap for games. :P
I'm hoping to be able to use 3D over DVI or DP. Should get it to bump up to 60Hz...
I was hoping that the ghosting was a driver issue, but I tested it with both PC games and 3D gaming on my PS3 and they both have the same problem. Issue is with the PS3, I get even less tweaking options so I can't minimize it by fiddling with the convergence and separation settings...
@JourneymanGeek I'm absolutely not practicing good money habits right now. I just decided that I wasn't satisfied with the monitor I had, so I bought a new one. I think that's going to be it for large purchases for me for a month or two :P
@studiohack: my brother bought it to use when he gets called back to the army since you cannt use camera phones. also, battery lasts for something like 2 weeks
If you want a good flip phone though, I'd say get a Nokia 6650. Same OS, with a couple minor differences. Solid hardware. I had one before the E71x, but it glitched out completely... ROM corrupted or something.
The great thing about the 6650 was that it's a smartphone, but AT&T carried it on their non-smartphone line, so I got unlimited text/data with it without having to go through the higher priced smartphone rates :P
@studiohack thanks for the pointer on winders updates. I have them manuel, and dont care about them at all. but it has been a Long time since the last one.
@studiohack I understand mixed reviews. It's not the prettiest hardware around, but it feels great and works great. Keyboard slides in and out with the right amount of resistence and spring, and no grinding, like some were worried about (I think it was impressions from demo models).
Screen isn't brilliant but it's not ugly either. It's just hard to see in daylight, but that's typical of LCD screens anyway.
I like the hardware Windows button, personally. Though that is a preference thing.
@sidran32 actually, without my aids, I'm stone cold deaf. won't hear a thing. my hearing drops off the charts, I'm about as deaf as a person can be... so with my aids + lipreading, I do pretty well
@studiohack Ya, upgrades aren't a problem. They do have a period before you're eligible for upgrades. Some months, I think. But that's how I got the Quantum. They just restart the 2 year contract on the date of purchase, extending it.
I was just mentioning this as it came up in my mind... my alma mater, Rochester Institute of Technology, is an excellent school. I went for Computer Science and it was great. I just also was thinking, they do have the NTID (National Technical Institute for the Deaf) and a very sizeable deaf community so it may be a good fit, if you want to look into it.
I suppose I'm totally out of the loop regarding "deaf culture". I mean, I knew there was one, being around deaf people all the time there. Just is interesting that you'd feel like an outsider.
@sidran32 I don't consider myself an outsider, I feel part of it, and know some sign, but academically, it would probably benefit me more to go to a "hearing" school, since I've been in that environment most of my life
@studiohack I'm not sure how the NTID operates alongside RIT, but it was pretty common in our classes that you'd have at least one or two deaf students in them. So they were pretty well integrated with everyone else.
Well, I'm a bit awkward in text. I can't really feel comfortable saying "uh huh" all the time in chat. I do in person, and nod and stuff. Missing a whole dimension of communication here :P
Hearing students were even encouraged to take signing courses, but I never ended up doing so, myself. Though I did teach myself how to spell a looong time ago when I was little.
Many do know, though. And many professors learned how to spell at least enough to communicate on a basic level.
They have interpreters that attend classes with you if you need it (they stay with the class, not follow you...). You can also have note-takers (basically, another student in the class copies his notes to be available to you).
I think those were the most common for deaf students.
They have interpreters at all official events, including things like special speakers.
@sidran32 yeah, I have experience in deaf culture and such. when I competed at academic bowls for my state, our team did well, and we were totally immersed in deaf culture for days on end
@SimonSheehan If you still have the FFmpeg thing on your computer, would you mind proofreading my post and seeing if the stuff works for you, and if it's understandable? :)
September 2011
Posts
Id
PostTypeId
Question
Answer
Tag wiki
AcceptedAnswerId (only present if PostTypeId is 1)
ParentID (only present if PostTypeId is 2)
CreationDate
Score
ViewCount
Body
OwnerUserId (present only if user has not been deleted; always -1 for tag wiki entries (i.e., the comm...
In MSSQL 2008 I have table and data which looks like this
create table #tempData
(user_id int,type varchar(10),ts datetime)
insert into #tempData
select 1,'ENTER','2011-01-30 15:00:00'
union all
select 1,'EXIT','2011-01-31 16:00:00'
union all
select 1,'ENTER','2011-02-1 18:00:00'
union all
sele...
