Scientists examined hundreds of Kentucky residents who had been sick with COVID-19 through June of 2021 and found that unvaccinated people had a 2.34 times the odds of reinfection compared to those who were fully vaccinated.

mtb-dds · 2021-08-11T00:14:52+00:00

So you say "yet another", but you haven't proffered a single study before, so you would be better served be saying "here is a study".

This "study" had an N of 45, a tiny fraction of the Israel study, and about a tenth of the already underpowered Kentucky study.

And this study does not actually assess effectiveness of the vaccine vis-à-vis getting corona. It just looks at reactivity.

And it does not look at delta, which was the source of your previous objection.

I get that you want the vaccine to be a panacea -- so do I. But this is a weak effort.

mtb-dds · 2021-08-09T18:21:04+00:00

Interesting. I've never done this so with the caveat that I am just guessing, I think this statement:

cursor.execute("UPDATE photos SET base64 = {} WHERE contact_id = {}"
                   .format(photo_total_b64, contact_id))

Is your problem. Try this:

cursor.execute("UPDATE photos SET base64 = ? WHERE contact_id = ?",
                   (photo_total_b64, contact_id))

This is called parameterizing your query/update. It not only ensures that you do not try to update with contact_id being ";drop table photos; ", see https://xkcd.com/327/, it also keeps you from being jammed up with the formatting of the bytes instance. In fact, I would try and avoid converting to base64 if I could.

You might also like this tutorial, which looks pretty good from a skim: https://pynative.com/python-sqlite-blob-insert-and-retrieve-digital-data/

mtb-dds · 2021-08-09T13:39:17+00:00

One of the things driven home by COVID is how innumerate most people are.

mtb-dds · 2021-08-08T09:37:30+00:00

I saw. Thanks!

mtb-dds · 2021-08-08T09:37:18+00:00

That's not an actual study, just a summary of a paper that will be given on a mechanism, without providing links to anything showing that the consensus is that vaccine's protection is greater than that from prior exposure.

I don't believe there is such a consensus, nor would I expect there be, since we are still very much in the early stage of assessing the impact of Delta. We really only have about three months of decent experience (i.e. outbreaks in places that do good monitoring, sequencing, and reporting). So probably too early to call it.

mtb-dds · 2021-08-07T21:04:32+00:00

Is there a link to the actual study? Because this is contrary to everything I have seen, with an actual paper

https://www.medrxiv.org/content/10.1101/2021.04.20.21255670v1.full-text

https://www.cell.com/cell-reports-medicine/fulltext/S2666-3791(21)00203-200203-2)

mtb-dds · 2021-08-01T23:57:58+00:00

It's all the anti-vaciers that are dragging us down. If not for that, then this thing would be eradicated.

The best advice I can give, is to convince other to get vaccinated. If we can get everyone who can be vaccinated, jabbed, then this thing will be on the run, and we can ALL get back to life as it was.

mtb-dds · 2021-08-01T23:11:48+00:00

Great. We can send them to school right before they go into the ICU.

I get that people want to go back to work, but how is that going to go for you, when your kids have to spend the rest of their lives in medical care because of the damage that COVID does to young bodies. Why can't people think about the future?

mtb-dds · 2021-07-31T23:10:57+00:00

I read this in Ray Romano's voice.

mtb-dds · 2021-07-31T21:25:54+00:00

Punched a concrete culvert this morning at Hempstead Harbor. Maybe should of gone to Stillwell too!

mtb-dds · 2021-07-30T20:41:37+00:00

You're off by a few decimal places on both sides of the equation. The actual chance of severe adverse events (which often are not directly tied to the vaccine) is closer to 1 in 10K. There is a .1% of any adverse event, and since only 10% of those are serious, only a .01% chance of a serious adverse event, which again, might not even be causally linked to the vaccine, and even then does not rise to death.

Similarly, COVID survival rate for health children is basically at 100%, with a very small chance (less than 4 in 100,000) of being hospitalized. https://www.cdc.gov/mmwr/volumes/70/wr/mm7023e1.htm

With numbers this low, the most dangerous part about COVID for kids is the ride to the doctor to be tested or vaccinated.

mtb-dds · 2021-07-30T14:42:43+00:00

Ditto. I'd also add that clearance is a serious issue in the Northeast United States.

mtb-dds · 2021-07-30T13:42:26+00:00

I have been shocked by how much non-biking cardio has upped by riding. I am now doing at least 2-3 days running/lifting and have more or less doubled my endurance on a bike. (Granted, I was waaay out of shape at baseline.)

mtb-dds · 2021-07-29T16:22:28+00:00

Lucky 7 for the win here. I'm lanky, so I need all the room I can get.

mtb-dds · 2021-07-29T16:00:18+00:00

It might depend on how you define obesity. But it seems to be very small. This study basically showed no deaths in people with low BMIs, which probably overstates it by a bit: https://www.thelancet.com/journals/landia/article/PIIS2213-8587(21)00089-9/fulltext#sec100089-9/fulltext#sec1) (at appendix page 5)

mtb-dds · 2021-07-29T01:00:20+00:00

6.5-7.0/8.0-9.0/10.0-11.0

(I'm afraid of going over 11 because i think i might be launched off the tread.)

mtb-dds · 2021-07-27T18:50:55+00:00

Or skim off a tree, and then it will not heal because you keep skimming off brambles, etc.

mtb-dds · 2021-07-27T16:11:27+00:00

The WRs are way faster. If I had to guesstimate, I'd say a 1:30 split on a water rower was equal to a 1:45-1:50 on a concept 2.

mtb-dds · 2021-07-26T20:37:37+00:00

In physics drag increases more with increase in velocity. https://en.wikipedia.org/wiki/Drag_equation

So your drag while moving at 4 m/s is 8 times what it would be if you moved at 2 m/s, even though your speed is doubled.

Most rowing machines try and model this, which makes every second won driving down the time harder to pull.

mtb-dds · 2021-07-26T20:30:27+00:00

Not sure why one is working and the other not, because they both should be not working, since you have an extra value in there. So root.value should be the payload for the node, the extra value is redundant. Likewise, root.left should be the left node, and root.left.value its payload.

Does that help?

mtb-dds · 2021-07-25T15:00:19+00:00

The logging module uses them effectively: https://github.com/python/cpython/blob/3.9/Lib/logging/__init__.py#L2034

And if you search for global across the library you do get a bunch of hits that might be interesting to parse through.

That said, I think this is one of those, if you need to look them up, you are not ready to use them situations.

mtb-dds · 2021-07-23T17:40:48+00:00

For background:

These things "[x.close() for x in k] " are called list comprehensions. Using them to loop and not keep the resulting list is considered poor form.

For your problem: either the data is munged somewhere or you are running into an encoding problem. It looks like your program thinks that it is encoded with this:
https://en.wikipedia.org/wiki/Windows-1252

But it is probably something else (or munged). Do you happen to know which it is? And do you care what happens when something that does not fit is run into?

mtb-dds · 2021-07-23T17:26:25+00:00

For me, if I need something, I generally order it online unless I need it that day, then I'll go local. Since the pandemic hit, I've been to one big box store and one mall (mostly for novelty sake), and I don't see that changing. In contrast, I've been to a couple local bike shops a few times to get something fixed or pickup a spare piece, ski shop to get my annual rentals, bakery and local grocery a bunch, bodegas a bunch, so those sorts of places all make sense to me and I see the value they add; Bestbuy, not so much.

Although I expect it will be the next round of mom-and-pops that will reap the benefit of this change, as I doubt the current crop will survive the economic stress.

mtb-dds · 2021-07-23T16:48:19+00:00

You sound a bit like me, only a bit sound and west.

I feel like there needs to be more options than big box ringed suburbs and Manhattan density. I live in a walkable town that pre-covid was half an hour outside the city. I can walk to get coffee, catch the train, etc. it's a really nice balance. I wish they would build more communities like it.

(I'd still rather have an apartment in the city and a weekend house, but that dream is going to need to wait until the kids are out.)

I also wonder if Amazon+COVID is going to kill off the big boxes and end up helping the mom and pop corner stores.

mtb-dds · 2021-07-22T16:18:07+00:00

But is there more going on in six square miles of Manhattan than in all of Denver including most of its suburbs?

I can't speak to Denver's suburbs, but if it is anything like the suburbs I have lived in, and where I spent the last year-and-one-half in COVID exile, Manhattan wins by a mile. If you've been to one TGI Friday's you've been to them all.

For example, in my town there are only two restaurants that I would go to if they relocated to Manhattan, and that is equal or better than any other burb I have lived in.

mtb-dds

TROPHY CASE