tfehring

71 ms·

721.
by tfehring 8y ago
As opposed to SELECT * FROM a, b WHERE a.id = b.id? Looks ok on paper, but in exchange for brevity you end up demolishing your readability on complex queries, since you can’t easily identify filters (as opposed to join conditions). Most sty
722.
by tfehring 8y ago
"Deadweight loss" is a term in economics that refers specifically to loss of producer and consumer surplus due to distortions in the prices or quantities that are supplied or demanded. This is different from the colloquial definit
723.
by tfehring 8y ago
I can't speak to the accuracy of your claim, but Matt Levine recently wrote about another factor, payment for order flow [0]: > They want to buy stock for $99.99 and sell it at $100.01 and clip two cents on each trade. If their orde
724.
by tfehring 8y ago
My point was that the "hyper-meritocracy" the parent comment referred to is antithetical to the dystopia that Diana Moon Glampers represents. There's no point in ruthlessly optimizing for the best candidates if you're go
725.
by tfehring 8y ago
What? Blind meritocracy, even ad absurdum , is exactly the opposite of the "perfect" equality Harrison Bergeron portrays.
726.
by tfehring 8y ago
> Unless you're going to enter a field that requires the pedigree that starts with college (i.e. medicine, law, engineering), it's arguable that college isn't even worth the tuition you pay for it. I'm not sure why i
727.
by tfehring 8y ago
> The media organisation found that only 21% of people quoted in the FT were women, prompting the development of a bot that uses pronouns and analysis of first names to determine whether a source is male or a female. Sounds like substan
728.
by tfehring 8y ago
Because that represents cumulative revenue growth in the range of 100%-150% over three years (revenue was "over $100 million" in 2014 [0]) and it's not difficult to get to a high DCF valuation by (over?)extrapolating exponent
729.
by tfehring 8y ago
Reminds me of this account: https://mtlynch.io/why-i-quit-google/
730.
by tfehring 8y ago
You need to apply the marginal tax rate for California workers, which would typically be ~41% (24% federal + 9.3% state + 7.65% Social Security + Medicare), to figure out how much more is needed on a pre-tax basis. You need an extra $2.5k&#
731.
by tfehring 8y ago
WOW meaning Waukesha, Ozaukee, Washington? Those counties make up a little over 10% of the state's population. I agree that they're important, and I agree that it makes sense to campaign there because they have higher population d
732.
by tfehring 8y ago
Southeastern Wisconsin as a whole only has 2.1 million [0] of the state's 5.7 million residents as of 2014. 600k of that is Milwaukee itself. [0] https://www.dhs.wisconsin.gov/population/southeastern.htm
733.
by tfehring 8y ago
Any qualified person who's willing to move to the Milwaukee area. If you're not from Wisconsin and you're willing to move out of state after graduating, of all the places you could move to, why on earth would you choose Milwa
734.
by tfehring 8y ago
Minor clarification: do you actually need to choose TimescaleDB xor Citus? I thought the fact that both are Postgres extensions (as opposed to forks) meant that they could be used jointly.
735.
by tfehring 8y ago
I agree, and yes I would.
736.
by tfehring 8y ago
Sure, but the reason for that privilege is also the reason it matters so much. If you're considering whether to take a menial job in a warehouse or call center or something for a SoftBank-funded company, you're probably in a less
737.
by tfehring 8y ago
I’m in the late stages of the interview process for a heavily SoftBank-funded company that would otherwise be my top choice, and I’m strongly considering turning them down because of that. So if you want a definitive answer, ask me again in
738.
by tfehring 8y ago
The normal density function does fall out of proofs of the CLT. Usually those proofs stop at either the characteristic function or the moment-generating function of the normal distribution. From a proof that results in the moment-generating
739.
by tfehring 8y ago
I assume you mean Toronto, not Vancouver, based on the parent comment. Median household income in Toronto is $65,829 CAD as of 2015 [0], which is about $52,500 USD adjusted for purchasing power parity [1]. Chicago's median income from
740.
by tfehring 8y ago
One reason is the lack of native support for columnar storage (though an open source third-party extension exists: https://github.com/citusdata/cstore_fdw ) The need to manually update clustered indexes, and the fact th
741.
by tfehring 8y ago
> I'd much prefer a dollar spent in the private sector so the government doesn't have to spend two just to accomplish the same thing. This is a false equivalence because the government and the private sector spend money on ver
742.
by tfehring 8y ago
Disclosure: I work for an insurance company that sells annuities. This is solely my own opinion, and I have no incentive to get you to buy an annuity. With that out of the way, a few comments on this: * Tontines were exorbitantly profitable
743.
by tfehring 8y ago
How large are we talking? I haven't had any problems with dplyr performance as long as my data fits in main memory. (I have 16GB, so that means single digit GB data frames at most - I realize that doesn't qualify as "very lar
744.
by tfehring 8y ago
I agree that they don't seem like they're strapped for cash, but it's still a strange use of investors' capital. If Stripe's investors wanted to invest in Lambda School, why wouldn't they just do so directly? A
745.
by tfehring 8y ago
In fact, various US government programs use taxpayer money to shield parts of the population from negative consequences of climate change already. For example, FEMA and the National Flood Insurance Program subsidize property owners in high-
746.
by tfehring 8y ago
Did any new information about its accounting irregularities come to light on Wednesday or Thursday? If not, why would they have driven the stock price decrease on those days?
747.
by tfehring 8y ago
Great point. I'll add that even within communities that are narrower than the whole Internet, we probably have more context-specific relationships than we did in the past, and that we compare ourselves to others within those contexts
748.
by tfehring 8y ago
> insurers should stop negotiating individual rates with providers and instead providers should have a set price they charge no matter who pays It's not that simple, unfortunately. For one thing, Medicare reimburse at rates that ar
749.
by tfehring 8y ago
Businesses that accept credit cards are already prevented from offering cash discounts by credit card companies’ merchant agreements. No lobbying needed. Also, savvy buyers can already make back most or all of the processing fees that are b
750.
by tfehring 8y ago
Extension or not, that's a really useful shortcut. Coming from SQL Server, the best option I know of requires a CTE or subquery: WITH CTE_messages AS ( SELECT * ,row_nbr = ROW_NUMBER() OVER(PA

More ›