HNHacker News
TopNewBestAskShowJobs

riverdroid

452 karma · joined August 3, 2020

submissionscomments
riverdroid··on Show HN: PGlite – in-browser WASM Postgres with pgvector and live sync
I would also love to use it this way in Go. Currently we dump SQLite compatible schema to use for SQLite powered integration tests even though we use postgres when live. It allows us to have zero dependency sub-second integration tests using a real database. Being able to use postgres would be even better, allowing us to test functionality requiring PG specific functionality like full text search.
riverdroid··on EPA bans asbestos, a deadly carcinogen still in use decades after partial ban
While most mesothelioma (a rare cancer) is known to be caused by asbestos and not other agents, asbestos is known to cause other cancers of the lung, larynx, and ovary, with limited evidence of some other cancers as well.

https://www.cancer.gov/about-cancer/causes-prevention/risk/s...

These are more common cancers, and not usually possible to map to a precise cause when they occur.

riverdroid··on Creating a search engine with PostgreSQL
I was researching this recently and came across this article: https://pganalyze.com/blog/gin-index

The GIN index has some similarities to Elasticsearch's inverted indices (last I knew anyway), which also can be quite expensive to write to. If you're doing heavy writes, something to test and consider carefully.

TLDR; writes get a lot more expensive with GIN indices.

riverdroid··on What California’s deadly storms reveal about the state’s climate future
One important factor to consider about these 'whiplash' events is that they also deplete the immediate water carrying capacity as the top soil washes away. The top soil normally serves as a 'water battery', and allows the water to absorb quickly with less run off as it slowly absorbs into plants and deeper parts of the ground. As more washes away we can expect more flash floods, more severe drought cycles, and desertification over time.
riverdroid··on What California’s deadly storms reveal about the state’s climate future
https://web.archive.org/web/20230113192401/https://www.econo...
riverdroid··on Thunderbird 102
The easiest and best way for you (you'll get updates through signed packages, etc) is probably to install via the Ubuntu Software Center.

Though it can be difficult to download and run random software from the internet, I have to say, most Linux distributions have got the software distribution challenge through their package managers right compared to OSX and Windows. First thing I do on an OSX machine is install homebrew which helps a little.

riverdroid··on Ford surprises F-150 Lightning owners with adapter for charging stranded Teslas
Current Ford F-150 towing capacity is 5,000 to 11,300 lbs depending on the package.

Most people probably don't need long range peak towing capacity.

Seems like the feature set could be useful to a lot of people, probably most, maybe not for you though.

riverdroid··on Heroku: We’ve Heard Your Feedback
Besides that, lots of incident response work to figure out the scope and impact of the breach, I'd imagine.
riverdroid··on Google “hijacked millions of customers and orders” from restaurants – lawsuit
Be aware of platforms publishing a 'proxy' phone number so they can still collect their fees: https://www.theverge.com/2019/8/6/20756878/yelp-grubhub-comm...
riverdroid··on Launch HN: Hydra (YC W22) – Query any database via Postgres
What do you use to produce this analysis?
riverdroid··on 1Password for SSH and Git (Beta)
SMS is not strong enough, especially for protecting ALL of your 2FA codes + passwords. SIM swapping attacks frequently occur, and it doesn't even have to be with your carrier.
riverdroid··on Dango Views Cheatsheets
This is a big improvement to supplement the existing docs, but how does one know what the parameter types are without wading deep into the implementation or trial and error? This has been a major point of frustration for me when interacting with python code (especially someone else's) beyond simple scripts.
riverdroid··on Driftwood: Know if private keys are sensitive
Thanks for the revocation resources! I was not aware of LE's revocation API. Seems like maybe reporting should get built in as an option.
riverdroid··on Driftwood: Know if private keys are sensitive
If you search GitHub, you can find ~4M results for PEM private keys: https://github.com/search?q=PRIVATE+KEY-----&type=Code

Many are for tests and don't go to anything. Some go to really important things though, even among the test keys, and this tool tells you that instantly for billions of keys.

riverdroid··on Driftwood: Know if private keys are sensitive
Most private keys in Git repositories seem to be test data. But why are those test private keys sometimes used for other things? Probably just people lazily copying from ~/.ssh/idrsa or copying to ~/.ssh/idrsa.
riverdroid··on [dead]
Many of these committed keys are test fixtures in repositories. As for how that happened, not entirely sure, but I am guessing that people just grabbed a key lying around like ~/.ssh/idrsa
riverdroid··on Docker, Django, Traefik, and IntercoolerJS: My go-to stack for building a SaaS
I'd say typing is even more important when you are using other people's code with your code. It's also a huge productivity boost too when the relevant methods and types are available to you, the editor almost writes the code itself!
riverdroid··on Uber discovered they’d been defrauded out of 2/3 of their ad spend
From my limited experience, resources are better spent to SEO to boost ranking. Also, you can request review on google ads keywords to prevent competitors from using your name, especially if you have a trademark.
riverdroid··on Print this file, your printer will jam (2008)
There might be some software issues at play with some modern AWD systems that I am not aware of, but it's traditionally a mechanical issue with 4WD and AWD. 4WD has a physical link, so having two different diameters linked stresses the links and tears the rubber. With AWD there is a differential, and different diameters cause mechanical stress and wear in a mechanical diff.
riverdroid··on Experiments on a $50 DIY air purifier that takes 30s to assemble
Be aware that the air quality sensor on most units is a cheap VOC sensor. It detects gasses, not particles. It'll trigger if you fart near it or cook something odorous, but not for dust or smoke.

I have the Winix 5300 and 5500 purifiers (which I highly recommend), and typically run on mode 3 out of 4 because it pulls about 12 watts (and is quiet) but is not massively different airflow than mode 4 which draws about 70 watts (and is noisy).

riverdroid··on What is a resilient chicken?
Seems like it could go both ways, couldn't it?

Free ranging birds are in less proximity and healthier conditions. There is less contact between them, more sanitary conditions, and healthier birds. But yes, they could have more contact with outside pathogens.

Whereas many poultry barns have thousands of chickens standing in their own excrement, shoulder to shoulder. There are even decaying corpses strewn about and being pecked. Whatever pathogens in there with them could spread and mutate readily, and the birds are likely less healthy and more vulnerable to it.

I'm not sure if there is solid evidence to claim one is more risky than the other, but I think it would be the former.

riverdroid··on Over 80% of Covid-19 patients in a hospital study have Vitamin D deficiency
I know vitamin D is inexpensive to manufacture, but with all of this new demand, I really hope that there is testing going on. I would not be surprised if Amazon has a bunch of fake supplements mixed into their supply chain for example. The vitamin supplement industry is notoriously under-regulated.
riverdroid··on OpenSCAD - The Programmers Solid 3D CAD Modeller
Years ago, I worked at a factory that had thousands of variations of a large, heavy product, some dating back to the 60s. This product has multiple units packed for shipping on pallets and random scrap pieces of wood and then strapped down like some sort of Jenga puzzle.

I created a generic OpenSCAD model for the product, and fed in parameters derrived from more than a dozen data sources to generate a model for every variation. Then, took the 90th percentile by production numbers, and overlaid the models to show the boundaries of the variations as one model. That shape was then used to generate stack-able, vacuum-formed trays to hold the product.

I had a couple of expensive 3D CAD products at my disposal there, but OpenSCAD was the solution I needed to programatically crank out models. That's how my foray into programming started and my career shifted from Manufacturing Engineering to Software. Thanks OpenSCAD team!

riverdroid··on Validating Kubernetes YAML for best practice and policies
k-rail does realtime validation and enforcement with policies written in Go: https://github.com/cruise-automation/k-rail