rdubz
Joined 14 years ago
Joined 14 years ago
```bash
parquet2json cat <file or url> | grep ...
```
There were a few other hits as well. This one mentions the Steve Jobs quote and corroborates "Scientific American, 1973" https://www.smestrategy.net/blog/using-the-6-thinking-for-st...
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?
https://www.cdc.gov/injury/features/global-road-safety/index...
Seems to me that traffic deaths are "caused by" humans... not totally surprised they have decided those don't count, but I feel that that's wrong.
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.
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.
1. healthy decentralized services often have <1% of users who do "want to run a server," and the whole thing works as a result 2. immutability / inability to change quickly is good for protocols 3. crypto community does need to decide whether it cares about money or decentralization
Took a while getting to the good part of 1. Should have skipped "'no one wants to run a server' is factually incorrect!"
I loved the Moxie piece but it was strange bc Moxie is a legendary cryptopunk who presumably believes decentralization is good (though hard to attain/maintain)... right? Moxie made excellent points but left me wondering what he actually thinks, or thinks should happen.
I also liked the pushback here about email being an example of failed decentralization, because Gmail is big or something? Email seems like the last major decentralized communication protocol still standing, despite incredible centralization/"balkanization" of the messaging space.
They used to just put "?s=19" through "?s=22" or so, which enumerated clients (desktop, mobile, Android, etc), which was better than the junk most other services stuff in (like utm_source and friends...)
"Better bike infrastructure" and "a bit of pedal assist" are both good things that we need more of.
Even in the best possible future, I believe cycling in US cities will involve some amount of mixing with cars for the rest of my natural life (unfortunately!), so I'm not sure "completely bogus if…" is fair.
And anyway, a little extra speed is still useful because it's transportation.
Here's a fun thought experiment: define "places I can go" as "the locus of points within 1hr bike ride of a train station." If e-bikes let me go 50% faster (say, avg 15mph instead of 10mph), that multiplies the accessible area around each train station by 2.25x! I can go more than twice as many places now!
In that range, and in mixed traffic (which is unfortunately most urban riding in the US), a 5mph difference can be a step change in terms of whether drivers even feel the need to pass me at all. 15mph is only 50% faster than 10mph, but can totally flip the "who's passing who" dynamic from "cars passing me frequently+aggressively" to "cars hesitate, back off, and then I get ahead / pass the next cars in line at the next light."
Here's an account where I've been posting videos that illustrate this a little more viscerally: https://twitter.com/CarsDontFitJC/status/1457490588320817153
I'm comparing new cars to new e-bikes and, sure, in both cases you can get something "pretty good" for ≈half the average new {e-bike,car} price. Some people will get something "very good" for 2x the average!
From what I can tell the research supporting the $40k average (or, alternatively, $800/mo) seems reasonable:
https://www.cnet.com/roadshow/news/average-new-car-price-202... https://www.motor1.com/news/370609/average-american-monthly-...
Definitely something I want to hash out and cite more though.
afaict they just released 78.0.2 with a revert of the offending bits