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.
PeerDB should work or Aurora PostgreSQL. It should work for both log based (CDC) and query based replication. Log based because Aurora supports pgoutput plugin. Curious, are you leveraging CDC to move data to S3? or more query (batch) based?
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.
Gotcha, that really helps. Schema changes feature is coming soon! We are actively working on it. This thread captures our thinking around it - https://news.ycombinator.com/item?id=36895220 Also have a good holiday! :)
> 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.
Fair enough. I'm not supportive of letting kids cry for 2-3 hours even to the point of vomiting. But even then, I'm sympathetic to it if the parents have tried everything else and they have a kid that just won't sleep. I'm not like an absolutist or anything, I just think parents should have space to try to figure out what works for their own families without random strangers calling them abusive.
"Research shows us that an infant is not neurologically or developmentally capable of calming or soothing himself to sleep in a way that is healthy. The part of the brain that helps with self-soothing isn't well developed until the child is two and a half to three years of age. Until that time, a child depends on his parents to help him calm down and learn to regulate his intense feelings."
And yet, sleep training is not abandoning an infant. Mind your own business and stop accusing strangers who you know nothing about of abuse. You're being an a-hole.
Edit to add: attachmentparenting.org is not an objective arbiter of the research on whether or not the dogmas of attachment parenting are correct! They have a dog in this fight...
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.
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.
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.
That’s really not true. Maintained gas engines average around 200k miles without overhaul, diesel 1.5M. The typical car’s life is governed by failure of suspension, braking and other components.
Tesla tends to dominate the electric conversation. Their quality is inconsistent and minor problems are major because they really suck when it comes to parts and controlling who can repair. (Ie a 48 hour repair in a Honda may be 48 days on a Tesla)
My former employer operated a fleet of Toyota Prius, which are more complex and had an expected service life of 190,000 miles.
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.
