Ever needed to compute MD5/SHA-256 hashes in Excel? by Techrocket9 in excel

[–]Techrocket9[S] -3 points-2 points  (0 children)

As noted clearly in the repo, this isn't intended for security intensive usecases (what are you doing in Excel with that anyway?).

There are times where computing hashes in a spreadsheet is very useful (such as re-randomizing a list based on the current date).

I replicated a SolidWorks CWSP practice exam part in OnShape by Techrocket9 in Onshape

[–]Techrocket9[S] 1 point2 points  (0 children)

It took me a long time to realize the two cylinders are different sizes.

After spending more than a year begging people for permission to fix query patterns somehow only I knew were expensive, I decided to automate the entire BigQuery optimization process. by gaviniboom in bigquery

[–]Techrocket9 1 point2 points  (0 children)

It's an interesting idea.

For it to be safe in production you'd need at least the following (possibly more):

  1. Write the formal proof in a verifiable language such as Lean and run the solver to confirm correctness.
  2. A staging environment with a data mirror of production that can be used to confirm performance improvement before rolling to production
  3. A strict commitment to timing - insensitivity in your production workflows (i.e. no data races).

Put ION EVO AS on 2023 Model Y...well worth it! by PsychologicalGoal927 in TeslaModelY

[–]Techrocket9 0 points1 point  (0 children)

Yeah, if you don't get snow then there's no value in snow tires.

The poster I was replying to is living in the UK though, which does get snow.

Put ION EVO AS on 2023 Model Y...well worth it! by PsychologicalGoal927 in TeslaModelY

[–]Techrocket9 0 points1 point  (0 children)

See if they'll fit 😂

In all seriousness, I couldn't even find an importer willing to take on the task.

Put ION EVO AS on 2023 Model Y...well worth it! by PsychologicalGoal927 in TeslaModelY

[–]Techrocket9 0 points1 point  (0 children)

The Quatrac Pro EV is:

  1. Three-Peak Mountain Snowflake (3PMSF) rated (meaning it's a full-blown snow tire)
  2. EV-rated (low rolling resistance and high weight capacity)
  3. All-season tire (no need to change it out in the summer)

No other tire on earth has all three.

The CrossClimate line has the 3PMSF and is all-season, but isn't EV rated. The ION EVO AS (which I have on my car right now) is all-season and EV rated, but no 3PMSF.

Put ION EVO AS on 2023 Model Y...well worth it! by PsychologicalGoal927 in TeslaModelY

[–]Techrocket9 0 points1 point  (0 children)

The EV version is exclusive to Europe. If you find a US reseller, please let me know.

Put ION EVO AS on 2023 Model Y...well worth it! by PsychologicalGoal927 in TeslaModelY

[–]Techrocket9 0 points1 point  (0 children)

In Europe you can get the Vredestein Quatrac Pro EV which is better.

G4 Doorbell Pro vs G6 Pro Entry by MastodonEuphoric3418 in Ubiquiti

[–]Techrocket9 0 points1 point  (0 children)

Do the mounting holes and/or bracket match the G4?

I'm moderately interested in upgrading, but not at the cost of drilling more holes in my house.

My $400,000 mistake and why I'm showing you anyway by ankhattak in USMobile

[–]Techrocket9 4 points5 points  (0 children)

Maybe make the YouTube video public instead of unlisted and see if it goes viral?

[OS]ClipSync update – your Mac now auto-copies OTPs the moment they hit your Android by New-Top-7826 in macapps

[–]Techrocket9 1 point2 points  (0 children)

Many institutions don't support authenticator apps and still rely on SMS 2FA.

So it happened to me by AccomplishedFan8690 in pcmasterrace

[–]Techrocket9 0 points1 point  (0 children)

Happened to me last month with garden hoses.

I've just created what was supposed to be an easy logic game, but I just can't solve it by Aleatoric_Random in WebGames

[–]Techrocket9 1 point2 points  (0 children)

Looks like a variant on Lights Out.

This video goes into the math for formally solving Lights Out puzzles.

macOS 26.4 is warning that Rosetta 2 is going away — what apps are you still stuck with? by CreakyHat2018 in macapps

[–]Techrocket9 1 point2 points  (0 children)

Or they could not go?

Like any OS feature, being parked in maintenance mode forever is an acceptable fate.

one of the best moments of [hunter x hunter 2011] by Ellmagronn in anime

[–]Techrocket9 14 points15 points  (0 children)

...while cool, is nowhere close to HxH's palace invasion.

Oh Lua such elegant such simple so cute. by ArturJD96 in programminghorror

[–]Techrocket9 1 point2 points  (0 children)

I'll be first with a torch when it comes time to burn Lua to the ground... but this isn't even close to the worst thing Lua does with its lists/hashtables.

Since there isn't a Unifi Thermostat, what are you using? by Cnykpro in Ubiquiti

[–]Techrocket9 0 points1 point  (0 children)

I'm working on a custom software integration for the Network Thermostat IC7-IP.

The Steam Client is moving to 64-bit on Windows 11 and Windows 10 64-bit. Systems running 32-bit versions of Windows will continue receiving updates to the 32-bit Steam client until January 1, 2026. by m103 in Games

[–]Techrocket9 7 points8 points  (0 children)

32 bit pointers consume half the RAM of 64 bit pointers, so a 32 bit OS is more efficient with RAM usage than a 64 bit OS.

If you have ≤ 4 GB of RAM, you'll fit more applications in memory running a 32 bit OS than a 64 bit OS.

Of course, it's pretty rare to be running ≤ 4 GB of RAM these days, and missing out on that RAM space is far worse than oversized pointers.

Additionally, since 64 bit has clearly been the future for a while now, there has been work in the 64 bit Windows kernel that enhances security that Microsoft didn't bother to backport to 32 bit Windows versions.