HNHacker News
TopNewBestAskShowJobs

pqwEfkvjs

38 karma · joined May 25, 2017

submissionscomments
pqwEfkvjs··on SQL style guide by Simon Holywell
> Where possible avoid simply using id as the primary identifier for the table.

I've found the opposite true in my limited experience, at least when doing any sort of ORM, then having id implicitly as the primary key makes life so much easier.

pqwEfkvjs··on Programming Is Mostly Thinking (2014)
So the waterfall model is the best after all?
pqwEfkvjs··on Spreadsheets are all you need
How do you deal with people who don't pay back in time or ever? What's your favourite tool for dealing with such situations?
pqwEfkvjs··on TikTok Is Destroying Itself from the Inside Out
Tiktok is a platform for kids and teenagers (right?), but teens don't have money. So how's their business model even supposed to work?
pqwEfkvjs··on Cold-blooded software
hot bloodedness ~= num dependencies
pqwEfkvjs··on Breakdown of faults by car brand: Tesla has replaced Dacia at the bottom
Tesla owners are probably so rich they can just buy another when the car breaks down.

Or why would anyone buy a Tesla in the first place if they were not angry at money.

pqwEfkvjs··on The Frustration Loop
What's the false positive rate i.e the percentage of legit user getting stuck in the loop?
pqwEfkvjs··on Google is shutting down Stadia
IMO Stadia was born dead because of the lag built into its design. Most googlers I talked to when it was announced did not think about it at all, it was all about how cool the stack behind it was, but from a gamer's perspective I was just terrified about the idea.
pqwEfkvjs··on TikTok and the Fall of the Social-Media Giants
Thanks for sharing this. I just spent last 10 hours reading it, but I need to stop to get some sleep now.
pqwEfkvjs··on Is “acceptably non-dystopian” self-sovereign identity even possible?
EU has already solved this problem 10+ years ago using electronic ID cards. You can transfer money, sign contracts etc with these. You have your private key on chip + PINs for 2nd factor auth. Why not build a block-chain on that tech?
pqwEfkvjs··on Planning is for doing
Don't think, just execute
pqwEfkvjs··on Planning is for doing
> No plan survives contact with the enemy. I've also heard a variation like "It is certain that the plan will fail, however, without the plan everything fails."
pqwEfkvjs··on Ask HN: When did 7 interviews become “normal”?
It is somewhat easy to cheat through these N+1 interviews by grinding tons of practice problems before. At least that was my strategy. Sure I can implement DFS or a linked list, but I am a pretty suboptimal developer, especially when working with huuge codebases.

Maybe they should ask to implement a feature or fix a bug in some huge OSS project. That would evaluate skills relevant for a job in FAANG more closely imho.

pqwEfkvjs··on Fire extinguished at Ukraine nuclear power plant, Europe's largest
How does that justify Russian actions right now?
pqwEfkvjs··on Understanding the War in Ukraine
Oh my god, get a grip man.
pqwEfkvjs··on Understanding the War in Ukraine
No, it didn't.
pqwEfkvjs··on Understanding the War in Ukraine
https://censor.net/ru/news/3318827/rossiyiskie_okkupanty_sda...

It is in Russian, but Google translate does more-or-less ok job translating it.

pqwEfkvjs··on Chrome will stop displaying ads that are repeatedly flagged as disruptive
Just use Firefox with Adblock/Ublock/Noscript. Even better, turn off Javascript and you'll never see an ad again.

Unfortunately, there are too many devs who build their sites that completely get crippled if you by default don't allow Javascript.

Even if you enable it, the site may still be doomed, because it tries to load fonts, libraries, css and who-knows-what kind of s* from external sites.

Fg newage apatheistic anarchist hippie devs. Don't bundle in tons of dependencies to your freaking sites. If one of the dependencies goes down, so does your site. F* you! And f* those whorebag ads!

pqwEfkvjs··on Bitcoin, Bitcoin cash, ethereum and litecoin crash on Friday December 22
Well, now it is a good time to buy.
pqwEfkvjs··on SpaCy 2.0 released
Found the answer myself from the release docs: > The Language.pipe method allows spaCy to batch documents, which brings a significant performance advantage in v2.0. The new neural networks introduce some overhead per batch, so if you're processing a number of documents in a row, you should use nlp.pipe and process the texts as a stream.

So if you have an event based system where you can process only a single document at once, it does not make sense to upgrade yet, because for a single document case the runtime performance was 10x-100x slower, at least with 2.0 alpha version.

pqwEfkvjs··on SpaCy 2.0 released
Kudos to Matthew, Ines and others making this possible.

I haven't checked it out myself yet, so I wanted to ask that are the performance issues fixed that were haunting the 2.0 alpha version?

pqwEfkvjs··on One Year After India Killed Off Cash, What Other Countries Should Learn
and Bitcoin
pqwEfkvjs··on Why Most Unit Testing Is Waste [pdf]
I think it advocates wrong attitude towards software development and I think most points made in the article are just plain wrong and stupid.

I guess the main reason for my condescending sentiment is due that the author gives 0 examples of code that requires tests vs code that does not so it is actually not.

pqwEfkvjs··on Why Most Unit Testing Is Waste [pdf]
Doing TDD is a habit and if a developer does not find unit tests useful or practical, then I don't think they are going to write tests that are more complicated than unit tests.

Btw, what type of software do you write and how do you know if it actually works?

pqwEfkvjs··on Why Most Unit Testing Is Waste [pdf]
Yes, but devs who don't write unit tests are probably not going to write integration or acceptance tests either.

Maybe except of a one guy who I talked to a while ago. He does not write unit tests, because static type checking in C++ takes care of everything that unit tests do (according to him), but I actually have seen his code that contained few system tests, so there are exceptions.

pqwEfkvjs··on Why Most Unit Testing Is Waste [pdf]
"Unit tests are pointless" -- this is often said by developers who suffer Dunning-Kruger syndrome. Except the devs who are actually working on something more exotic that cannot be tested well automatically.
pqwEfkvjs··on We only hire the best means we only hire the trendiest (2016)
I zuum in, which is faster
pqwEfkvjs··on To start a billion dollar startup, start looking for problems
It is far more easier to create problems for whatever you are trying to solve.
pqwEfkvjs··on What I Learned When Facebook Disabled My Account (2012)
Pretty weird, I have been operating a number of fake accounts for spamming, trolling and information retrieval purposes for years and never got a single account blocked.

I've only got challenges to identify people in pictures if too many people deny your friend request in some time window. But this is easy to solve as you can see the faces by searching their name in second window.