Tavern on the Meta

They don't understand the concept eh?

George Marian

Apparently, not. I'm supposed to take pointers from this resume in order to improve the summary on my resume.

Yeah, I would go with "don't" as well

Moshe

12:30 AM

Yay new iPhone!

!!

@RebeccaChernoff Get any new installs?

I don't think we can track anything besides github's traffic

Since it isn't really actual installs

Moshe

@Jin what sort of mess?

@RebeccaChernoff Oh right; I was thinking of userscripts.org

12:37 AM

Maybe someone who wants to create a kick-ass extension/plugin that works in multiple browsers will get involved (;

It sounded suspiciously like you meant me, but my complete lack of extension knowledge makes that unlikely

Nah, I was not talking about you. (:

@RebeccaChernoff I suppose I could stop being so lazy about that...we should all have a "What to do next?" conversation at some point, as far as code reorganization and extensionification go.

I support this idea.

...Me falling asleep unexpectedly in the middle of the evening is probably not helpful though, so I might need to work on that. yawns

12:44 AM

That's ok, I got here at about 1, I've done about 2 hours of real work, I'm about to call it for the day and just put 6 hours PT on my timesheet and go crash and let my mind wander while I play with the mutts and mull mindless TV viewing.

I've spent way too much of the past week arguing with the school registrar to try and conn them into registering me, so my work hours are all over the place

@MichaelMrozek ah but what do you put on the billable hours sheet? ;)

I try to estimate how long I was actually at work. The main problem is I fill out my timesheets every two weeks instead of daily, so by that point I have little to no idea what actually happened on that day

Yeah, today has been somewhat of an off work day for me as well...but I figure there's plenty of time until I crash again, so hopefully I can get some more done.

@TimStone best of luck with that ;)

@MichaelMrozek yeah, I gotta stop myself doing that on a regular basis ;)

12:51 AM

At some point I'm going to draw a chart of how many people I had to talk to over how many days to get registered for a single class

It's been over a month now

What's the hold up? I'm used to those things not playing out quite right, but an entire month makes it seem like they made a real mess of things.

I'm a part-time non-degree-seeking student, which apparently throws the system into chaos

Concur. I frequently stress registration systems, what with my 7 official transcripts and my desire to do dual minors in a school that rarely sees single minors

Classes started a week ago, I've just been going without being registered

I can't get an account on the CS computers until I'm in the class though, so that's going to stop working soon

So declare a major in business admin and go on to classes

12:53 AM

I can't take CS classes if I'm a business major

@MichaelMrozek Ah, you're The Anomaly. That sucks.

I can't take them if I'm not a CS major, which is the current problem; their registration system won't even let me enroll. I filled out the stuff to take it anyway, and I'm waiting for them to process it

slowly

Ooooh, so really they just view you as a late registrant troublemaker. Gotcha

A week ago I wasn't even enrolled as a student; I've made great progress since then

Gotta love the ole red tape

12:55 AM

They lost my registration documents entirely

Nice

second image result in my search:

wth? ... wow ... hmmm ... wtf?

@MichaelMrozek oh that sucks

That's ok, it only took my last school about four tries to figure out that I was transferring classes, and more than just Lit 101 and Psych 101

I think we'll stick with the first image

Then I had to tell my advisor what the hell I took out of the catalog, because there were no class descriptions or catalogs

@MichaelMrozek spoilsport

Should I remove it as NSFW? Surely not

So anyways ... it only took me two semesters to get all my transfer classes in

Nobody flagged it yet

@MichaelMrozek I'm thinking they wouldn't ...

1:00 AM

I don't dare try something that fancy; I'll settle for taking classes, one at a time

Then when it was time to graduate, I almost didn't get on the list because of my fscking advisor yet again ...

@drachenstern I definitely didn't read the last part of that sentence how you wrote it.

So it was pretty much a matter of me dictating my entire education to the school, rather than the way I observed most students go through the process

:D

looks for caffeine

1:01 AM

In undergrad I had four advisors in four years, two of whom had just joined the school. I told one I was trying to double major and the response was "you can do that?"

@TimStone I assure you he need a FSCK on his core disk ... and a mint for halitosis

@MichaelMrozek sounds like what I went through

I had a triple major for a while, until the other new advisor told me the wrong course order and I didn't take some of my courses early enough, so I had to drop one

One of my friends transfered universities, and her advisor got pissed off at her for "not coming to see her the first year", even though she had only just transfered into the school, heh.

I add some issues with my classes and requirements too, but I was friends with the assistant provost, so those got fixed pretty quickly.

I was supposed to talk to my advisor before registering for grad school, that was one of the hurdles I had to overcome. My records say "Advisor: None"

@MichaelMrozek order matters? wtf?

1:03 AM

@drachenstern Classes depend on each other

@MichaelMrozek I get pre-reqs, but once you've successfully taken the classes, does order really matter?

I'm a firm believer in pre-reqs ... for "most" people.

No, but by the time I realized I had the prereqs wrong it was too late for me to be able to fit all the courses in

There weren't enough semesters left

Here definitions of most generally include "all but one or two people per year"

Ahhhhh

> well aprently everyone thinks im afaird of everyone thats goes to m scholl well im not im not afaird ofany one at that scholl exically hunter lee

pretty please can I correct the 13 year old who has an attitude about how he's just fine and doesn't need any help, least of all from me?

Er. What's that from?

Hopefully not a comment thread

From FB

1:08 AM

Ah. That's less surprising

from my wife's cousin who is from quite the dissheveled home. Dad wasn't ever interested in any but the first son (middle child) and the eldest (the daughter) is quite happy having pill parties (the kind where they just have a big bowl in the room, don't know the "right name for it") and the youngest has these issues. Both of the oldest have been busted more than once for smoking pot. My sister-in-laws tend to give the oldest alcohol whenever she comes to visit. I think she's 18, may be 19.

It's a wonderful lot, that group.

Anybody wanna trade lives? I'll gladly swap for normal!

Ok, I officially give in to today. I'm sure my dogs are starving anyways. may bbiab, time will tell

Q: How can I tell if a corpse is safe to eat?

2:08 AM

-2

I just killed a monster, leaving a corpse on the ground. How do I tell whether it is safe to eat this corpse? I leave the monster unspecified because I am interested in "how can I figure out whether this is edible," rather than whether any particular monster is edible.

food-science

yeah ... -_-

@drachenstern Erm...Wow. That sounds a bit rough >_>

@Reno WTF?

Why did they steal the question from Gaming and post it on Cooking...?

lol

he killed the monster in a game

and he wants tips to eat it from cooking stackexchg

Q: How can I tell if a corpse is safe to eat?

71

I am playing a human wizard, and I just killed a monster, leaving a corpse on the ground. How do I tell whether it is safe to eat this corpse? I leave the monster unspecified because I am interested in "how can I figure out whether this is edible," rather than whether any particular monster is e...

roguelikes nethack

It wasn't his question on Gaming though, that's very odd behaviour.

It's Gaming's top voted question

2:14 AM

> Must resist urge to post on cooking.

@drachenstern Guess someone really had the balls to do it...

guess so

sighs

2:28 AM

Hmm... how to pipe output of command into a new file?

'>'

on what platform?

which output?

@Zypher Well yes, I tried that

@drachenstern Bash

STDERR is 2> yes?

yep

2:30 AM

which output is important, as some programs use both error and standardout

./Markdown.pl StackExchangeScripts/README.md > StackExchangeScripts/readme.html

is it still going to the console?

Trying to generate HTML from the README file there

Oh, hang on, found it. I can really be a idiot sometimes

What output do you get running that command on the terminal screen, and what goes to the file?

or open markdown.pl and see if it's writing to STDOUT or STDERR :)

2:32 AM

I was looking at the wrong directory for the output >_<

lol

happens to the best of us

haha

Zypher I have a good one for you

ooo ... rubs hands together

2:34 AM

I've a cheapo DSL-modem/router running BusyBox (0.61.pre for specifics) and I want to find out what traffic (by explicit URL) my iPhone is touching [and I don't want to jailbreak my iPhone] ... can the busybox tell me?

it's listing domain hosts visited to a logfile (/var/tmp/log_web_activity)

hmm havn't played with busybox ... it's just a pretty iptables distro right? (opens up google)

I do have iptables as a command

I don't need this for long, just for about ten minutes

hmmm ... looks like grep is enables, you should be able to grep for your iPhone's wifi ip in /var/tmp/log_web_activity

yarr, that only gives me domains

I want the full path

ohhh

hmmm

got an old skewl hub lying around?

2:39 AM

nah, last one I had was a trade-for from a buddy for my previous employer, needed it for something similar once, used wireshark with it, wonderful tool

yea, that's what i was gonna suggest ... or even more wizardly tcpdump

I've liked ethereal ever since I first compiled it from source back in about 98

haha yeaa

when i was working at a school we used ... god i forget the name of the program but commercial version of the same idea - when bored we'd sit there watching all the web traffic

found some GREAT sites that way :)

Yeah, up until everybody switched to switches instead of hubs for traffic ...

oh no no ... cisco Catalyst 6k series ... port mirroring :)

2:42 AM

oh well I was never an admin at that point :p

and then there where the bordermanager logs if we where REALLY bored

and i was 17 .. oh how they trusted us waaaayyy too much

If only they could see the trouble you're causing now. ;)

hahah ohhh yes ... i wouldn't be suprised if some of the people that where working there/where students there are on the sites

what editor does busybox use/allow?

vi seems to have been removed, or it's not in the path

looks like vi is there

busybox.net/downloads/BusyBox.html

2:45 AM

:\

what's wrong with vi

not a vi fan?

it's been removed

try ed

emacs guy?

2:46 AM

or if it exists I can't find it on this build

... oh

> busybox vi

> busybox ed

that is the list for the like 1.x family .. you're using a relaly out of date version

to be honest I realize I'm wreaking havoc on things that shouldn't be wreaked in the first place

@Zypher nah, this is .61 pre

haha

sed and awk seem to be there

16 January 2011 -- BusyBox 1.18.2 (stable)

2:47 AM

nope, not here

seems to be the latest ...

yeah yeah, I'm just gonna muss with this the old fashioned ways ;)

magnets and a clean rooM?

solid state memory on chip

Plucking the wireless packets out of the air with chopsticks?

3

2:49 AM

that's how a real ninja would do it

uploading an updated and current firmware?

I could do all that, but that's like work

I'ld rather futz about like this

bah ... just compile chomium from source and put it on there

lol

Updating things is scary.

I don't think that would fit

2:50 AM

@DanGrossman yea you do get used to it though

One time I ran a "yum update" on a year old server, let it update like 200 packages, and left me with a totally broken system

@drachenstern we can do it!

what model router?

spins up chomium build vm

:just realized you can rearrange system tray icons in win7 by dragging:

@DanGrossman What took you so long, hehe :P

1) I never wanted to (and still don't) rearrange anything in the tray

2) You couldn't before... :x

2:52 AM

@Zypher actiontec.com/products/product.php?pid=39

I think locking would prevent that

That looks better

I have my taskbar locked, icon order is still rearrangable

hmm this is a challenge :)

3:37 AM

@TimStone @RebeccaChernoff There?

Hm?

The README.md file needs cleaning up

Han on, let me change the link to the dropbox folder to show you

The readme doc is out of date and hard to read

It needs reformatting, but we need a standard for this

Erm, how is it out of date?

> Keyboard navigation support is also planned.

Oh

3:42 AM

The commands will also need to be reorganized

Yes

Okay, lemme see... for simple commands that take one or no arguments

- ### Purpose (eg. Staring a message)
  **`/command argument`** - `argument` is the id of the message, etc...

It'll produce HTML that looks like this:

<li><h3>Star a message</h3>
    <strong><code>/star [id]</code></strong> - <code>[id]</code> is the numeric id of a message</li>
</li>

Or even, since most of them just take [id], we can avoid repetition by simple stating

"These are the commands that does x on a message. They all take the message id as parameter"

Right

What does github.com/rchern/StackExchangeScripts/comments do?

I don't see anywhere where you can leave comments on projects?

Oh, right comments on commits

Hmm... interesting, we don't really use that though

A: Could we make the new flagging dialog draggable maybe?

It's mostly used for review purposes, I guess.

0

This requires pulling in a large jQuery UI dependency, and given that I think jQuery UI is pretty crappy and bloated.. unlikely.

I want to agree with him here, but I'm having a hard time getting past the fact that jQuery UI is included on the profile page just to show the consecutive days calendar, heh.

3:58 AM

@TimStone They do use the slider component though

@TimStone Yeah, it does seems slightly hypocritical

The calendar module is probably one of the heaviest ones

Draggable should be pretty lightweight by comparison

shakes fist at code Argh, what have I done?

@TimStone Are you refactoring README.md

Because if not I think I'll go ahead and do it

No, I'm doing work-work at the moment...or at least struggling to :/

@TimStone I think there's a difference between the two page sizes tho ...

4:02 AM

This is what ubuntu thinks .md files are

@drachenstern Hm?

@TimStone I mean, the userpage is one thing, but to put it on every route?

@drachenstern SO deploys a single master js file, though I'm pretty sure the datepicker js file is loaded only when you click on the link

@YiJiang once again proving my point :p

@YiJiang No, it's always on the page.

4:03 AM

I get what you two are saying, I just think it's not gonna happen anytime soon

The code that creates it is requested from the server, for some reason.

But the jQuery UI stuff is always there.

Actually I'm not entirely correct either - SO does load several other js file separately

@drachenstern I don't think it should be on any routes.

Hmm. I need a magical SQL query to solve my current problem.

@TimStone did you just flipflop?

4:04 AM

@drachenstern No?

@mootinator talk to me, or post it on dba.SE :p

@mootinator SOLVE my_problem FROM this_database

@TimStone ahhh, reparsing ...

reticulating splines

@mootinator SELECT Bliss FROM Unicorns WHERE Magic = 1

3

I want to aggregate values in the right table and join each aggregate to the left table exactly once.

4:05 AM

@TimStone Ahhh, much better than mine

A: What kind of hardware/software config should I look at for a MySQL database with 10,000 plus tables

I like the posters response to my answer :D

3

Hi @Shawn, welcome to the dba.StackExchange.com website, and it looks like you've got quite a pickle. So before I answer the question that you posed, I'll mention some details to (hopefully) get you off to a good start: 10,000 tables in a database are always wrong. I take that back. If you had ...

I'd suggest you JOIN Waffles too

@drachenstern W3Counter has almost 50,000 tables :p

@YiJiang Good point, what's the foreign key relation between waffles and unicorns?

@mootinator so you pretty much want to like have a sum on child records and present the sum with the parent record?

@DanGrossman why? WHY? for the love of all things holy, why?

is it one per site that you monitor?

4:07 AM

Yeah. Think of the tables as a file system level index.

@DanGrossman so why couldn't you renormalize and have the tablename be a field on the table?

@DanGrossman so you maintain two file system indexes for the same filesystem?

I tried that years ago and it didn't work, swapped the system to death.

tried what?

@drachenstern I have what should be a one-to-one relationship between "Regular Hours" and "Overtime Hours", and I want to select (Regular Hours - OT Hours) AS Regular, OT

One table with website ID as a field on the table

This way, the sites with the highest traffic end up having their tables in memory most of the time, while the lower traffic sites tend to be paged out most of the time.

4:09 AM

The problem being in practice the relation isn't actually 1:1

@DanGrossman this caused the system to die on swapping?

But if I can get the correct total number of hours it doesn't matter if the relation is accurate.

@drachenstern Yes. Consider that this single table would be about 80GB in size and both it and its indexes would be updated hundreds to thousands of times per second

@mootinator I'm a little confused here ... what's the query that's not working?

@DanGrossman but you don't need it to always be in memory do you? You pretty much need a WORM so plenty of indexing wouldn't you?

It's horrible

4:11 AM

WORM?

Write Once Read Many

@mootinator yeah but you wanted help right? :p

@DanGrossman so what kind of RAM do you have in the thing now?

~8GB

SELECT
COALESCE(a.Qty, 0) as Hours
, a.Qty - COALESCE(b.Qty, 0) as regular_hours
, b.Qty as OT_Hours
INTO #tmp_subcont_hours
FROM #tmp_subcont_reg_hours a
FULL OUTER JOIN #tmp_subcont_OT_hours b ON
(a.Resource = b.Resource
AND a.TicketNumber = b.TicketNumber
AND a.Category = REPLACE(b.Category, 'OT', '')
)

The problem is the join condition on Category isn't correct.

As such a 1:1 relation doesn't actually exist.

Cool, I just got the electorate badge on MSO! Yay for gold!

if anyone wants to donate a 96GB RAM server, I'll happily go back to using a single table for all the sites ;)

4:16 AM

lol

is two weeks from the fanatic badge on SO.

@mootinator why is the join on category not correct?

But I find myself not remembering to visit as much lately :O

@drachenstern Because there is no way of entering subcontractor overtime hours in the system, so the data entry people figured out a way to do it, worked around the errors it caused in reports, and didn't bother telling anyone for over a year.

@mootinator let's try again. why does that join not work for what you want?

because it prevents the 1:1?

►

have you guys seen this :P

4:20 AM

@drachenstern TicketNumber, Resource, Category is UNIQUE.

@reno yeah, lol

I'd like to thank this website for keeping my account number confirmation secret:

2

lol

that needs a TDWTF posting

@Reno Yup

@drachenstern But the data entry people didn't consistently use category OTLABOR for LABOR, for instance, so I might have two regular hours entries, WELDER and LABOR, and two entirely different OT lines like OTOPERATOR and OTPSYCHIC

4:22 AM

lol

im one step closer to finally understanding british humour

I posted it here a while back

@Reno It's just a load ol' puns

@mootinator so how do you resolve that?

@drachenstern Send Chuck Norris over to the client's office?

no no no, what I mean is how do you correlate OTOPERATOR to WELDER (for instance)

4:24 AM

Pay a secretary to go through the records and fix them all

@DanGrossman that's what I would do

I credit Code Complete for that suggestion

First thing that came to mind is "rewrite the software so they can't make that mistake"

@drachenstern I could just add OTOPERATOR and OTPSYCHIC hours together and relate them to either LABOR or WELDER and that would be good enough.

@mootinator maybe I'm not being clear. Do you want to account for those?

Alternate suggestion: Don't cut paychecks for overtime entered incorrectly.

4:26 AM

thumbs up to dan's idea

@drachenstern I could ignore them.

@DanGrossman doesn't affect the secretarys or whoever was doing DE

@mootinator then do so

also, what's up with the full outer join on a 1:[0|1]? A LEFT or INNER should work fine

INNER if you want both, LEFT if you don't mind a zero/null

@drachenstern Partially fixed.

It made more sense before I changed anything.

what do you mean partially fixed?

got faster? gave better results?

Sorry, I mean It's a [0|1]:[0|1] relation as written.

4:29 AM

oh well in that case you gotta have the outer

but if there's no base hours then why would you do that?

how can you bill OT where there were no base hours?

Because of the data entry errors.

I'm only trying to consider the business rules

So how do you know a time was an OT time?

working christmas?

@DanGrossman true enough

most OT was entered something like eg: LABORER as regular hours and OTSOMETHINGELSE as OT hours.

Even though the correct category would be OTLABORER

4:31 AM

> Staples has Quartet 3 foot x 2 foot Cork Bulletin Board with Aluminum Frame for $9.99 with free ship to store. staples.com/…

If that were something the system supported, even ;)

Reg:	$41.99
Save:	-$17.00
Now:	$24.99
Instant Savings:	-$15.00
Price after savings:	$9.99

So let's go back a step or three. You said that the key was unique on ticket, category, and resource

@drachenstern Right, but the categories are all wrong.

you have an OT table so I presume you've pretty well filtered out the OT from the non-OT

4:33 AM

@drachenstern Yes, though they come from the same table originally.

so a ticket and resource can have more than one category, yes?

I didn't write it, shh.

Yes.

how often does that happen?

@drachenstern Fairly infrequently, more than never.

Tyler Chacha

Hello

4:34 AM

hi @TylerChacha

are you trying to conjure up a long running script or are you trying to massage data for a once off run / create a set of manual scripts?

@drachenstern Ahh... Don't know yet.

> Register or transfer any available .COM, .US, .MOBI, .BIZ, .NET, .ORG, .CA, .CO.UK and .IN domain for just $1.49 at GoDaddy.com with coupon code WINTER149

SELECT COUNT(Category) FROM #tmp_subcont_reg_hours GROUP BY Resource,TicketNumber WHERE COUNT(Category) > 2

Yet another open source StackExchange clone... this one looks pretty good: osqa.net

4:42 AM

Hmm.

Have to wonder why they replicate not only features, but exact UI appearance and element order... don't they want to improve on it, or at least be different?

@drachenstern Okay. Problem solved. Thanks O_o.

Anyway, I wonder if anyone noticed the 'unicorn' link I snuck into the footer of the SEScripts homepage...

@mootinator ??? How's that?

I read that as code for "I'm giving up now" ... :\

@drachenstern No, I ran a query based on yours. The edge case I was worried about happens exactly once.

4:45 AM

Ahhh, yeah, I tend to do that where I test my edge cases first and work inwards once I have a pretty good idea on what I want

lemme guess, you checked the OT table/source instead?

@drachenstern No, I plan to tell them, "this is wrong, fix it."

Then weave that business rule in somewhere.

bah, sounds like a fix, not a workaround :p

lol

translate.google.com/…

does the happy dance

@DanGrossman Hah, nice.

4:54 AM

The command for flagging is /flag, right?

yes

> ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '/flag' at line 1

> bash: flag: command not found

@DanGrossman userscripts, natch

> '/flag' is not recognized as an internal or external command, operable program or batch file.

Yeah, checked the source. The README is wrong here :|

4:56 AM

Lies!

@YiJiang and you're ... surprised?

Didn't you create the README?

@DanGrossman that's just sillytalk

@drachenstern Jesus, when was the last time someone did serious documentation writing here?

@YiJiang for me? About four ... five years ago

for school ... ohwait, you said serious

4:57 AM

@YiJiang WTF? Where did that /start come from?

@TimStone Bad merge? I don't know

We can spin the WoB to assign blame though