wesd

there is possible performance hit [1]. Also, it could mean that the data granularity has not been modeled well if there are duplicate rows.

https://sqlperformance.com/2017/01/t-sql-queries/surprises-a...

I had similar issue with iOS. I didn't disable in-app purchase and right after installing the game, my 6 year old spent $55 and when I got the receipt email a day later it was too late to reverse the transaction. Lesson learned and in-app option turned off.

That is primary reason why I don't like watching Dr Who. My kids love it but most episodes are magically resolved at end for my liking.

There was a thread about this about a month ago:

https://news.ycombinator.com/item?id=18535748

"This one is funny, and has a couple of obvious solutions that have been prevented due to internal politics. The short answer is that they have a couple of different recommender systems, all competing against each other internally for sales lift. One is purely based off of pageviews. When you get recommendations for something you already bought, many times it is because you looked at it, but they don't know nor care if you already bought it. In their words, it works really well and accounting for sales brings in a lot of needless complexity.

Another is based off of sales. They also don't care if you already bought it because according to them, it works well. I remember trying to point out to them that for some types of products (specifically consumable products) this would work really well, but durables not so much. They claimed otherwise, that although they couldn't explain it, it was entirely common for people to rebuy things like vacuum cleaners and TVs and kitchen knives. I did a tiny bit of research to show them why they thought that, and proved with a small segment (vacuum cleaners, I believe), that after you filter for returns and replacements, that the probability of sequentially buying two of the same vacuum cleaner was effectively zero. They asked me to do it for the rest of their products, but I didn't have limitless time to spend on helping another team, especially one with a PM who was a complete dick to me for having the audacity to make a suggestion that he hadn't thought of.

In all, I believe there are a dozen or so recommender services, each with their own widget. There are tons of people that think all of the recommenders have merits in some areas and drawbacks in others, and the customer would be better off if they merged concepts into a single recommender system. But they all compete for sales lift, they all think their system is better than the other systems, and they refuse to merge concepts or incorporate outside ideas because they all believe they are fundamentally superior to the other recommenders. Just a small anecdotal glimpse at the hilariously counterproductive internal politics at Amazon."

Can an Industrial Giant Become a Tech Darling? (Ep. 357)

http://freakonomics.com/podcast/ford/

I submitted that article on HN but it didn't get any attraction.

It seems Ford CEO thinks they can collect and monetize drivers data: -- So the case I would make is that we have as much data in the future coming from vehicles, or from users in those vehicles, or from cities talking to those vehicles, as the other competitors that you and I would be talking about that have monetizable attraction.

--The issue in the vehicle, see, is: we already know and have data on our customers. By the way, we protect this securely; they trust us. We know what people make. How do we know that? It’s because they borrow money from us. And when you ask somebody what they make, we know where they work; we know if they’re married. We know how long they’ve lived in their house, because these are all on the credit applications. We’ve never ever been challenged on how we use that. And that’s the leverage we’ve got here with the data.

sampleinajar is stating that when doctors were over-prescribing the patient became addicts. When those patients were cut-off from legally buying the drugs, they turned to black market where the quality of the drug is unknown which leads to overdose.

>I walk twice around the earth before even considering a subscription service.

I can't imagine going back not having music subscription service. I don't have to make a decision which album to buy anymore and I don't have to worry about my kids pirating music.

I coach soccer for my kids. The primary obstacle to players development is that they've never watched a game therefore you have to teach them everything.

It seems Ford CEO thinks they can collect and monetize drivers data:

-- So the case I would make is that we have as much data in the future coming from vehicles, or from users in those vehicles, or from cities talking to those vehicles, as the other competitors that you and I would be talking about that have monetizable attraction.

--The issue in the vehicle, see, is: we already know and have data on our customers. By the way, we protect this securely; they trust us. We know what people make. How do we know that? It’s because they borrow money from us. And when you ask somebody what they make, we know where they work; we know if they’re married. We know how long they’ve lived in their house, because these are all on the credit applications. We’ve never ever been challenged on how we use that. And that’s the leverage we’ve got here with the data.

Assume you work from home, you can deduct portion of your internet, electricity, gas bill and mortgage. If you work primarily from home and go into the office, you can deduct millage.

Best thing for you to talk to an accountant.

How is the company paying you? Are you going through an agency? If not, you might have to get an independent insurance.

Google has been trying to tie store purchase to ad impression [1]:

"This location tracking ability has allowed Google to send reports to retailers telling them, for example, whether people who saw an ad for a lawn mower later visited or passed by a Home Depot. The location-tracking program has grown since it was first launched with only a handful of retailers. Home Depot, Express, Nissan, and Sephora have participated."

[1]https://www.washingtonpost.com/news/the-switch/wp/2017/05/23...

That example code seems overly complicated and redundant. Should the code be simpler like this:

  SELECT id
        , max(a) ma
         , count(*) Cnt
   FROM ...
  GROUP BY id

> he doesn't seem to understand the limitations of his own knowledge

He does. When he has a decent Scientific guests on his podcast, he is very deferential but when he is alone, he is very elitist.

>ad-free Youtube TV is bundled in the plan

Only in US.

How does this trend affect new websites such as the Bill Simmions theRinger.com? He has invested heavily on long form writing.

Start by having a strong understanding the various joins first: http://www.sql-join.com/sql-join-types/

How much of a say does Netflix has on the production of the shows? I thought one of the advantage of Netflix was that they don't interfere with the production of the shows and they let the creative people make the decisions.

It's using OMDB.js:

const omdb = require('omdb');

maybe rephrase to desk top only users is around 100 million.

Assuming users are not on both mobile and desktop, then the desktop is around 100 million (DAU less Mobile DAUs):

Daily active users (DAUs) – DAUs were 1.18 billion on average for September 2016, an increase of 17% year-over-year. Mobile DAUs – Mobile DAUs were 1.09 billion on average for September 2016, an increase of 22% year-over-year.

I can get to/from work four different ways. I want to know which way is the fastest. It gets tiring turning GPS on on/off every day just before using Maps.

>Cutting off the ability to work remotely, which is how most people who cannot afford child care manage small children

I haven't seen anyone who can look after a small child and work at the same time. Either you're working or looking after the child.

On the other hand if your argument is that Yahoo should have offered discounted childcare on onsite that Marissa received, then your argument makes perfect sense.

The only difference between UFC and other leagues is that UFC only has 100 million per year guaranteed income from TV rights. Most of of their revenue (600 million last year) is based on gate and pay per views which can fluctuate based headlines and injuries etc.

>Software engineerings in Calgary are lucky to make 70k canadian

I have to disagree with that statement. As an example, here is a system admin job posting by City of Calgary. The pay range is $77,891 - 117,609 per annum

https://recruiting.calgary.ca/psc/pdhr/EMPLOYEE/HRMS/c/HRS_H...

Also the assumption is that you don't need to report on the data. If you need to report on the data then you might need to create index on those columns for performance which you can't do on a blob.

and you can use them in multiple places. I'm not sure if you have the same subquery twice if the query optimizer uses a single dataset.

What's the good reason? Is it because the pricing strategy is charge as much as the customer is willing to pay?

It's will be almost impossible to compare at that level since there are so many contributing factors that affects much one gets taxed. How much does the employee contribute to 401K, does he have dependents, medical claims?

From the readme file:

Database Support

Caravel was originally designed on top of Druid.io, but quickly broadened its scope to support other databases through the use of SqlAlchemy, a Python ORM that is compatible with most common databases[1].

[1]http://docs.sqlalchemy.org/en/rel_1_0/core/engines.html