HNHacker News
TopNewBestAskShowJobs

arrowleaf

392 karma · joined August 16, 2023

submissionscomments
arrowleaf··on High myopia is now the leading cause of blindness in Japan, China, and Taiwan
Close-up work (crafts, reading, computers) causing myopia 'makes sense', I heard the same thing as a kid in the States.

It makes me wish we would have had more P.E. classes outside, rather than 'giving our eyes a break' by playing kickball indoors under fluorescence.

arrowleaf··on High myopia is now the leading cause of blindness in Japan, China, and Taiwan
Floaters have many causes. An early sign of retinal detachment will be floaters until it progresses closer to the macular hole, at which point the symptoms will be more of a curtain being drawn across your vision.

I was able to catch a retinal tear that had a very high chance of proceeding to a retinal detachment (horsehoe tear with sub-retinal fluid) by getting some new floaters checked out.

Floaters are commonly caused by a (mostly) benign aging phenomenon called posterior vitreous detachment, where the vitriol gel liquefies as a person ages.

arrowleaf··on High myopia is now the leading cause of blindness in Japan, China, and Taiwan
Three years ago at age 25 I booked an eye exam due after getting some new floaters. After imaging my eye doc came in and asked if I was comfortable driving while dilated, because he would be dilating and numbing my eyes before sending me off to the retina specialist for an urgent exam. The ophthalmologist immediately diagnosed me with lattice degeneration and saw a horseshoe tear. That same afternoon he sat me in a chair and used a laser to create a barrier of scar tissue around the tear to prevent it from progressing. Three years later I have had two rounds of prophylactic treatment of those weak spots in each eye. I most likely will never experience a retinal detachment, but annual dilated eye exams are in my future.

I don't even have very bad myopia (-2.75/-3.25), but I kick myself for not spending as much time outside during my childhood as some of my friends did.

arrowleaf··on Granting pardon for the offense of simple possession of or use of marijuana
I've always taken it for granted that stuff like MIPs on your record get sealed or expunged once you hit 21. IMO it's silly to have it be a mark on your record even temporarily, but insane to me that some states don't automatically expunge misdemeanors for kids.
arrowleaf··on Polymers capable of killing bacteria without inducing antibiotic resistance
I'm assuming the intended application of this is to kill bacteria colonizing a biological host. In order for that to work, the treatment needs to be selective in what it kills. If human/animal/plant cells have any mechanism to avoid being killed by the antibiotic, eventually the bacteria will adapt them.
arrowleaf··on Chevrolet Blazer first drive: GM's EV platform goes mainstream
It's a real concern for fire departments that don't have readily available equipment to deal with massive battery fires. Even though it's rare it's still worthy of criticism.

EVs are way heavier than ICE vehicles with a similar form factor, more energy involved in collisions. They also go through tires and wear down the road surface faster.

arrowleaf··on Chevrolet Blazer first drive: GM's EV platform goes mainstream
On my 2023 Subaru the infotainment system routinely crashes on startup, I think if I plug my phone in too soon after turning it on. I'm sure the engineers at GM (and those at Apple working on Car Play gen 2) have worked through all of these issues that have been plaguing infotainment systems since they were introduced. /s
arrowleaf··on Chevrolet Blazer first drive: GM's EV platform goes mainstream
With most vehicles being 'fly by wire' nowadays, do regulators like the NHTSA and FMCSA have their own software engineers / technology experts reviewing what's going into these vehicles?

When 346 people died on the 737 Max 8s there was headline news speculating on the role of new software. The FAA had a lengthy investigation of Boeing and we saw pieces put out by experts like IEEE opining about what went wrong and how software played a role. Boeing paid $2.5bn to avoid being put on trial.

45,000 people in the USA die in motor vehicle incidents every year. How many hundreds if not thousands of those were caused by software faults? Is the software in sensor-based safety packages working as flawlessly as flight control systems?

I bet more than 346 pedestrians have been killed by drivers of Subarus that have EyeSight packages, drivers who think EyeSight might make a difference in them not hitting someone if they aren't paying full attention to the road.

arrowleaf··on Chevrolet Blazer first drive: GM's EV platform goes mainstream
Seriously. I can't believe that all of these auto makers got bailed out just so that they can screw around with stuff that will never be their area of expertise. Where is the innovation on gas mileage, impact safety beyond making the vehicles larger, getting decent diesels that can meet EPA regulations for passenger vehicles, etc?

Instead automakers keep on reusing platforms that are hardly different from their previous generation and tack on software-based 'innovations' like they're a tech company. Usually for the worse like in this instance, replacing the (hardly) tried and true interfaces of CarPlay and Android Auto with their own software. Before this it was switching out climate control knobs for on-screen which don't work with gloves, throttle profiles which will never be used, etc...

arrowleaf··on Do you really need foreign keys?
Yes, if you have downstream services that need to make use of your data, you would provide an API. That way you can manage the number of connections, how the queries are formed, any sort of encoding/decoding, authorization, caching, etc. Definitely not limited to read-only.
arrowleaf··on Do you really need foreign keys?
Have a single application clearly owning the data. All access to the data is done through that application. Why would you _want_ multiple applications deciding how to handle data in a common store? What about access authorization to sensitive data?
arrowleaf··on Do you really need foreign keys?
Implementations with skin in the game are still innovating and improving the 'tried and true' relational database model, IMO. PostgreSQL, MS SQL, MySQL, etc. consistently churn out new features that actually make sense, like FK constraint support for sharded/partitioned tables relevant to this discussion.
arrowleaf··on Do you really need foreign keys?
And then, don't just drop the constraints because you read an article about how FK constraints don't work with a distributed relational model, take a careful look at the docs of whatever DB engine you're using. PostgreSQL 12 for example supports foreign keys with either side being a partitioned table.
arrowleaf··on Do you really need foreign keys?
The only time I could see it really impacting performance is during bulk operations. But that's where making FK constraints deferred and wrapping the bulk actions in a transaction makes more sense.
arrowleaf··on Do you really need foreign keys?
My assumption (with modern applications!) is that nothing but the role directly owning the data will access the data. The development and DBA teams will likely have a role they can assume after performing a carefully-audited breakglass procedure to use in an emergency (rare) or to fulfill audit tasks. At least in my org this is a well-known problem with legacy applications sharing databases. Limit access to the database to a single role, used by a single application, and you absolve so many issues.
arrowleaf··on Do you really need foreign keys?
By soft deletion, do you mean you would want to ever re-instate the record and make it valid again, PK/FK constraints and all? Or tracking deleted records? For the latter I use audit tables + triggers to track the changing values.

At a basic level you could duplicate the entire record into the audit table on every action, e.g. the audit table would look like `audit_id | record_id | user/process_id | action (insert, update, delete) | timestamp | ...<record rows>`.

You can optimize it to not duplicating column values unless necessary. On inserts you only need the metadata of the action. On updates, the old value of columns with changes goes into the audit table. On deletes the whole record goes into the audit table.

arrowleaf··on Show HN: Trains.fyi – a live map of passenger trains in the US and Canada
There's also lots of track included that hasn't seen passenger trains in 30-50 years. The only passenger rail in Idaho is in the panhandle. I'm not sure if Helena has any passenger traffic either.
arrowleaf··on OpenAI staff threaten to quit unless board resigns
All of their messaging, Ilya's especially, has always been that the forefront of AI development needs to be done by a company in order to benefit humanity. He's been very vocal about how important the gap between open source and OpenAI's abilities is, so that OpenAI can continue to align the AI with 'love for humanity'.
arrowleaf··on OpenRefine
I need to take another look at this. I've recently started working with RDF data on a scale of ~50 million URIs not including properties and statements, there's a ton of suplicates in there. I loaded a 10k entity subset of this and OpenRefine found all of the duplicates I had manually found plus others that I guess were 'similar'. Really cool, but it crashed when attempting to merge entities together. I've got a pipeline transforming the original JSON dataset to RDF, maybe it would work better working with the looser structure. What scale of CSV data did you have?
arrowleaf··on The Oracle Java Platform Extension for Visual Studio Code
Serious question, is Red Hat a risk to the Quarkus project? I haven't started any new applications on anything but Quarkus for a couple of years. I would love to use Helidon, but the features and production stability just aren't there yet.
arrowleaf··on The Oracle Java Platform Extension for Visual Studio Code
I love VS Code, but I will never be able to work with Java code outside of IntelliJ. Hopefully this extension is a bit more stable than the Red Hat one, whenever I've attempted to use VS Code for Java it's hit or miss whether plugins or the language server crash.
← PreviousPage 5 of 5