Readit News logoReadit News
lbreakjai commented on Materialized views are obviously useful   sophiebits.com/2025/08/22... · Posted by u/gz09
malthejorgensen · 15 hours ago
Don’t you have to manually “refresh” Postgres materialized views, essentially making it an easier to implement cache (the Redis example in the blog post) rather than the type always-auto-updating materialized view the blog post author is actually touting?
lbreakjai · 13 hours ago
Out of the box, you're right, but there are extensions that do just that:

https://github.com/sraoss/pg_ivm

It's however not available on RDS, so I've never had the chance to try it myself.

lbreakjai commented on California unemployment rises to 5.5%, worst in the U.S. as tech falters   sfchronicle.com/californi... · Posted by u/littlexsparkee
aurareturn · 9 days ago
I've been saying this on HN since 2022:

For all the pro-WFH/fully remote developers on HN who live in North America, you're going to be in for a surprise when your company decides to replace you with someone living in another country. Why hire you when the company can hire someone who costs 1/5 of you and is willing to work harder without complaining? Both of you are remote anyway. So what if the new hire works at night and sleeps during the day?

For all pro-WFH/fully remote developers living in North America, you should be cheering for return to office mandates. It'll probably save your career long-term.

lbreakjai · 9 days ago
Whether you work from home or not does not change the fact that the work can be done remotely. You think your boss values the watercooler chitchat so much they would really pass on hiring someone at 1/5 of your salary working harder than you?

The return to office mandates were mostly a power play and a cost saving measure.

lbreakjai commented on Tour de France confronts a new threat: Are cyclists using tiny motors?   washingtonpost.com/world/... · Posted by u/bookofjoe
vjvjvjvjghv · a month ago
I totally believe that a lot of basketball/football/baseball players take something. But the effect won’t be as important as in cycling or marathon or 100 m sprint where you need pure physicality.
lbreakjai · a month ago
The effect doesn't really matter. If it gives you a 2% edge, and you don't take it, then you're 2% off the top. That may be the difference between having a career at all and thinking about what could have been at your desk job.

Sure, there's no drugs that will turn you into prime Messi. But there are drugs that will let Messi play like prime Messi for 90 minutes, 3 times a week, 48 weeks a year, which is incredibly valuable.

lbreakjai commented on Tour de France confronts a new threat: Are cyclists using tiny motors?   washingtonpost.com/world/... · Posted by u/bookofjoe
stefs · a month ago
i think that cycling is cleaner than other sports today. the past doping epidemics led to so much bad press cycling faced a huge sponsorship crisis. if another one of the stars would get caught today they'd take the whole sport down with them.

so, if they don't cheat as much, what's left? todays cyclists are actually a lot better than the stars of yesterday, mostly due to better nutrition. training efficiency also improved as the young stars of today are of the first generation that grew up with power meters.

i'm not very knowledgeable in the sport and my last point is a bit of an assumption, but here we go: pro cycling is mostly based in europe. the UAE team is swiss, astana qazaqstan team (a team representing the state kazakhstan) trains in spain and austria. girona (spain, near the pyrinees) is _the_ classic cycling hotspot. this means testing by officials is comparatively easy.

in other sports the training facilities are, for example, in the chinese mountains, russian provinces or in the iranian back country. getting regular testing there is hard. so imo no: cycling today is probably less dirty than most others sports.

tbh i think pogacar is just one of those rare genetic talents that show up from time to time to dominate a sport, but is doubted more than others due to cyclings tainted history. it may be possible he uses newly developed drugs that are undetectable, but i'd say innocent until proven guilty is still applicable here.

lbreakjai · a month ago
Spain doesn't test during evenings or weekends. They've also historically had a habit of turning a blind eye on positive tests, especially if the athlete was Spanish.
lbreakjai commented on Claude for Financial Services   anthropic.com/news/claude... · Posted by u/mildlyhostileux
gyosko · a month ago
Vibe investing is coming and it's going to make a lot of people poor.
lbreakjai · a month ago
Wallstreetbets has been around for a long time.
lbreakjai commented on AWS Lambda Silent Crash – A Platform Failure, Not an Application Bug [pdf]   lyons-den.com/whitepapers... · Posted by u/nonfamous
kevin_nisbet · a month ago
I don’t know about node but a fun abuse of this is background tasks can still sometimes run on a busy lambda as the same process will unsuspend and resuspend the same process. So you can abuse this sometimes for non essential background tasks and to keep things like caches in process. You just cant rely on this since the runtime instead might just cycle out the suspended lambda.
lbreakjai · a month ago
I wouldn't really call this an abuse. I remember their documentation mentioning it.
lbreakjai commented on The day someone created 184 billion Bitcoin (2020)   decrypt.co/39750/184-bill... · Posted by u/lawrenceyan
zahlman · a month ago
> 2.4 million bitcoins are lost forever

I don't have access to the sources for your numbers, but you fail to explain why this is a problem. Physical bills get lost or destroyed all the time, too.

> the same institutions the mysterious man said his system would replace.

I'm unaware of Nakamoto making any such claim. At most there was a goal to provide an alternative to the fiat currency system (https://cointelegraph.com/learn/articles/what-is-the-purpose...).

It turns out that people - most notably merchants - are thus far uninterested in using it that way. Government fiat is how everyone is accustomed to valuing legal tender. Further, government currently will not allow for fractional reserve banking to be done using Bitcoin deposits. FRB is essential to how our credit system works - although I imagine it would also cause a problem for Bitcoin anyway, since its value is supposed to depend on artificial scarcity.

> only a handful of rich people with servers worth millions can actually mine them.

Historically, Bitcoin can be and has been mined on consumer hardware. Whether this is profitable will depend on several factors, but it's one of the reasons that consumer grade graphics cards have increased in price lately. I'm unaware of any major economies of scale here.

> And if you own even a tiny bit of bitcoin, and read something like this, you go ballistic

You have apparently been around HN for 16 years; you should know better than to post like this.

> I can't think of a worse system to fight inequality.

This is a complete non sequitur. "Fighting inequality" is not as far as I can tell a goal of Bitcoin, and in general new technologies have no moral obligation to do so.

> The banks won.

This is fundamentally at odds with your own claim that criminals - especially money launderers - hold large amounts of Bitcoin.

lbreakjai · a month ago
> Historically, Bitcoin can be and has been mined on consumer hardware. Whether this is profitable will depend on several factors, but it's one of the reasons that consumer grade graphics cards have increased in price lately. I'm unaware of any major economies of scale here.

Mining bitcoin with consumer grade GPUs hasn't been viable for a very long time. Any serious miner will be using ASICs. The reason why GPU prices exploded is the double hit of COVID supply chain disruption followed by the emergence of LLMs.

lbreakjai commented on Overtourism in Japan, and how it hurts small businesses   craigmod.com/ridgeline/21... · Posted by u/speckx
arh5451 · a month ago
I'll agree certain locations are getting "instagram famous" and really ruining it for the locals, but I don't think they are worse off because of it. Just let people flock to the one picture spot, they did it before social media, and now there are just more of them, nothing new here.
lbreakjai · a month ago
If anything, the tourists queuing to buy the latest novelty doughnut are not taking up space somewhere else.
lbreakjai commented on Overtourism in Japan, and how it hurts small businesses   craigmod.com/ridgeline/21... · Posted by u/speckx
lbreakjai · a month ago
These sorts of critics always struck me as elitist and pretentious. If reminds me of those kids gatekeeping music genres and claiming you couldn't call yourself a fan unless you listened to the most obscure album of the most obscure band.

Just a fashionable way to say you've been there and done that, and that you're above the hoi polloi.

Popular cities, and popular attractions within, are popular for a reason.

lbreakjai commented on Ask HN: What Are You Working On? (June 2025)    · Posted by u/david927
lbreakjai · 2 months ago
I'm working on a tool to remix/manage my playlists, that's agnostic from the different music platforms.

I used to have an integration in Spotify, that automatically copied my "Discover weekly" playlist into an archive. Over time, it grew close to 10000 songs. It also started to get polluted by ambient sound and kids songs when my daughter was born.

I wanted to clean it up but as far as I could tell, the only way was to do it manually, song by song. I'd want to have something more powerful, that would easily let me rearrange/split/curate my playlists based on any arbitrary constraint.

u/lbreakjai

KarmaCake day129August 30, 2021
About
meet.hn/city/nl-Haarlem
View Original