HNHacker News
TopNewBestAskShowJobs

hn72774

399 karma · joined September 2, 2023

submissionscomments
hn72774··on S3 is files, but not a filesystem
> Filesystem software, especially databases, can't be ported to Amazon S3

Hudi, Delta, iceberg bridge that gap now. Databricks built a company around it.

Don't try to do relational on object storage on your own. Use one of those libraries. It seems simple but it's not. Late arriving data, deletes, updates, primary key column values changing, etc.

hn72774··on U.S. opens UnitedHealth antitrust probe
US spends 50% more per capita on healthcare than the next highest developed country, Switzerland. And double the average comparable country.

It's hard to see how regulated, single payor healthcare could be bigger or more expensive if the middle man is cut out.

https://www.healthsystemtracker.org/chart-collection/health-...

hn72774··on The business of winding down startups is booming
All that is missing is NFT's of the failed company's IP, and an ICO.
hn72774··on Apple to wind down electric car effort after decadelong odyssey
People also do that to get insider info to trade on or for industrial espionage/competitor spying. They'll hang out in the lobby of a building, coffee shops nearby, appearing to work while eavesdropping and taking notes.

At my last bigco job, I was advised not to discuss company matters outside of the office.

hn72774··on Plastic experts say recycling is a scam. Should we even do it anymore?
> If individuals can't be bothered with simple things like this, is there really any hope that any law will help?

I personally think that the law is a waste of taxpayer resources. In the end, stores are still offering plastic bags.

hn72774··on Cities stripping out concrete for earth and plants
Permeable paver tiles can look nice. I like the ones with gaps that let grass grow through.
hn72774··on Portugal eased its opioid epidemic, while U.S. drug deaths skyrocketed
Portugal refers criminal cases to drug treatment.

Seattle took a hands off approach. The prosecutor can't be bothered with drug related arrests, so the police don't bother responding. There is no diversion opportunity.

hn72774··on Plastic experts say recycling is a scam. Should we even do it anymore?
Single use plastic bags were banned here.

Two things happened as a result - the plastic thickness was increased so they can call them reusable instead of single use, and stores started charging for them.

Instead of reducing plastic waste it had the opposite effect.

hn72774··on ChatGPT went berserk
Do different people get different prompts? How hard would it be to generate prompts based on cohorts/personas? Or at an individual level?
hn72774··on Most people with addiction simply grow out of it (2014)
I've heard the first-time heroin experience described as feeling like "being wrapped in a warm, wet blanket." What else feels like that?

A lot of addiction is trying to get back to the comfort of the womb to escape from early childhood traumas and abuses.

You get a taste of that with the use but never get close to it again after.

hn72774··on A bird's eye view of Polars
When reading from the dataframe, depending on the columns, filters, and aggregates you want returned, most query engines can skip data that is irrelevant, making the query run much faster.

In your amazon example the data is probably optimized for fast lookups on a small number of records, like an in-memory cache.

hn72774··on Cousins are disappearing. Is this reshaping the experience of childhood?
> we no longer look to our children for entertainment

Anyone bringing kids into the world for entertainment value is doing them a disservice. These are humans, not pets.

Parenting is hard.

hn72774··on Is the "modern data stack" still a useful idea?
DBT in simplest terms is just a way to orchestrate transformations in dependency order. Table "A" needs to be updated before table "B," because "B" selects from "A." It works well for that.

I've seen it used to get wild west SQL logic into version control. To replace scheduled SQL workbooks running entire data pipelines.

I've also seen over-engineered integrations with other orchestration tools in the "stack."

Once a DBT project grows to a certain size, roughly 500-1000 .SQL files, it gets hard to manage. Not impossible, though it takes intentionality about how to group things together and scale them out operationally.

"Slim CI" is a recent buzzword that has some nice ideas about build automations.

Cosmos is supposed to solve a lot of the automation gripes with dbt. I haven't tried it yet but would like to. https://www.astronomer.io/cosmos/

hn72774··on Someone stole a Jasper radio station’s 200-foot tower, owner says
It's covered in the article...
hn72774··on LTSE shutters cap table management business (formerly captable.io)
What is your budget? Curious what folks pay for this type of service and how the billing is structured.

It seems like there's a gap to be filled between the recent Carta issues and now this.

hn72774··on Why are so many EV charging stations broken in California?
If the whole station was down I'd just go to the next one and wouldn't riot.

I'm a new EV adopter and so far my household gets by with the L1 home charger. We don't drive that far on a daily basis. Home charging is another disincentive to rioting. How much does home charging eat into demand for public chargers?

hn72774··on We need technology that is less immersive, not more
This is a good insight.

"First pass yield" was a metric I liked in the accounting and payments space. How many transactions went through without requiring a manual touch.

hn72774··on Fewer people are buying electric cars in the US
Is a tow-behind gas or diesel generator a thing for longer trips? Charge the battery as the car drives?
hn72774··on Smoking Causes Cancer
There are some pushes to label it as a carcinogen similar to tobacco
hn72774··on To revive Portland, officials seek to ban public drug use
Not the stuff coming in from Mexico and China.
hn72774··on Ask HN: I can't find a job. What do I do?
Not necessarily leetcode, but certainly be able to decompose a problem and implement it with someone else looking at your screen and collaborating.
hn72774··on datetime.utcnow() is now deprecated
It's mostly political.

There isn't a perfect geographical width for time zones. So humans pick something to define the boundaries between time zones. And making boundaries on a map is political.

hn72774··on New York restaurants fight back against reservations by bots
> It also sparked the idea of adding the admission charge to the food bill, so customers would not be asked for money at the door. (In his early years, Dimitriou had encountered profound resistance to a cover charge and he often operated Jazz Alley without one, feeling it set the wrong tone for the kind of fine dining establishment he was trying to create.) It worked, and music lovers in general began to view the club as an upscale destination for special occasions. By 2015, the Alley was taking in more than $3 million in admissions.

This is about Jazz Alley, in Seattle WA.

https://www.seattletimes.com/entertainment/music/how-seattle...

hn72774··on EU data regulator bans personalised advertising on Facebook and Instagram
I'm now feeling like social only exists in real life, not online. We were sold an illusion of connectedness when we were in fact the product being sold. Good marketing. We were told what we wanted to hear.
hn72774··on U.S. GDP grew at a 4.9% annual pace in the third quarter, better than expected
> nihilistic

I don't really see this though replace nihilistic with narcissistic and you may be on to something. It's not a belief in nothing, it's a belief in "I."

We are losing the ability to disagree and still keep it civil for one because of identities being so tied to the -ism of the day and no one accepting that they may be wrong about something every once in a while.

The same drive to be independent and "self-made" is becoming a weakness. It's going to an extreme where every man is an island.

hn72774··on Car Owners Fall Behind on Payments at Highest Rate on Record
Knowing when to call "wheels falling off" is definitely important.

I recently replaced the water pump in the 2014 and the dealer quoted between $4,500-10,000+ for replacing the pump or replacing the engine if the coolant being where it's not supposed to be broke bearings or anything else. I got a second opinion from a small independent shop and he took it step by step and confirmed no engine damage before I committed to the pump replacement. It was around $3,500 total.

Replacing the vehicle would have cost $20k plus, so the math made sense for me to repair. If I was looking at an engine replacement might have gone the other way.

Keeping up with routine maintenance is the most important thing and even then random things do break.

hn72774··on Car Owners Fall Behind on Payments at Highest Rate on Record
Our household has a 2004 sedan with 140k miles, and a 2014 SUV about to hit 100k. Both fully paid.

I had a college econ professor explain that the best way to save money on a car is not to buy used (everyone's first guess). It's to drive it until "the wheels fall off." Depreciation is the biggest cost of car ownership and it stops at a certain point in a car's life. If the car is maintained well, several hundred thousand miles is even doable. I took that advice to heart.

hn72774··on How Google alters search queries to get at your wallet
Noticed the same on Amazon. Searched for Honey Oat Crunch. The first result was honey, then nestle crunch bars. The third result was the Whole Foods brand cereal. Had to click on that listing, scroll to the bottom, scroll through 3 carousels of other products to find the Cascadian Farms brand I wanted.

Then I tried buying the lower priced Whole Foods brand and it had a limit of 3 and a $9.99 delivery fee which offset any savings. Do I drive there to buy it? Is the price the same in store?

At that point, screw it, not going to buy it at all. Too much work just to find what I want. Customer obsession is dead at Amazon.

hn72774··on Lone Wolf, Letting Go
> Once you attach such a label, for example "I'm a democrat", "I'm a lone wolf", "I'm straight", etc., and maybe you even tell people and put it in your online profiles

Love this perspective. I'd add that broadcasting plans or intentions is detrimental. It feels like doing something and gives the dopamine hit without actual doing it.

In a work and personal setting I've found that shifting from "I will" to "I did" is very powerful. And it respects everyone's time better.

hn72774··on Is consciousness part of the fabric of the universe?
I'm not an expert but I think there's a distinction between self awareness and consciousness.

To be an observer of your thoughts, feelings, and emotions is not a practice that's limited to DBT or psychology. It has roots in Eastern spiritual practices.

← PreviousPage 4 of 5Next →