durkie

any idea why postgis hasn't formally incorporated S2 cell functions? It seems like it'd be right up their alley.

So this is kind of tangentially related here, but is there a "state-of-the-art" or best practices on digging through big JS apps / frameworks / objects? Ultimately this is all code running on my machine, so it feels like it should be accessible in the console somewhere.

I've had to do a fair amount of this with a Chrome extension I maintain that hooks in to routing (creating bike / running routes) sites, and fortunately these mostly use React and I'm decently familiar with how to hook in to that.

But is there a limit here? Is there a way to actually keep code from being inaccessible to the console (aside from obfuscation / compiling to wasm)?

wow, thanks for the thorough reply. Atlanta's pawpaw population is taking off and they're fun to introduce to people, but I've been hesitant to do so more lately knowing that they may not be 100% good for you. seems like it's actually not so bad in moderation.

Surprised the efficiency is so low. Those Wh/mi numbers are comparable to a Tesla Model 3 or Model Y, vehicles that presumably weigh substantially more.

That's correct. If i run `User.limit(5).pluck(:id)` the query it runs is `SELECT "users"."id" FROM "users" LIMIT $1 [["LIMIT", 5]]` and returns an array, not an ActiveRecord association

how is it a "virtue signal"? what are they signalling?

i'm curious where morality fits in to anything in your worldview if telling the (well-documented) history of a forcible displacement of a people is "virtue signalling" and "getting the morality into it".

sure? you get to make that decision. ".uk" and ".us" are more straightforward in what governments/histories they're linked to, and the origins ".io" is not as well known, hence the article.

Geoff Manaugh, author of this blog, has a fun book called "A Burglar's Guide to the City", discussing how city layouts influence the types of crimes committed there.

One example that I remember talks about the differences between Los Angeles and New York City: at one point in the 1990s, LA was the bank robbery capital of the world, averaging over 1 per day for a while, but bank robberies rarely happen in NYC. When you compare their layouts, it makes total sense: LA was built around the car. The pattern of "highway offramp, bank next to the road, highway onramp" was everywhere throughout LA. Robbing a bank in NYC would be just so much harder: parking is more difficult, traffic is slower, way more people around to identify you, etc.

It's a good read.

lol on that VW CEO quote. hadn't heard that one before.

I wonder how it's going to balance out with lost sales though. The supercharger network is no longer a Tesla-exclusive amenity, so one less reason to buy a Tesla.

i've been to this! my friend's family is obsessed with it. it is truly an institution there and a delightful car-free neighborhood springs up on the fairgrounds, nutritionally supported entirely by watermelon, loads of southern "salads" and deep fried garbage

Yep, they do. Currently using them on AWS and pretty happy.

I'm super excited for this -- it seems like it's perfect as an app-local cache of things that can be a drop-in replacement for some high-cost queries.

Are there any plans to support which tables get copied over? The main postgres database is too big to replicate everywhere, but some key "summary" tables would be really nice to have locally.

In light of the release of Oppenheimer, people have been talking about, basically, the other side of the development of atomic weapons.

John Hersey's "Hiroshima" article from the August 23, 1946 edition of the New Yorker came up as the definitive piece on the immediate impact of the dropping of the bomb on Hiroshima, and it is a gripping read: https://www.newyorker.com/magazine/1946/08/31/hiroshima

does it need to be surprising?

There was a competing theory that scurvy was prevented by eating fresh meat, and that's easier to get in the arctic: https://idlewords.com/2010/03/scott_and_scurvy.htm

how often do your workers crash? i rely heavily on sidekiq and don't think I see this very often, if ever.

Not using tennis balls, but this has been a real product for atv tires for a while: https://www.powersportsid.com/tireballs/

This is a really lovely post about community, math and art. Has me interested in making my own bracelets or mini-tapestries. Thanks!

speaking of Elasticache -- I noticed that the "append-only file/AOF" feature for recovering from crashes/reboots is only available on AWS redis up to version 2.8.22, and we're now at like redis version 7 in the rest of the world..

There's a route that so many bikers have been waiting for in Atlanta of, taking amtrak west, getting off at the first stop (Anniston Alabama, 1 hour car drive away), and then riding all of the mountain bike trails at Coldwater Mountain. You could conceivably take the train back, or camp overnight in Piedmont Alabama and then ride the silver comet rail trail all the way back at some point.

Or just skip the mountain biking and take the train out and bike the silver comet all the way back home.

But! Amtrak won't let you take your bike off the train at Anniston. You have to go all the way to new orleans. It's really dumb and frustrating.

What was the pill?

Yes? The article is titled "Please don't film me in 2023"

Wandrer.earth founder here! Happy to help you get lost :)

Could you be more specific? I kept bees for a decade and don't know what you're referring to.

happy Stadia maps customer here! Good prices and solid service.

don't forget legacy and donor admission too

i'm planning to in a few months! would love any pointers or recommendations :)

yeah they've been super useful for me too. i haven't switched to the multirange datatype yet (still use int4range[]), but I'm excited to since you can now do exclusion constraints on multiranges, which will greatly simplify some things for me.

i keep track of roads that a person has biked/walked for Wandrer (wandrer.earth), and storing everything as a geometry would be a storage and analytical nightmare. keeping things as a range lets you easily determine what part of an activity covered new ground, and you can generate the geometry / length on demand while only storing a few integers (plus the raw road geometry, but that's shared among everyone).

Woohoo! This is fantastic news