interesting, I've had a much easier time pairing (and felt benefits like you describe) over Zoom. Pairing by actually having 2 people at a desk never felt very comfortable, but screen-sharing with each person on their own monitor etc. works great, IME. I'm curious what you've tried / why it hasn't worked...
Back in the day, about 15 years ago now, when I was pair-programming every day and trying to teach new people how to do it, everyone was awkward at first. People who were Vim experts suddenly started stumbling over basic tasks. All of them who persisted eventually got over the awkwardness. Not all of them enjoyed the pair programming, but the ones who I talked to later found that it wasn't as awkward after a bit.
> This is a pure panic run on the bank though, irrational and counter-productive. The bank was not insolvent and could have been fine if everyone didn't withdraw all at once.
This is incorrect. SVB converted deposits to risky paper that lost value. They were insolvent.
The fact that the risky paper would return its promised 1%/yr, if everyone just waited 10 years, is a canard. SVB's depositors could get 4% elsewhere, today. Asking them to sit tight at 1% is the same haircut as liquidating that paper at a loss today (which is what happened).
4% inflation per year (the most common estimate I see in the US) means 3x over 30 years doesn't even break even (1.04**30 ≈ 3.24).
I often wonder how much people obsessed with home prices rising (in the US at least) take this into account. How much housing mania is fueled by people getting excited about gains that aren't as real as they think?
I did some very rough spreadsheet work, collecting average UK house prices[0] and rates of inflation[1] and tried to figure this out. So starting with January 2007's average price of GBP 176,758 I tried to repeatedly apply the annual interest rates I end up with:
* Jan 2007 price (inflation adjusted to 2022): GBP 243,199
* Jan 2022 price (actual): GBP 273,762
So it seems that in the UK at least the prices do seem to grow ahead of inflation. And the starting price we're talking about here is after a long, sustained housing bubble and was already quite unaffordable for many. Further still I think many people's wages have kept pace with inflation.
So looking at the raw price changes doesn't tell the whole story, but the whole story is still quite grim.
If you try with an higher income, let's say 30-39, respectively 26,000 and 33,000
33,000/26,000-1= 27%
I think we can say that average houses have appeciated almost double average wages in these 15 years, which is the essence of the crazyness about houses being not affordable to most, and - as you said - it's not like in 2007 houses were cheap, data for a longer period show even more how young people then could actually buy a house and now it has become impossible:
Ah damn I messed up part of my comment, it should've read:
> Further still I don't think many people's wages have kept pace with inflation
But yeah either way - houses were expensive, and have only gotten more unaffordable as inflation outpaced wage growth and house prices outpaced both. Wild.
This is great point I often make. Not many people take this into consideration. Now, inflation has been lower than 4% for last 10-20 years. But the point stands.
Even in Europe, cars are quite common for everyone. Maybe less for the middle class in big cities, but the traffic in London and Paris is quite terrible.
By that logic pretty much every accidental death that's a result of the modern world would be "caused by humans". House fires, heavy equipment mishaps, cancer from exposure to exotic man-made substances, overdoses, icy staircases, it's a long, long list.
Seems to me that adding all that crap in would make the category so broad as to defeat the point of categorizing. IDK if that was your point or if you just wanted your pet issue in the category.
We have many ways to lower car accidents and deaths in a country like the US. No effort is given to public transportation. Not counting them wouldn’t make sense unless enough effort was put in to lower those numbers. An accidental house fire isn’t the same thing at all. There weren’t major decisions made to purposefully allow sprawl and lack of funding into something that lowers house fires.
Interesting case, but some of these are more like suicides (intentional or otherwise), and I think we were talking about one organism killing another. But still, you're correct, some significant portion of these must be one human killed by the actions of another.
The 10MB estimated size came from [100 bytes per row] * [100k rows].
50 of the bytes per row were "description", which should compress well (2-3x, I'd guess).
40 bytes per row were the IPFS ID/hash, IIUC. I assumed this is like a Git hash, 40 hex chars, which is really just 20 bytes of entropy.
He also estimated 14 bytes for the size (stored as a string representation of a decimal integer, up to 1e15 - 1, or 1PB?). That's about 50 bits or 6-7 bytes, as a binary integer. Sizes wouldn't be uniformly distributed though so it would compress to even fewer bytes.
So if SQLite was smart (or one gzips the whole db file, like you did), it makes sense that a factor of 2 or so is reclaimable.
if you are "cutting and pasting from the notebook into a .py file" you should look at `jupyter nbconvert` on the CLI.
I think there's ways to feed it a template that basically metaprograms what you want the output .py file to look like (e.g. render markdown cells as comments, vs. just removing them), but I've never quite figured that out.
afaict they just released 78.0.2 with a revert of the offending bits