HNHacker News
TopNewBestAskShowJobs

parshimers

331 karma · joined June 5, 2015

https://tujun.ga
submissionscomments
parshimers··on A SQL Heuristic: ORs Are Expensive
https://pages.cs.wisc.edu/~dbbook/ is a great overview, specifically chapters 13 and 14 on query optimization. it is difficult to reason about though, and every compiler is different. it takes time and enough examples to look at a query and have an intuition for what the plan should look like, and if there's something the compiler is not handling well.
parshimers··on ICE Revoking Students' Immigration Statuses Without Their or the Uni's Knowledge
anyone cheering this on really has no idea how bad this is. higher education is an area in which the US has had a completely dominant position. the smartest and most driven people from all over the world come here to learn, and start businesses here afterwards. it's a tide that raises all ships. it's not at all a mixed bag like outsourcing or the loss of domestic manufacturing.

that dominance is ending now, because of the cruel whims of one man. none of this is based on rules or process. it's the exact kind of fickle brutality people come to this country to escape. the entire thing is like cutting your nose off to spite your face.

parshimers··on DOGE employees don't understand the basics of SQL
i think this already happened to some extent, with the Social Security Administration. unless something's changed it's all stored in IMS, i.e. pre-relational. perhaps there's some relational view on top of it but to my knowledge it hasn't been overhauled to anything more modern.
parshimers··on ZFS 2.3 released with ZFS raidz expansion
btrfs has similar aims to ZFS, but is far less mature. i used it for my root partitions due to it not needing DKMS, but had many troubles. i used it in a fairly simple way, just a mirror. one day, of the drives in the array started to have issues- and btrfs fell on it's face. it remounted everything read-only if i remember correctly, and would not run in degraded mode by default. even mdraid would do better than this without checksumming and so forth. ZFS also likewise, says that the array is faulted, but of course allows it to be used. the fact the default behavior was not RAID, because it's literally missing the R part for reading the data back, made me lose any faith in it. i moved to ZFS and haven't had issues since. there is much more of a community and lots of good tooling around it.
parshimers··on Making an intersection unsafe for pedestrians to save seconds for drivers
It's too bad they didn't put a roundabout here, there's one in the middle of old town Orange and it works pretty well. Terrible waste of money to make the intersection worse like they did.

It also says something that the behavior of the cars here isn't even illegal in California. Entering an intersection on yellow and exiting on red is fine. Right turn on red is also allowed, and many people combine that with a California stop (though that last part isn't legal). All of the above are extremely hazardous for pedestrians and encourage speeding.

parshimers··on A stubborn computer scientist accidentally launched the deep learning boom
yeah, you could argue that the RIVA128 was the first successful PC GPU that didn't require a separate video card, but that's not the same thing.
parshimers··on Autonomous trucking is harder than autonomous rideshare
we do have semi-autonomous trains, in the US at least. i'm not sure about elsewhere. PTC stops a large class of disastrous operator errors (overspeed, missed/ignored signal, etc.). it is almost entirely complete on all of the class 1 railroads in the US by now.
parshimers··on Safety benefits of roundabouts
the resistance is a problem. there are a few in Pasadena, CA on Los Robles between California and Raymond where it's a roundabout, with stop signs on each entrance. the worst of both worlds.
parshimers··on California suspends Cruise's autonomous vehicle deployment
stop and get out of the car because someone just got flung onto/underneath your car? or perhaps have enough situational awareness to see that someone is about to walk into oncoming traffic?
parshimers··on Electric bike, stupid love of my life
A Brompton is really small when folded. Smaller than a carry-on suitcase by volume. It rolls on little scooter wheels on the rear rack when folded. I bring mine into all the places you just listed on a regular basis, except for a gym. For a restaurant, it typically will fit under a table. At a bar, if you are at a table the previous thing works. I've also had the bar staff offer to stash it inside the store room. If someone you are meeting up with is DD'ing a trunk works as well. I've never been in a store so small I couldn't roll it in, you can just pull the seat up a bit and roll it in front of you.
parshimers··on S.F. says incidents by Cruise, Waymo driverless taxis are ‘skyrocketing.’
That’s really awful. These kind of incidents need to be investigated. Whatever situation caused the car to just run into the path of a pedestrian in a crosswalk can’t be allowed.
parshimers··on Submarine missing near Titanic used a $30 Logitech gamepad for steering
don't they do this with crab pots? i'm not sure how far those go down though.
parshimers··on ASRock Brings 56-Core Xeon W3400 to Deep MicroATX
At least on the crash carts I've used, the displays were always VGA. Not sure if that's still the case. I'm not sure why.
parshimers··on It will take years to get Deutsche Bahn back on track
I always hear a lot of grousing about DB, but I took it a lot the two times I visited, and I liked it. Even when there was a horrible windstorm that blew trees all over the tracks and stopped the ICE from coming down to Ingolstadt, I was able to hop onto regional alternates to where the ICE was, and get back to Berlin without too much insanity. The trains are pleasant and clean, and the stations are massive and have lots of nice convenience stores.

Contrast this with Metrolink or Amtrak, and it's night and day. If your train gets cancelled, at least in SoCal, you're likely hosed. You will wait hours upon hours, and some stations that are in the middle of the biggest metro area in the US get 2 trains a day. You can't just hop on something going the right way. Furthermore they are often isolated and have no stores near them.

I also really disagree with the article's implicit assumption that passenger railways somehow, have to make a profit. At least here in the US, that's often implied too, yet the interstates are completely free and funded by the state and no one bats an eye. Why?

parshimers··on Waymo One doubles service area in Phoenix, continues growing in SF
I know they started testing a while back in LA, has anyone been in one there? I haven’t seen them around town like I have in SF.
parshimers··on Ask HN: What is your opinion of “unlimited” PTO?
It's fine if you, your coworkers, and your manager have the discretion to understand vacation is not optional. I've never seen this. It usually ends up being a race to the bottom, driven by people who think working at (or coercing, in the case of managers) a burnout pace is inherently virtuous somehow.
parshimers··on A US federal agency is considering a ban on gas stoves
An induction range draws a great deal of current, so it might entail a lot of very expensive electrical work. Many places that have gas appliances weren't designed with the idea of an appliance that can draw 40 amps.
parshimers··on A US federal agency is considering a ban on gas stoves
It seems very much like throwing the baby out with the bathwater to ban them outright. Require a fume hood, and if that is not enough then at least just ban it for new constructions or remodels. Induction is nice but I don't think it covers every niche just yet, and gas stoves are very desirable in places where electricity tends to go out due to weather.
parshimers··on iPhone 14 Pro comes with dual-frequency GPS
Most headunits with Carplay require you to have the vehicle speed sensor connected to them. They also have a compass. So, if you lose GPS, you have the 3 components you need for dead reckoning: A starting location, a heading, and a speed. It works pretty good even in complex areas like parking garages.
parshimers··on You can’t copyright a cocktail, so what’s a creative bartender to do? (2019)
This is the exact method by which many classic Tiki cocktails were kept secret and therefore nearly lost to time. For example the original recipe for the Zombie is disguised twice. It uses “Don’s Mix”, which is made with grapefruit juice and “Spices #4”. It took a very dedicated historian, Beachbum Berry, to track down the real recipe: https://beachbumberry.com/recipe-zombie.html
parshimers··on You can’t copyright a cocktail, so what’s a creative bartender to do? (2019)
It can get kind of confusing though. Consider the Navy Grog, a classic Tiki cocktail. The Trader Vic’s recipe is very different than the original Donn the Beachcomber version. This is because the recipe was secret and so all other attempts at it were basically guesses.
parshimers··on Airbnb will up its penalty for hosts who cancel last-minute from $100 to $1k
Airbnb is such a joke now. I had a host steal from me with no repercussions in November. The host said the room wasn't ready through text, and then, when they said it was ready, someone (not the host) walked up to us on the street outside the building the room was supposedly in and said it still wasn't ready- there were men working inside it.

He would take our bags up but under no circumstances would he let us actually see the room or have the keys until it was "ready". Obviously it was either a scam, or an illegal sublet that he didn't want to level with us about.

Airbnb refused to refund a room that for all intents and purposes, didn't exist. Their rationale was that they hadn't been informed the same day, which is ridiculous considering how much of a timesink finding a last-minute hotel is. It should be open and shut, but they simply bought the lies the host told them, despite the fact they were never even there.

parshimers··on Major Linux Problems on the Desktop, 2021 edition
This reads like a less amusing version of the UNIX-HATERS handbook. The citation on the Linux kernel containing "a whole lot of very low quality code" is a Slashdot post. The author claims that there is "No high level, stable, sane (truly forward and backward compatible) and standardized API for developing GUI applications" like it's something that exists anywhere, and cites Win32 as an example to be followed instead of a painful business decision by one company.
parshimers··on The latest DSM update makes btrfs drives unavailable on budget Synology models
I built a custom home server using Mini-ITX form factor parts and I would have to agree with this conclusion. ECC ram in that form factor is very expensive. The biggest issue I had was that fanless ATX power supplies are not reliable. There was also a hardware bug that was bricking Atom C2xxx processors.

I think that if form factor is not an issue, one of the i3's that support ECC ram are low enough TDP to be cooled passively. Especially if it is not expected to run at full load for long periods. However I simply switched to using a big case with low RPM, good quality FDB fans. It hasn't been a problem since, and is much less cramped when I do want to tinker with it.

parshimers··on Google plans to shut down Google Voice integration with classic Hangouts
The Google Voice dialer sucks. If you're not on Wi-Fi it won't call over data. Maybe this would have been a sensible restriction 10 years ago but now it's totally silly. I used the Hangouts dialer all the time when travelling internationally to avoid ludicrous international call fees.
parshimers··on Caffenol: Developing Photos with Coffee and Vitamin C [video]
Yes, but once it becomes laden with powdered, precipitated silver it is far less benign. Silver is still a heavy metal after all, even if it is not the most acutely dangerous one.
parshimers··on Ad blocking with Raspberry Pi and Pi-hole
pfsense can do this pretty easily, i wouldn't call it out of the box though. the adblocking can be done via pfblocker-ng, and it has an openvpn client of course.
parshimers··on Getting Started with WireGuard
Interesting. I haven't had that happen because I do split-tunnel, but I will have to keep that in mind in scenarios when I try to forward everything thru the tunnel. All I needed to do for split tunnel was just adjust the route metric. (https://tujun.ga/2020/02/18/wireguard/) Agreed about the lack of GUI though, I do wish there was a GTK applet for it.
parshimers··on Getting Started with WireGuard
If you're using NetworkManager and wireguard, try out the integration between the two as well. It lets you treat the tunnel as any other VPN in nm, and also easily avoids some issues with routing loops if you roam back on to your home network. Before, I always had to manually use wg-quick when I came back home or left.

http://blogs.gnome.org/thaller/2019/03/15/wireguard-in-netwo...

parshimers··on Amazon Isn’t the Only Shop Online
Their return policies are not good. Amazon will take things back, without fuss. Newegg will charge a very hefty restocking fee, or might not even take it back at all. It is very unfortunate to see this have happen, because I remember in the early 00's they built their business on providing the exact opposite kind of experience to that kind of nickle-and-dime technique that was commonplace at the time.
Page 1 of 3Next →