HNHacker News
TopNewBestAskShowJobs

dapearce

245 karma · joined April 3, 2014

https://dapearce.com
submissionscomments
dapearce··on Toyota confirms third-party data breach impacting customers
Reads a bit like it could have been a dealership or dealer network that was breached.
dapearce··on AT&T says criminals stole phone records of 'nearly all' customers in data breach
No dates or timestamps included meaning they were using the data to build a social graph.
dapearce··on Self-Serve Dashboards
I've implemented self-serve analytics at three organizations successfully. It's important your data is well organized, well labeled/defined, and the BI tool needs to allow you to configure guardrails around how data is queried. I have used Looker as the BI tool at all three organizations. End users do not need to even define joins. They just select the grouping and aggregate columns they want to return and click run, then configure their visualization from the data. It is true that some users are not data literate and still will not run their own queries, but from my experience a lot of non-technical business users love being able to easily explore data themselves, and the business receives a lot of value from it.
dapearce··on Why time seems to pass faster as we age
I was always told it's because as you age a year becomes a smaller portion of your life. When you are 35 a year is 1/35th of your life, compared to 1/5th as a 5 year old.
dapearce··on OpenAI's misalignment and Microsoft's gain
Ilya has backtracked and signed the letter saying he would also leave to Microsoft if the board doesn't resign.
dapearce··on Toyota: Car location data and videos of 2M customers exposed for ten years
> It is important to note that the exposed details do not constitute personally identifiable information, so it wouldn't be possible to use this data leak to track individuals

The data included timestamped GPS data, which has been demonstrated to be easy to de-anonymize.

dapearce··on Arrest made in SF killing of Bob Lee – alleged killer also worked in tech
In this example there is enough evidence the suspect has been arrested by police, which is a public record. Not remotely the same as the Boston bomber reddit-misidentification case.
dapearce··on SQL Maxis: Why We Ditched RabbitMQ and Replaced It with a Postgres Queue
Yes, copy/paste error just fixed!
dapearce··on SQL Maxis: Why We Ditched RabbitMQ and Replaced It with a Postgres Queue
Love to see it. We (CoreDB) recently released PGMQ, a message queue extension for Postgres: https://github.com/CoreDB-io/coredb/tree/main/extensions/pgm...
dapearce··on Postgres as a graph database
Also see Apache Age, a graph database extension for Postgres: https://github.com/apache/age
dapearce··on Ohio catastrophe is ‘wake-up call’ to dangers of deadly train derailments
Vinyl chloride is a declared brain, lung, blood, and liver carcinogen.

https://www.fastcompany.com/90848025/ohio-train-derailment-t...

dapearce··on FCC to remove companies from robocall database for non-compliance [pdf]
I wish you could apply it to specific area codes. The area code of my phone number is not an area I have lived in for several years now. 98% of my spam calls are from this area code but none of the important unknown callers are calling from this area code.
dapearce··on Ask HN: How do I improve our data infrastructure?
1) Look at 3rd party solutions (Stitch, Fivetran, Segment, etc.) to ingest your raw data into a data warehouse (strong preference for Snowflake).

2) Use dbt (https://www.getdbt.com) to clean, transform and model the raw data into analytic tables.

3) Add a BI layer (Mode, Looker, etc.) on top of the analytic tables for reporting.

dapearce··on Managing your Amazon Redshift performance: How Plaid uses Periscope Data
Yep, we had similar Redshift issues and ended up switching to Snowflake.
dapearce··on Managing your Amazon Redshift performance: How Plaid uses Periscope Data
Great post. Check out dbt (https://www.getdbt.com/) for materializing your views, lots of great features and a great community.
dapearce··on Google Is Training Machines to Predict When a Patient Will Die
>Customer A does not receive full medical support because "he's dying anyway"?

Unless the patient consents to stop or reduce care, this would be medical negligence, which is illegal (in the US). Medical providers are required by law to provide medical treatment with all the knowledge and skill they possess.

dapearce··on My Sony "smart" TV has updated itself and tried to force me to use a new app
Family members co-founding a company isn't nepotism.
dapearce··on On Phone Numbers and Identity
Will 1Password detect and autofill these or do you have to look it up?
dapearce··on Paid $75k to Love a Brand on Instagram – Is It an Ad?
This is an industry I'm familiar with and I'd love to hear some debate on this. In my opinion the industry resembles celebrity endorsements and product placement much more than digital advertising.

Do celebrities need to disclose they are being compensated to mention a brand on the red carpet?

Do movies need to start including #ad in scenes that have paid product placements?

The idea of endorsements and product placement go back for decades, and this is no different. What distinguishes this from the examples above, and if "ad" needs to be disclosed with influencer posts, why does it not need to be disclosed with celebrity endorsements and product placement?

While there are certainly exceptions (cough Kardashians) a heavy majority of influencers won't post about brands or products they don't genuinely like and believe their audience would be interested in. They won't muddy their name with a bad brand. So why do they need to be paid to post? Because they aren't going to spend the time to create and share content for free.

dapearce··on Coming changes to Apple's App Store
What about $0.99/mo, or even $0.49/mo? My initial reaction is the same as yours, but I could see myself agreeing to $0.99/mo for some of the apps I paid $2 or $3 for. Still relatively cheap for me but would dramatically increase income for the developer.
dapearce··on Microsoft, Google, Facebook Back Apple in Blocked Phone Case
Did you read their motion?[1] It is very much part of their argument. It sets a precedent that not only will other US courts compel them to unlock devices, but other countries will as well. Even if you trust the US government to not use the software maliciously, do you trust other governments?

1) https://www.documentcloud.org/documents/2722199-5-15-MJ-0045...

dapearce··on Microsoft, Google, Facebook Back Apple in Blocked Phone Case
1) It's a backdoor because it's software, not a physical device like your example. They are not asking them to make a robot finger to push the buttons. It's not only more trivial to unlock the device, it's significantly more likely the software is copied and leaked into malicious hands.

2) The outrage, in my opinion, is much more about your exact example -- that Apple is being compelled to develop this software themselves. That they are being legally required to weaken the value of their own product.

dapearce··on Crystal, iOS ad blocker, to accept money to let ads through
According to the article it sounds like an optional feature which can be turned off.

It allows people who want to support ad-based publishers with quality ads, while still blocking the heavy junk.

Not an unacceptable thing to me, especially if it makes the developer some extra money without forcing me to let the ads through.