Hacker News: Jestar342

New comment by Jestar342 in "Why SELECT * is bad for SQL performance (2020)"

Jestar342 — Mon, 15 Feb 2021 16:30:47 +0000

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. :)

New comment by Jestar342 in "Why SELECT * is bad for SQL performance (2020)"

Jestar342 — Mon, 15 Feb 2021 15:58:38 +0000

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.

New comment by Jestar342 in "SVG: The Good, the Bad and the Ugly"

Jestar342 — Mon, 15 Feb 2021 15:51:33 +0000

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.

New comment by Jestar342 in "Learn Functional Programming Visually"

Jestar342 — Mon, 15 Feb 2021 15:43:35 +0000

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

New comment by Jestar342 in "SVG: The Good, the Bad and the Ugly"

Jestar342 — Mon, 15 Feb 2021 09:09:53 +0000

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

New comment by Jestar342 in "Learn Functional Programming Visually"

Jestar342 — Sun, 14 Feb 2021 18:22:24 +0000

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.

New comment by Jestar342 in "SVG: The Good, the Bad and the Ugly"

Jestar342 — Sun, 14 Feb 2021 18:12:36 +0000

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.

New comment by Jestar342 in "SVG: The Good, the Bad and the Ugly"

Jestar342 — Fri, 12 Feb 2021 17:02:02 +0000

Noted, thanks.

New comment by Jestar342 in "SVG: The Good, the Bad and the Ugly"

Jestar342 — Fri, 12 Feb 2021 16:49:40 +0000

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.

New comment by Jestar342 in "EU privacy agency urges more safeguards to curb U.S. tech giants"

Jestar342 — Fri, 12 Feb 2021 15:21:54 +0000

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

New comment by Jestar342 in "Homebrew 3.0"

Jestar342 — Fri, 05 Feb 2021 13:40:29 +0000

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...

New comment by Jestar342 in "Homebrew 3.0"

Jestar342 — Fri, 05 Feb 2021 13:36:49 +0000

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

New comment by Jestar342 in "The Virus Changed. Now We Must ‘Get to Zero’ or Face Catastrophe"

Jestar342 — Sun, 31 Jan 2021 23:50:34 +0000

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.

New comment by Jestar342 in "Why Google needs to build an open chat client like Elemen"

Jestar342 — Sun, 31 Jan 2021 11:55:08 +0000

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

New comment by Jestar342 in "The Virus Changed. Now We Must ‘Get to Zero’ or Face Catastrophe"

Jestar342 — Sun, 31 Jan 2021 09:24:57 +0000

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.

New comment by Jestar342 in "Heavy social media use associated with lower mental health in adolescents"

Jestar342 — Wed, 27 Jan 2021 16:05:50 +0000

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.

New comment by Jestar342 in "Firefox 85 cracks down on supercookies"

Jestar342 — Wed, 27 Jan 2021 11:07:31 +0000

> 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.

New comment by Jestar342 in "Firefox 85 cracks down on supercookies"

Jestar342 — Wed, 27 Jan 2021 11:04:28 +0000

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.

New comment by Jestar342 in "Firefox 85 cracks down on supercookies"

Jestar342 — Tue, 26 Jan 2021 16:38:34 +0000

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.

New comment by Jestar342 in "Software engineering topics I changed my mind on"

Jestar342 — Sun, 24 Jan 2021 11:25:26 +0000

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.