HNHacker News
TopNewBestAskShowJobs

oskarpearson

255 karma · joined May 26, 2009

submissionscomments
oskarpearson··on Satellite reveals immense scale of GPS signal tampering
Is there any other more useful url? Even with ad blocking enabled this site is a mess of auto playing adverts. It makes the actual content difficult to find.
oskarpearson··on Conventional Commits encourages focus on the wrong things
Like many tools defending their moats, tools like Jira don’t make it easy to get one’s data out.
oskarpearson··on Conventional Commits encourages focus on the wrong things
The handling of ticket numbers is covered in the FAQ (scroll to the bottom)

[edit] At the bottom of https://scopedcommits.com/ I mean

oskarpearson··on Ellison's EIT buys Eagle and Child pub
The Eagle & Child pub in Oxford was frequented by CS Lewis and Tolkien. It’s now going to be refurbished by Foster and Partners architects
oskarpearson··on Tiger bread – rice flour paste
I was interested in how they make Tiger bread.

Turns it it’s rice-flour paste and yeast painted on prior to baking. The rice flour doesn’t stretch, so flakes when the bread expands

oskarpearson··on Launch HN: PeerDB (YC S23) – Fast, Native ETL/ELT for Postgres
We use DMS in continuous replication mode, which appears to use CDC under the hood according to https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Task.C...

In our setup DMS pushes Parquet files on s3. Snowflake then loads data from there.

We’ve occasionally had to do a full table sync from scratch, which is painfully slow. We are going to have to do that in the very near future - when we are upgrading from Postgres 11 to Postgres 15.

The S3 step also seems unnecessarily complicated, since we have to expire data from the bucket.

How does PeerDB handle things like schema changes? Would the change replicate to Snowflake? (I’m sure this is in the docs, but I’m supposed to be on holiday this week ) Thanks for the quick reply.

oskarpearson··on Launch HN: PeerDB (YC S23) – Fast, Native ETL/ELT for Postgres
Seems like a really useful tool. Would your system support Postgres Aurora on AWS as a source database? Or does it require some lower-level access to Postgres server?

We are currently using DMS to send data to S3 and from there to Snowflake.

oskarpearson··on What happens when babies are left to cry it out?
From the article:

> For others, it can be hours of crying, even to the point of vomiting (common enough to be a frequent topic of conversation on sleep-training forums and addressed by baby sleep books including Ferber's

The article also includes a reference to 2-3 hours.

oskarpearson··on Improving Postgres text search speed
AWS’s DMS has a dynamodb target.

https://docs.aws.amazon.com/dms/latest/userguide/Welcome.htm...

oskarpearson··on The Reliability of Optical Disks
The article covers m-disc extensively, not sure why you’re linking Wikipedia here?
oskarpearson··on High genetic barrier to SARS-CoV-2 polyclonal neutralizing antibody escape
https://en.m.wikipedia.org/wiki/Human_challenge_study
oskarpearson··on High genetic barrier to SARS-CoV-2 polyclonal neutralizing antibody escape
For the same reason most vaccines require two doses. And for the same reason some countries are planning or doing booster shots.

Antibody levels drop rapidly after an infection, if they persist at all.

Getting a vaccination after infection re-triggers the immune system and makes antibodies more likely to persist for longer.

Reading up on this many months ago it seemed likely that natural infection plus a single vaccination would be equivalent to two vaccine shots.

There was research about only needing to give one shot of vaccines like AstraZeneca to people with previous infection. It was considered too complex to manage, and the research as to efficacy wasn’t finalised, so they stuck with two.

Having had Covid, plus two shots of something like AstraZeneca is presumably somewhere in the region of a standard two-shot-plus-booster campaign.

I don’t really understand much of this paper, but given other comments it seems to be a reasonable idea.

oskarpearson··on Ask HN: What would a car engine look like that was robot serviceable?
Having read that EVs are more reliable in the past, I was surprised at your response.

https://www.quora.com/Are-electric-cars-more-reliable/answer... seems quite comprehensive.

Overall, they should be more reliable, though it’s early days and there are teething problems. At the moment they are at least at a similar level to Petrol engines.

https://www.fleetnews.co.uk/news/latest-fleet-news/2019/09/0... supports this.

ICE cars contain a chunk of metal that is guaranteed to wear out from day 1 of the purchase due to friction and combustion effects. So overall not that different.

oskarpearson··on Cocktail of flu, HIV drugs appears to help fight coronavirus: Thai doctors
In the article they explain that the doctor increased only the dosage of one drug - Oseltamivir. That drug is better known as Tamiflu, which doesn’t relate to your conjecture about the Thai doctor’s state of mind.

I’m strongly inclined to believe the other commenters in this thread.

> “We have been following international practices, but the doctor increased the dosage of one of the drugs,” said Somsak Akkslim, director-general of the Medical Services Department, referring to the flu medicine Oseltamivir.

oskarpearson··on Magic Roundabout (Swindon)
https://en.m.wikipedia.org/wiki/Roundabout#Turbo_roundabouts English link
oskarpearson··on Magic Roundabout (Swindon)
From tfa:

> In 2010, the National Cooperative Highway Research Program concluded that the roundabout reduces injurious crashes by three quarters

oskarpearson··on Tesla Cybertruck
I really like the design. It seems like the sci-fi car designs from my childhood are finally here.

I just found this! https://www.motor1.com/photo/486061/1980-citroen-karin-48606...

oskarpearson··on Single-dose propranolol tied to ‘selective erasure’ of anxiety disorders
Hi Miguel. It wasn’t behind a paywall for me. Thanks for clarifying - and I apologise for being snarky.
oskarpearson··on Single-dose propranolol tied to ‘selective erasure’ of anxiety disorders
Please refrain from simply quoting the article, adding nothing to the conversation. It’s a blatant attempt at upvote harvesting from the TLDR crowd, and doesn’t belong on HN
oskarpearson··on Single-dose propranolol tied to ‘selective erasure’ of anxiety disorders
I really wish people would RTFA before commenting.
oskarpearson··on Melatonin's Effect on Skin and Hair
You can easily buy it on eBay. A USA company which has local dropshipping sells it, and manages to skirt the regulations.

My understanding is that it’s not sold over the counter (otc) is because it’s a hormone. The class of drugs isn’t available otc.

Also: I think many people use it in completely the wrong quantities and in the wrong way. I’ve heard of people in countries where it’s legal giving their kids 30mg to get them to sleep.. “it’s otc so it must be safe”. I don’t blame the NHS

oskarpearson··on Terraform 0.9
This is great, and solves two ongoing problems we have with TF:

- The new 'State environment' feature should resolve the issues discussed here: https://charity.wtf/2016/03/30/terraform-vpc-and-why-you-wan...

- The new locking feature means we don't need to use https://github.com/gruntwork-io/terragrunt

oskarpearson··on Ask HN: What's your favorite way to orchestrate AWS?
Have a look at https://www.terraform.io/ It seems to match your listed requirements. I much prefer it to Cloudformation.

There are a few downsides: - It's not yet version 1.0 (but seems good enough for real world use) - There are pitfalls about state management and locking (where two people run it at the same time) https://github.com/gruntwork-io/terragrunt should solve that.

oskarpearson··on Tesco Bank halts online payments after money was taken from 20K accounts
I wrote what I-hope-is-the-most-comprehensive StackExchange answer about this, just in case anyone else is battling:

http://expatriates.stackexchange.com/questions/85/how-to-ope...

oskarpearson··on 455 Tb of live streaming were transferred during the Olympic Games Rio 2016
Note that there's a mismatch between the listed title and the content of the article. The article refers to "400Pb (400000Tb)", not "455Tb".

This may be why there's such confusion about the numbers in the comments.

oskarpearson··on AWS Application Load Balancer
AWS Support has confirmed: while ALB should be faster, it could still require pre-warming depending on the exact use case.
oskarpearson··on A DIY diabetes kit
Note that insulin is pretty temperature sensitive, and needs specialist shipping so that it doesn't end up boiling on a tarmac somewhere. That said, we found pump-compatible insulin on Phi-Phi Island in Thailand, so I expect insulin is possibly not the core issue.

The other things (like infusion sets) should be easy to ship. The UK suppliers generally won't sell them unless you have a UK pump and an account with them, though. It could probably be worked around though, using some sort of international forwarding arrangement.

oskarpearson··on A DIY diabetes kit
The biggest problem is going to be expense, followed by reliability and power when out-and-about.

I'm not sure where you are, but in the USA compatible pumps probably start at around $1,000. That doesn't include the monthly cost of the CGMS sensors, which is also significant.

If you're in a country with universal healthcare, and the healthcare provider is willing to cover the CGMS sensors you might have success. (Some govt healthcare services will cover CGMS sensors for people that can't tell when they are hypoglycemic.)

If the person with diabetes (PWD) is very mobile, reduced size and weight will have to be at the forefront of your thinking. However, that requires the most expensive OpenAPS hardware (the Intel Edison - see the mmeowlink wiki).

If the PWD is ok with a larger device due to a bigger battery, you could use cheaper hardware (Pi zero and a 20,000mah battery). It'll still need daily charging, though.

One idea: you might find running things overnight only might have an advantage, depending on whether they have a stable relationship with a shelter. The system would then cover them for a reasonable amount of time every day without the challenge of waterproofing, batteries, etc.

If this is feasible, the best place to start is with the simplest config, as documented at https://github.com/openaps/docs/blob/master/docs/docs/walkth...

Let me know if I can be of any support. My details are in my profile. Alternatively, you can find us on the intend-to-bolus channel on gitter.

oskarpearson··on A DIY diabetes kit
Good to see this here. I'm one of the developers (though more on the radio comms side, rather than on the glucose control side. See http://github.com/oskarpearson/mmeowlink/wiki for info).

My wife's been on the software since last September, and it's made a huge difference to us.

If you've any questions, ask here or grab me on twitter at @oskarpearson

oskarpearson··on Banks begin moving some operations out of Britain
Click the "web" link above, then click the first google result
Page 1 of 2Next →