HNHacker News
TopNewBestAskShowJobs

MSM

636 karma · joined April 17, 2012

submissionscomments
MSM··on The best Postgres feature you're not using – CTEs aka WITH clauses
I think you're either very selective with your sources or very selective about who you give the "expert" title to. I don't know that I've seen implicit joins used by a speaker at a SQL event in the past couple years, unless it's for cartesian joins.
MSM··on Why we're losing $300 per user every month
You're really, really overthinking this. How much does it cost to assign a word to $SEO_PHRASE? Nothing. How much money magically flies out of their bank account whem they pick up the phone to talk to a customer? Nothing.

However, if they have someone on their payroll making $100k/yr and that employee spends a day with a customer gathering feedback about the product and what the customer would like to see going forward, that's going to be an opportunity cost of ~$300. It's just an investment. They aren't making money right now- they are spending money paying the (hopefully) right people to determine what they can do to (hopefully) maximize their viability later in the product's life.

MSM··on Richest Bitcoin Addresses
Hmm, I must be misremembering then, I know I didn't have 50.
MSM··on Richest Bitcoin Addresses
Way smaller scale but back in 2011 I heard about bitcoins and crunched some numbers. I realized that at the current price (~$16), I was able to make profit mining them on my desktop since it would only cost about ~$12 in electricty per coin.

I got myself 3 or 4 coins (I wasn't even in a pool at that point) but then the price crashed in late 2011 and I eventually forgot about it. Since then I've reformatted and I remember having that "Oh shit" moment as I was reformatting but after looking up the price I realized I was only out about $10. This was late 2011.

Now every time I see a HN post about a new price milestone I kick myself. Today I could have sold them for ~$1500-2000.

MSM··on TWTR
Currently with more market cap than Marathon Oil which hasn't posted a single quarter with less $250M in income since 2008.

Totally makes sense....... right?

MSM··on SQL Fiddle
Fantastic tool.

It pops up constantly on StackOverflow and I've found it incredibly useful for interviews. I noticed recently that the Execution Plan was added which just opens more avenues for teaching & interviewing.

MSM··on 500k queries per second with MySQL 5.7
It's admittedly hard to follow the writing style, but it's mentioned many times that these are read only queries.

I agree it's a little misleading, but at the same time if you're really in a readonly DW type environment you'd be crazy not to have all of the settings enabled to push throughput to the max.

MSM··on Apple’s iPhone 5 touchscreen is 2.5 times faster than Android devices
I think you have valuable insight here and you've got some helpful anecdotal evidence, but the whole dollar sign before the ticker thing made me immediately think of the "M$" people.

I'm assuming you're giving the ticker syntax, but it almost made me question your post, especially considering you're speaking against the iPhone. Just a knee jerk reaction from a passerby.

MSM··on Tesla Model S Outperforms Aston Martin
I really hate these comparisons. What is the Model S trying to be? A luxury car? A sports car? A trip vehicle? Every article I read compares the Model S to some abhorrently expensive vehicle that does some specific thing poorly in comparison to Model S. I'd be much more interested in reading a top to bottom comparison between the Model S and a similar car. Do it with a BMW M3 or something, a reasonably priced luxury car that still tries to tailor to the sporty crowd.

The Rapide is a $150k car that is outperformed by a $25k Ford Mustang. No one has ever gone into the draft room and thought to themselves "If only I could design a vehicle that cost less to produce than the Rapide AND was sportier!". Outperforming it is not an achievement.

MSM··on AMC is succeeding by breaking the rules of legacy television
While we're doling out "Did you read the article" comments, the article also mentions that HBO is in a league of their own when it comes to distribution. They have their own streaming network (HBO GO) and new espidoes are released immediately.

I think HBO definitely had a strong hand in pioneering AMC's current model.

MSM··on How A Police Officer Threatened A Yelp Reviewer
That's a fair view.

My view is that I'm sure the garbage gets emptied, and you're left a dirty bin in the fridge. Maybe it's not the cleaniest thing to do.

To me having this guy complain about the (in my opinion) small things he is complaining about makes it obvious there aren't more urgent health concerns with the place. I would definitely eat there.

MSM··on How A Police Officer Threatened A Yelp Reviewer
I feel the same way. I looked at the review that was posted and I didn't see anything that was really that bad about the pizza place. He kind of blew up a few things, so I can see why the owner would be upset. Of course the owner probably took it too far as well.

As for the review:

He had a big problem with putting the trash cans in the walk-in, but I don't really understand why. I leave my trashcan open and in the kitchen all day everyday. Am I putting myself in danger without realizing?

He found some synthetic pot (but isn't that legal?) along with some insulin needles and came to the conclusion that it was narcotics. I had a chuckle when I imagined some guy shooting up heroin on the job but then getting synthetic pot in lieu of the real deal. I just can't imagine. Did he ever consider that the guy was diabetic?

MSM··on Valve releasing Dota2 for Linux
I (unfortunately) think you'll find that this was due to it being in beta. Hopefully I'm wrong and the community stays relatively decent, but I'm not confident in it yet.
MSM··on “The Tesla Model S is our top-scoring car”
They're both invisible to a blind person.
MSM··on The Amazing Life of Sean Smith, the Masterful Eve Gamer Slain in Libya
It depends.

I have a lot of fun toying with the market and writing apps to leverage APIs to make me money in game. If I'm station trading (Which I have been a lot- this is similar to playing the stock market in that you sit in one place and buy low sell high) your orders cannot be updated more than once every 5 minutes. I'll usually have EVE up on a monitor but I'm not paying much attention to it. I'll pop over to the game every 20-30 minutes and quickly update orders then head back to my coding project / a blog / etc.

I also have swings of near obsession where I'm really excited to play with something new to me. When I was learning about exploring I spent probably 6-7 hours in a row flying around and tracking down litle exploration sites.

I log in maybe 3-4 days a week, but only get a nice block (more than a half hour or so) of time maybe once a week. I'd say the game is up on a monitor and accessable to me probably 15 hours a week. I'm probably actually spending more like 5 hours a week actively engaged. Honestly I have probably spent the same time coding applications around the game as I have playing.

I started the game solo but have since realized that a couple friends also play but weren't vocal about it. Occasionally we'll play together but I don't have the time or desire to join a permanent group ("Corporation") yet so I've been playing lone wolf for the most part.

I believe you can start the game for free with a 14 day trial. There are also 21 day trials that are available if a current player reffers you. I've never done it so I'm not sure on the details on that though. Either way, you should get a good taste of what EVE can offer you after that period.

MSM··on The Amazing Life of Sean Smith, the Masterful Eve Gamer Slain in Libya
As someone who starting in January, I would disagree with this.

The most HN relevant things that are awesome about EVE are how open the devs are with data. The developers have released their databases (Items, ships, stations, etc) which I have made some extremely handy apps with. The market is a ton of fun to play with an also has pretty easy to use APIs (Eve-Central). A lot of the files can be read extremely easily, and there is apparently talk of making market orders updateable via API in the future (This could mean full or partial automated trading).

With my ~4 month old character I've explored low-sec, played in worm holes, gotten into PvP fia FW, etc. There isn't much I haven't been able to do and I currently have more ISK (~2B) than I can really lose with the ships that I'm currently flying.

MSM··on Programmer Creates An AI To (Not Quite) Beat NES Games
You're taking this way too seriously. Think of it as someone tinkering with a specific algorithm who happens to overlay it ontop of NES games to show that it's working.

It's a cool project. If this is nothing compared to the things you've done, you're welcome to post them- we'd love to see them!

MSM··on Top Reasons I like Postgres Over SQL Server
To be even more pessimistic you could point out:

1. Read Committed is not that restrictive to be honest. If you're short on memory it can be an issue but even in a high frequency system it should only lock at the row level. Beyond that, why would you be pushing to read dirty data? That's an issue in and of itself.

8/9. Arrays? JSON? XML? It's not relational data. Either parse it or put it in a different system, no RDBMS is going to handle these very well because they break the 'Relational' part. They might be accomodated, but trying to work with them is not a good idea in the vast majority of cases. I'm promoting SQL here and I still have to point out that SQL handles XML like crap too, try and index an XML blob.

MSM··on This Man Thinks He Never Has to Eat Again
I agree with you, but I think the main sentiment is that after just 6 weeks you can't come to any conclusions.

For example smoking is probably one of the worst things you can do for your health long term. I can smoke two packs a day and have absolutely no issues after only six weeks. Eating crap food is bad for you, and it might kill you after 40 or 50 years.

Looking at some of the issues he has having (heart racing) due to lack of iron. What if the symptoms weren't as obvious? He'd have never looked to see why he was experiencing them. It's really hard to get excited about something when he's only been doing it for such a short time and it's fairly obvious he doesn't really know what he's doing.

MSM··on What Thomas Edison expected job candidates to know
And you're willing to admit that a webcomic convinced you of that?
MSM··on Apple Slashes MacBook Prices by up to $200
Looking at the value of AAPL we can see that this is not the case.

For us, sure. I don't have time to get into the details of AAPL and why I may or may not want to buy them. I honestly don't have any idea if it's a good buy. However, it's 67% inst. owned and I'm willing to bet that every single instituion that owns stock has its own person who is crunching numbers and assesing value. The fact that the big spenders are fighting with each other to sell it instead of buy it means it's more than just "goofed" estimates.

MSM··on Apple Slashes MacBook Prices by up to $200
Because Wall St. owns the company. That's one of those crazy side effects of going public.
MSM··on How I Force Myself to Take Breaks
I agree with you, however a sizable portion of water you take in comes from the food you're eating as well.
MSM··on Three charts are all I need
What's wrong with being boring?

If I can completely understand it without giving a hint of effort, that's perfection.

MSM··on Valve And Xi3 Team For ‘Piston’ Steam Box
PS3 was $500 for the lower version, $600 was for the bigger HD. It also didn't sell well. PS3 didn't start to pick up in sales until the price started to drop, and at the time of release PS3 was incredibly powerful.

I can't imagine someone dropping $500-$1000 on this, at that point just build your own computer people!

MSM··on What's the next product that will disrupt the smartphone industry?
A little bit of a side story about something that really opened my eyes last week.

I ordered a package that was shipping through UPS and when I called I was dismayed that there wasn't a way to enter my tracking number (It was 15ish alpha-numeric characters) besides speaking. So I thought "Okay, AAyyy--Fiivvee--Geeee..." I was about half way through slowly saying the tracking number when I was interrupted "Package not found, try again?"... Okay. "I must have to rattle this off pretty quick" I thought, so I blew threw it. It immediately found my package, told me where it was and when it was expected to arrive.

It was amazing. Voice recognition was good enough that UPS deems it fail-safe enough to have it be the only way to find a package by phone. That was the first time I really thought there might actually be a chance for an almost fully speech operated phone without a traditional UI.

MSM··on Buy Nothing Day
My point was, it's all relative.

Even poor people spend money on non-necessities. I watched a documentary on how being able to afford a Coke is a sign of status in many third world countries. They obviously don't need Coke, but having it seems to make them happy (I can't complain, I love it as well). Even though they might not be able to afford many of things we deem important, they manage to get enough change together to buy a soft drink.

There is little we can do to help those in the poorest countries. We can give our time or our money, but rarely are either of those things given. I'm going to go out on a limb and assume you've never taken time away from your job to spend a week in Liberia or Eritrea. Is it a problem? Probably. Is it something that is going to be solved by not buying anything today? Of course not.

MSM··on Buy Nothing Day
I buy plenty of things to make me happy.

I don't need the internet. Either do you. I also don't need to eat anything other than bean tortillas, but I will. I could probably get through my life wiping with single ply, but I'd rather have double.

If that makes me a bad guy in your eyes, ah well. I'm sure a few of the beers I went out my way to purchase will ease the pain.

MSM··on How Nintendo DRM trapped $400 of downloaded games on my failing Wii
As others have said, this is probably easily solved by calling and just explaining the problem. It was mentioned multiple times in the article that this case was a fringe scenario (he had old software, first gen, etc). It doesn't even sound like Nintendo is trying to employ DRM to do anything dirty, it sounds like there were simply issues with early Wiis that weren't addressed.

If you decide to skip all that crazy talking-it-out nonsense and take Nintendo to small claims court, you pretty much deserve to lose your filing fee and time screwing around with the courts.

MSM··on Netflix CEO: Amazon Losing Up to $1 Billion a Year on Streaming Video
He'll probably say something along the line of

"In '97 Amazon had market cap of $291M, in '02 it was 3.5B, in '07 it was $20B and today it's $100B. I don't know... seems to be working."

← PreviousPage 5 of 7Next →