h1fra

40 ms·

481.
by h1fra 4y ago
I have answered here: https://news.ycombinator.com/item?id=35701126 In my case, I had to index big tables with URLs, with no need for partial match. I did it naively but did help a lot.
482.
by h1fra 4y ago
I think, in the using Postgres as a queue scenario, it's not fixing the problem that two processes can read the same row at the same time thus both executing the process. If you manually SELECT FOR UPDATE SKIP LOCKED LIMIT 1, then the
483.
by h1fra 4y ago
You can store the md5 (or any hash) in a new column and use it in the index instead of the string column. It will still be a string index but much shorter. You have to be aware of hash collision but in my case it was a multi column index so
484.
by h1fra 4y ago
If it's highly biased indeed, in combinaison of a condition it's useful. I was referring of indexing the column without distinction, the last time I checked (years ago) Postgres didn't do any statistical distribution so the q
485.
by h1fra 4y ago
Few tips I gathered along the years: - Configure Vacuum and maintenance_work_mem regularly if your DB size increases, if you allocate too much or too often it can clog up your memory. - If you plan on deleting more than a 10000 rows regular
486.
by h1fra 4y ago
Isn't the decision coming from the "muslim authority" (sorry I don't know the terms) located in the mecca anyway?
487.
by h1fra 4y ago
Probably because you are very far from the people actually dying from hunger?
488.
by h1fra 4y ago
The article doesn't mention billing, I hope you weren't billed twice? :o
489.
by h1fra 4y ago
Once again, EU laws benefiting everyone. And even this article only acknowledge this at the 3rd paragraph, if you only read the title or the first few sentences it depict Apple as the good guy.
490.
by h1fra 4y ago
Recently discovered Philip Glass through a BBC Essential Mix by Jamie XX (yes!) This music is now forever in my mind: https://www.youtube.com/watch?v=SegECuY22Rs
491.
by h1fra 4y ago
Yes definitely agreed, but most of us are not math model (I hope). We are able to understand right from wrong, we are able to answers with what is true or what we believe is true. We are able to lie or deny the truth. We are able to say we
492.
by h1fra 4y ago
Congrats on launching. People already made a lot of feedback on the product itself so I'll keep mine. Just a few note on the UX: - Recording your own voice should contain a script too, that could help increase the quality of the sampli
493.
by h1fra 4y ago
Oopsie, the infamous id int Auto Increment
494.
by h1fra 4y ago
This is not the take you think it is. The regulation was there to prevent companies from abusing cookies, banner is just a side-effect of companies not willing to respect privacy.
495.
by h1fra 4y ago
USA is a country with one language, one economy and 330 millions people. When you create a company there you automatically unlock a bigger market than EU, the comparison is not fair. Also, anecdotally, SMS was invented in europe so no need
496.
by h1fra 4y ago
I think so yes, but then some people are talking about cache which means it's not really JIT... And then even with cache it's blackboxed, you are not sure it's good or that the cache will not be discarded. #OncallNightmare
497.
by h1fra 4y ago
It's a common pitfall yes, especially bc of big libraries like gcloud ( https://news.ycombinator.com/item?id=32307019 ) Build CI should be configured with a very aggressive upper limit to catch those regression but it&#x
498.
by h1fra 4y ago
Currently building an MVP: - NodeJS, Typescript, Docker - Fastify for the API - Sequelize for ORM (Prisma seems like a good choice too but comes with too many features imo) - Postgres (locally rn) - AtlasDB for migration (I like the declara
499.
by h1fra 4y ago
So much comments saying it's good for kenyans while most of us would not review gore and toxic content all day long for our own local minimum wage. This is clear abuse of cheap labor, and also a good way to not provide psychological su
500.
by h1fra 4y ago
On tiktok you will find various tutorial of how gen z is actually aware of this (without knowing it) and actively fighting the post processing. Especially the low-light picture post processing, where they show how they take a picture, quick
501.
by h1fra 4y ago
Not best practice at all. Multi-language blog posts should be handled via canonical or rel=”alternate” (own google recommendation)
502.
by h1fra 4y ago
Nuclear is expensive to build yet it's the most efficient solution. Electricity (and water, school, roads, etc...) is a requirement to live a decent life. The fact that is unthinkable for you that it could be done without profit is say
503.
by h1fra 4y ago
I don't understand how microsoft can be bring so much in the Open Source world and this kind of things in the OS world. Seems completely out of touch.
504.
by h1fra 4y ago
Not sure what France is doing because Im in Paris and I can tell ipv6 only router does not work. Maybe it's also about mobile.
505.
by h1fra 4y ago
it's even weirder to say that and then say that you will add jsdoc, use tsc and publish types = having the exact the same processes without having a .ts at the end ahah
506.
by h1fra 4y ago
It's funny how different industry can be, in tech most people love receiving swag it even becomes their entire wardrobe ahah I mostly don't care about gifts but there is one that had me burst laughing; Company wanted to celebrate
507.
Mystery pneumonia kills three and infects nine in Argentina(telegraph.co.uk)
1 points by h1fra 4y ago|0 comments
508.
by h1fra 4y ago
I can't believe they are killing the free tier? :o What a drastic change in strategy !
509.
by h1fra 4y ago
Well I paid for a TV, cable network, netflix, disney plus, hbo, prime, switch, playstation and still got tracked and ad displayed. I'm a huge advocate of paying for content and artist (when you have the budget for) but what they are do
510.
by h1fra 4y ago
Actually Europe has been printing a lot of money by having less than 0% interest rate for loan. Current inflation is due to many factor, some estimate it has been slowly growing since 2008, plus covid where we printed money to just to keep

More ›