HN user

dsauerbrun

165 karma
Posts4
Comments69
View on HN

Hmm, if the caching layer doesn't change(I assume it was optimized for olap style queries), and the new parquet format is better for olap... I'm still not understanding how it performs well for oltp reads.

I'll give the article another read... Maybe I missed something. Thank you for the response! Really nice to be able to get info straight from people who work on the product

Maybe I'm too stupid to understand the article... How does this achieve performant querying for olap and oltp purposes?

Based on my understanding, olap queries will go to the parquet files which are stored in a columnar fashion and oltp style queries will go to a caching layer that sits on top of those parquet files?

What's the special sauce here? Seems like they're just caching the data which, for all intents and purposes, seems like the same solution of storing another copy of the data which is what they say they're avoiding.

one of the benefits of being on android and being able to sideload apps. Look up "revanced youtube" and you'll be able to turn off shorts.

ublock origin for blocking them on desktop. If you're on an iphone... uninstall youtube?

my quality of life has increased substantially... although sometimes the app bugs out and shorts still make it on my home page. I spend like 10 minutes scrolling through shorts and get a weird shock "how the fuck did I end up here?", restart the app and boom shorts gone again.

this seems like an interesting idea I'd like to try but all the permissions it needs is terrifying to me... I understand why it needs them but there's no way for me to verify that they aren't doing anything funny with that access.

I'm a bit confused.

The lossy timeline solution basically means you skip updating the feed for some people who are above the number of reasonable followers. I get that

Seeing them get 96% improvements is insane, does that mean they have a ton of users following an unreasonable number of people or do they just have a very low number for reasonable followers. I doubt it's the latter since that would mean a lot of people would be missing updates.

How is it possible to get such massive improvements when you're only skipping a presumably small % of people per new post?

EDIT: nvm, I rethought about it, the issue is that a single user with millions of follows will constantly be written to which will slow down the fanout service when a celebrity makes a post since you're going through many db pages.

casualties refers to injuries as well as deaths. I think the citation they were looking for was for the ~2800 number. I don't think it's reasonable to say that 6/12 killed were civilians, so half of all casualties were civilian.

We dont know until we get more reports, like you said, it could be higher... but it could also be lower.

whoa that's very cool. can you share some info about how you set up the integration in ha? would love to explore doing something like this for myself

gyms are typically softer to give their clientele a feeling of progress. this makes people feel better and want to come back. if you're stuck at v3 for several months you'd be more likely to give up telling yourself you're not cut out for climbing... at least that's my(and many others') theory behind soft gyms

Ditch That Else 3 years ago

you should mention it. When I was a junior programmer I also wrote the nested ifs and I had a mentor show me how much cleaner the code could look which I really appreciated. I continue to use this style which is far superior than the one I started with.

you're looking at this from a very narrow perspective in terms of use case... one of my favorite climbing areas near me(shelf road) became a reservation through rec.gov only campground. I used to show up on Saturday morning, pay $7 for one night to camp, and leave Sunday afternoon after my 2nd day of climbing.

as of 2 years ago rec.gov took over and kept the same $7/night rate but added an $8 service fee.

it's complete bullshit for those of us who regularly use government recreational services.

Fairphone 5 3 years ago

I thought rcs provides this and is supposed to be a better alternative than iMessage... am I mistaken?

I don't solo regularly but I have soloed a few things(5.6 is the hardest I've soloed if you're familiar with climbing grades).

my answer to this is basically once you've gotten to a certain level in climbing, some of the lower levels feel effortless and it doesn't actually feel risky. As an aside, roping up for some of that easier stuff wouldn't be worth it because it would just take too long.

Take walking up stairs, that feels incredibly easy and risk free to your average person but if you slip and fall down a flight of stairs you will most likely get pretty badly injured or potentially die... but no one puts on a rope to go up stairs because the risk level is so low even if the consequence level is very high.

that's how I feel about soloing and I suspect its how many others feel about it too.

fwiw, climbing hard stuff on a rope is way more fun for me than easy stuff without one but to each their own