Hacker News Reader

Jestar342on Why SELECT * is bad for SQL performance (2020)

I didn't meant to blame ORM, only highlight the (mis)use of them in this type of scenario - but yes, you are correct. It is an abuse of the repository - ORM or other. :)

Jestar342on Why SELECT * is bad for SQL performance (2020)

It can be extended upon.. I see a lot of ORM based solutions that pull a full record just to check a single property sometimes. E.g.:

    var user = repository.GetUserById(userId);
    return user.IsDisabled;

That's not even a facetious example, I have seen it multiple times. In some cases that query is pulling multiple columns, and a few joins.. just to pull a single bit value.

Jestar342on SVG: The Good, the Bad and the Ugly

shrug The switch to PNG was in haste after we suddenly saw our icons etc all using whatever the last loaded SVG looks like. We already have a PNG "solution" (more like a hack.. someone remembered how to use imagemagick to setup up some build time manipulation of the PNGs -- we didn't even check if we could do this for SVGs we just wanted it fixed asap) plus the designers offered to export the bulk of variants as PNGs for us without much discussion at all, and the rest we made up with the imagemagick hack.

So we jumped to PNGs (like 2 weeks ago, fyi). Now that we (know about, and) can use one of the svg cleaners, we'll switch to that and go back to inline SVGs.

PNGs were always seen as inferior. We don't want extra requests to load them - our app is very sensitive to the number of requests we make - we're importing them as datastrings even.

Anyway, the choice was made. Now we're 90% likely to revert to inlining SVGs with some kind of cleaner in the pipeline. Please don't lose any sleep over it. We'll be just fine.

Jestar342on Learn Functional Programming Visually

Hooks themselves may not be good FP examples, however I meant the resultant functional components that you develop yourself usually are.

Jestar342on SVG: The Good, the Bad and the Ugly

It's a no-go for this use case. Simply because we cannot manipulate the SVG's attributes (at least not as easily) when using them within img tags. Can when they are "inlined". We reluctantly adopted PNGs and convinced designers to provided assets for a whole spread of sizes and colours which doubled or even trippled their workload, just because we were stalling and trying to find alternatives (we have begun building an automation chain for PNG colour conversion etc). Moving forward, I'm going to experiment with one/some of the SVG optimisers and try going back to build/run-time SVG attribute manipulation. It's what SVGs were built for.

Using inline SVGs also reduces our caching complexity _dramatically_. I'm now "just" caching markup with no binary asset caching.

Moving forward I'm going to experiment with

Jestar342on Learn Functional Programming Visually

Likewise most of the hooks (useReducer being the obvious primary example), and functional components in general. That's how 99% of functional programming is done - state and function are separate, first class, concepts. The line is very distinct.

Jestar342on SVG: The Good, the Bad and the Ugly

I decided to switch from SVG with build time manipulation of attributes (scale, colours, rotation, etc) to an image optimisation library (and soon probably a saas like imgix).

I'd prefer to have stuck with SVG had it not been for the I'd collision thing, so with one of these tools in our chain we just might do that.

Jestar342on SVG: The Good, the Bad and the Ugly

Noted, thanks.

Jestar342on SVG: The Good, the Bad and the Ugly

Recently switched from SVGs to PNGs because the toolset the designers are using means every SVG has the same HTML ID attribute value. So when rendering >1 SVG on a page, they all render the same as the last one in the dom.

Jestar342on EU privacy agency urges more safeguards to curb U.S. tech giants

I see the usual OneTrust modal, with a giant, very easy to locate "Reject All" button at the bottom of the modal.

https://imgur.com/uZmlGlc

Jestar342on Homebrew 3.0

Yes, he posted more information in an answer on Quora[1] to clarify why he felt he was turned down.

[1]: https://www.quora.com/Whats-the-logic-behind-Google-rejectin...

Jestar342on Homebrew 3.0

The very premise of this (sub)thread is one of "more users == providing more value" so .. yes, for this conversation, it matters.

Jestar342on The Virus Changed. Now We Must ‘Get to Zero’ or Face Catastrophe

Literally all of them link scientific papers, if you'd care to read.

And it's not "self-infection" that masking is a protection of. Nobody has claimed that. You wear a mask to protect those around you, and they wear their's to protect you.

Though it figures you are obsessed with the self and have no regard for the other.

Jestar342on Why Google needs to build an open chat client like Elemen

We have them already. Xmpp/jabber, IRC, and even email.

Jestar342on The Virus Changed. Now We Must ‘Get to Zero’ or Face Catastrophe

https://www.ox.ac.uk/news/2020-07-08-oxford-covid-19-study-f...

https://www.ucsf.edu/news/2020/06/417906/still-confused-abou...

https://fullfact.org/health/evidence-shows-masks-do-offer-pr...

Please stop perpetuating this myth that masks don't work all because you just don't like wearing one.

Jestar342on Heavy social media use associated with lower mental health in adolescents

Before the internet we were passing video tapes/films, magazines, and prints around with porn and gore. Pre-teen me saw a lot of the kind of things you mention before the internet was a thing. The students at my school had pseudo-competitions for who could get the best porn/gore, earning kudos for the bloodiest gore or "hottest" porn. Often the lines would blur whens someone found scat or snuff but that's a different matter.

Later on in life, I think everyone knew "a guy" at work that had all kinds of taboo material. The Weird Eddies or Creepy Colins of the world had a black-market snatched from them when the internet got popular.

Jestar342on Firefox 85 cracks down on supercookies

> I often wonder incredulously whether developers responsible for particular sites really comprehend how bad performance has gotten.

For every site I've developed and have been tasked with adding adverts, and every colleague that I have worked with that has done the same:

- Yes, we are aware.

- Yes, we doth protest.

- No, we were not successful.

Jestar342on Firefox 85 cracks down on supercookies

Sunk cost is/was my conclusion. At one firm in ~2013, advertising was bringing in $600k revenue per annum - we estimated a loss of potentially triple that (!) - but the response was apathetic. There was very much a reluctance to accept that the "advert management team" (yep, they had a team dedicated to managing the adverts, who had the duty of "managing" Google Ads) would need terminating, too.

Jestar342on Firefox 85 cracks down on supercookies

For more than a decade I've been campaigning (to any of my employers that utilise adverts on their platform) to drop adverts with the primary factor being that of performance for page load. The last time I looked, adverts were adding an additional ~35% load time to the page. Anywhere from 5% to _60%_ (!!) of vistors were navigating away before page load completed (Varied depending on company/product of course) and a staggering 80+% of those vistors would have had a full page load if the adverts were not there.

Jestar342on Software engineering topics I changed my mind on

Nobody has said it should be except for you. As I said it will occur but you should strive to spread information and learning as much as is reasonable.

Jestar342on Software engineering topics I changed my mind on

That's "Siloing" which is considered a negative pattern. If X is the expert, then only X can work on that something*. X is now a bottle neck.

Natural siloing happens, but you (team) should be striving to reduce it, not encourage it.

*More accurately: work can only proceed on that something when X is available*

Jestar342on Why Working from Home Will Stick [pdf]

Has your team productivity actually dropped? You mention things that are supplemental to productivity but nothing about the actual productivity itself. If not, then I suspect there is no more "time theft"* than usual and you shouldn't get wound up by it.

* that is a hideously obnoxious and entitled phrase to use - instead of "distracted" or even simply just "not working".

Jestar342on SolarWinds: What Hit Us Could Hit Others

Terrible and dishonest analogy. The very reason this went undetected for 15 months is because the bridge _didn't_ fall down. There were no signs of a "break in" and it's wholly improper to compare a virtual system to a physical entity like that in the first place.

Jestar342on Ubiquiti Networks Breach

You simply cannot ignore the wider context here. The new leadership is moving development to cheaper regions and, if the interviews and comments about "entitlement" etc are to be believed, you can bet they are not fussed about hiring the best talent in the new regions - they are going to be hunting out the "good enough" agencies and/or employees, which is most definitely going to reduce quality.

I'd like to also add that from my own perspective Ubiquiti gear and software is/was _exceptionally_ good. So converting to "just another network gear company" level of quality is going to have a much greater impact on my perception of the company compared to if this news of off-shoring came from say cisco.

Jestar342on Show HN: I made an alternative platform for professional profiles

Damn, I figured it could have been. :)

Jestar342on Show HN: I made an alternative platform for professional profiles

The irony of attempting to avoid bias, by using "has photo" bias.

Jestar342on Show HN: I made an alternative platform for professional profiles

Discard just the photo or the résumé entirely?

If the latter - do they acknowledge the irony?

Jestar342on Look Up Unknown Phone Numbers Using Facebook Reset Password

Well given the phone book was a list of names, addresses, _and numbers_ you could, in fact, do reverse lookups.

Jestar342on SolarWinds hackers were able to access Microsoft source code

Some licenses very explicitly prohibit source distribution/publication.

Jestar342on Parsing JSON at the CLI: A Practical Introduction to jq and more

Yes, for example other command may be (and often is) fzf followed by yet another command to exec on the chosen file.