Readit News logoReadit News
riverdroid commented on Show HN: PGlite – in-browser WASM Postgres with pgvector and live sync   pglite.dev/... · Posted by u/samwillis
bezbac · a year ago
I recently experimented with using pglite for API integration tests in one of my side projects. It worked pretty well and has much better DX than using something like testcontainers[0] to spin up postgres running in docker.

[0]: https://testcontainers.com

riverdroid · a year ago
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 commented on EPA bans asbestos, a deadly carcinogen still in use decades after partial ban   apnews.com/article/epa-as... · Posted by u/anigbrowl
zachmu · 2 years ago
Mesothelioma from household exposure is very rare, nearly all cases come from industrial exposure, involving chronic exposure to concentrations of airborne particles millions of times higher than you would ever find in a residential setting, even during a renovation that disturbs asbestos.

I looked into this when I discovered some old asbestos paper in my basement that I had abated by professionals (which I always recommend). I was freaking out about my family being exposed to the fibers for years before that, so I went digging for hard numbers. To my surprise, there is almost zero good quantitative data on the risk of mesothelioma from residential asbestos exposure. The best info we have suggests about a doubling of the risk of MM from residential exposure, from about 1 per million person-years to 2.5 per million person years:

https://www.thelancet.com/journals/lanpub/article/PIIS2468-2...

> However, the chief interest from this study will be in the more than doubling of risk of mesothelioma in men who had lived in an affected house, compared with unexposed males (SIR 2·54, 95% CI 1·02–5·24). ... The background incidence of mesothelioma without exposure to asbestos is very low (highly age-dependent and roughly one case per million person-years), so any rise would be indicative of previous asbestos exposure

Other studies indicate that home renovations that disturb asbestos could increase the risk by about a factor of 5 from baseline, which sounds high until you realize that it means about 5 per million person-years. The base rate is very low! And there is no such thing as zero exposure to asbestos: there are a couple fibers, on average, in every liter of air you breathe. Everybody is constantly exposed to a very small amount of these fibers, and it's not the case that it gives everybody MM:

https://www.ncbi.nlm.nih.gov/pmc/articles/PMC7721955/#:~:tex....

So the bottom line is: get your asbestos abated by professionals, but don't freak out if you have been living with the stuff. It's not the same as being an asbestos miner, your risk is higher but still very low.

riverdroid · 2 years ago
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 commented on Creating a search engine with PostgreSQL   xata.io/blog/postgres-ful... · Posted by u/todsacerdoti
jsdwarf · 2 years ago
Looking forward for part 2 / postgres vs elasticsearch. One application at my company uses PG for CRUD on objects and elastic for searching them. We completely underestimated the effort of keeping the two datastores in sync and are actually contemplating to get rid of elasticsearch.
riverdroid · 2 years ago
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 commented on What California’s deadly storms reveal about the state’s climate future   economist.com/united-stat... · Posted by u/mfiguiere
riverdroid · 3 years ago
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.

u/riverdroid

KarmaCake day452August 3, 2020View Original