Oddbean new post about | logout

Notes by Sleigh Dodds πŸ§‘β€πŸŽ„ | export

 I keep checking in on the Solid project, but I'm confused about what problems its solving for users or developers.

https://blog.ldodds.com/2024/03/12/baffled-by-solid/

#personaldata #datainfrastructure 
 Couldn't get to the end of the a16z screed. 
 The sales email non-sequitur's just keep coming. 
 Booked myself a winter flu jab. Wish I could do the same for a Covid booster. 
 This Γ¬s a great piece from Which looking at who benefits from Sunak's NetZero policies* and the claims that we are a leader in NetZero**

https://www.which.co.uk/news/article/what-the-changing-net-zero-policies-will-really-mean-for-consumers-aMGe13Z2cMEZ

* landlords
** we are not 
 Going to miss Steve Lamacq when he finishes the early evening slot in a couple of weeks. 
 Its shouting into the void, but it's cathartic shouting into the void.

You can do it too, here:

https://petition.parliament.uk/petitions/641904 
 There's still time to apply for a role in my team at EnergySparks

https://energysparks.uk/jobs/1/inline

Looking for a remote, UK based ruby/rails developer to help us build and scale the product.

Small, friendly motivated team working on a rich, data-driven product to help schools save money and teach kids about climate change.

Interesting engineering work in a role that matters.

#fedihired #getfedihired #rubyonrails #energysparks 
 Google Drive is so great.

Apparently it's so non-obvious how to share a link to a folder that I'm being sent manually typed out directory paths. 
β–² β–Ό
 nostr:npub194h76frd3mdsp67fn85kdemcn8m0ur5e6qcflnwwap9q25gwj96qdj4ewx Can you filter the array yo... 
 @be8f70d6 probably, but benefits of doing the upsert is to push the comparison checks to the database. Adding a WHERE clause fixes that as we then do inserts and conditional updates.

So I've sorted our issue, am just surprised the feature isn't supported wondered if I was missing something. 
 So the Rails upsert_all method doesn't let you specify a WHERE clause which can mean doing lots of unnecessary updates of existing data.

Worked around that with some custom SQL but seems like a limitation in the current code. 

Anyone else seen this/worked around it?

#ruby #rubyonrails 
 Not sure these temporary pools "make a lot of financial sense", especially when you factor in the energy costs of running them.

https://www.bbc.co.uk/news/uk-england-hampshire-66980954

#energyefficiency #schools 
 They should have a content warning before they have a Tory on the telly. And maybe a human for balance. 
 @2fd7551e do you know why the Coventry api isn't used? Assume no-one has bothered to integrate with it, or jump through hoops to get access? 
 At the "How did that ever work" stage of debugging an issue. 
 Scifi (and tech bros) predicted that exponential increases in technology would eventually let anyone upload themselves and live in any reality they choose to construct.

Turns out we didn't need that. 

Reddit and social media was enough. 
 Dear sales people: I never want myself to be looped back in, kthxbye. 
 @66c8914f will have a read, and might come back to you thank you. Going to get some expert advice on what's feasible for us in a mid terrace house. 
β–² β–Ό
 nostr:npub194h76frd3mdsp67fn85kdemcn8m0ur5e6qcflnwwap9q25gwj96qdj4ewx Is that a) just the heat pu... 
 @8498c3c0 it's wasn't a detailed quote, but the estimate was for retaining current radiators, etc. Interior wall insulation another 15-20k 
 Trying out a retrofit planner to look at options for going zero carbon for our home. 

Looks like a heatpump will cost at least Β£25-30k and end up costing us about Β£1500 extra a year on electricity bills.

I really want to make some improvements but not sure we can afford that! 
 If you're in the West of England Combined Authority you can get a Β£250 voucher on a home tradition assessment 

https://www.retrofitwestadvice.co.uk/

#weca #retrofit #energyefficiency 
β–² β–Ό
 nostr:npub194h76frd3mdsp67fn85kdemcn8m0ur5e6qcflnwwap9q25gwj96qdj4ewx thing is, he’s a pretty s... 
 @e43fdc26 well quite. Everything they've done in last week or so is in that category 
 Those poor car owners. So glad someone is finally standing up for them.

https://www.bbc.co.uk/news/uk-politics-66965714 
β–² β–Ό
 nostr:npub194h76frd3mdsp67fn85kdemcn8m0ur5e6qcflnwwap9q25gwj96qdj4ewx ok *that* is as good as a c... 
 @fd38d0b5 it's mostly filmed on location and they've added visual effects later. Looks great 
 I really enjoyed The Creator!

The visual design is really striking, and reminded me of Simon StΓ₯lenhag and Ian Hubert. Like *a lot*

#film #thecreator 
β–² β–Ό
 Ok but what if your past light cone defining your observable universe is actually a method of laz... 
 @888826fe now I want to read a Culture novel called "Eventual Consistency" 
 I've been really enjoying this album this week:

Black Classical Music by Yussef Dayes

https://yussefdayes.bandcamp.com/album/black-classical-music

#music #bandcamp 
 Happy Google Sunsetting All The Things month for those that celebrate. 
β–² β–Ό
 nostr:npub194h76frd3mdsp67fn85kdemcn8m0ur5e6qcflnwwap9q25gwj96qdj4ewx What stresses me out is if ... 
 Mastodon needs a better way to indicate a DM from other posts. 
 Looks like @9b925ea6 are launching a new project to look at open election data and standards:

https://okfn.org/en/projects/digital-public-infrastructure-for-electoral-processes/

Lots of existing work in that area, but here's some I did in 2014 looking at existing data sources, approaches to published and suggesting a conceptual model for a standard.

https://blog.ldodds.com/2014/08/08/research-investigation-into-publishing-open-election-data/

#opendata #openelections 
β–² β–Ό
 nostr:npub194h76frd3mdsp67fn85kdemcn8m0ur5e6qcflnwwap9q25gwj96qdj4ewx those are areas thet benefi... 
 @03ee4b50 no, as I understand it the satellites just broadcast standard signals and then they're just used in different ways. 
 @03ee4b50 from what I could see the uses were:

- the location, so lots of obvs examples there
- timestamps, in finance, energy, weather reporting, and apparently NTP servers use it too
- creative uses of the signals for other purposes, e.g. for earth observation research. Linked to some of those in the post

I've not come across anything else at the moment. 
β–² β–Ό
 nostr:npub194h76frd3mdsp67fn85kdemcn8m0ur5e6qcflnwwap9q25gwj96qdj4ewx are there other types of da... 
 @03ee4b50 from what I could see the uses were:

- the location, so lots of obvs examples there
- timestamps, in finance, energy, weather reporting, and apparently NTP servers use it too
- creative uses of the signals for other purposes, e.g. for earth observation research. Linked to some of those in the post

I've not come across anything else at the moment. 
β–² β–Ό
 nostr:npub1jhyrgsw7r2el2xymduhx9pqsvpkrnz9k5etam5fln75nqsm9cy3qlu5uhr nostr:npub194h76frd3mdsp67f... 
 @9983d143 @95c83441 I meant to mention that on the post! 
 It takes about 4588 quasars to help you get around and get paid.

#datainfrastructure #geospatial #gps #valueofdata

http://blog.ldodds.com/2023/09/26/it-takes-about-4588-quasars-to-help-you-get-around-and-get-paid/ 
β–² β–Ό
 nostr:npub1zu7r9pe3hxxvvq2c0v6psj6uq69ljkf9kx6ud695p6985klptqnqd4c2ee "The Company"  (but yeah, p... 
 @c3187b80 @173c3287 but there are W-Y logos on offices doors, etc so they're not exactly a generic company in the film 
β–² β–Ό
 nostr:npub194h76frd3mdsp67fn85kdemcn8m0ur5e6qcflnwwap9q25gwj96qdj4ewx Doesn't he just work for Th... 
 @173c3287 WY is The Company though? 

AVP wiki cites Cameron:
 https://avp.fandom.com/wiki/Carter_Burke 
β–² β–Ό
 Well, I've sent the email asking if I'll get paid this month and that I'm looking for a new job b... 
β–² β–Ό
 Both Labour and Tories proposing a "vaccine taskforce" for every gnarly sociotechnical problem is... 
 @7d0b4a22 I can never work out whether this cookie cutter approach is because they can never come up with other options, or they think we're too dumb to see value in anything different. 
β–² β–Ό
 The bins in #Dublin are solar powered, which is great I suppose, but why do bins need to be power... 
 @38d46233 they've got a compactor in them, and also a notification when they're full. but some of them also house wifi / geofencing kit. 
 Carter Burke was a graduate of the Weyland-Yutani data ethics programme. 
 Moving our youngest to uni today. #gulp 
 @3d4b19d1 yes so presumably I have to put both the excerpt AND the tags into that box, which I've already set elsewhere

Which is the bit that I find frustrating as the text is already in existing fields that Wordpress can read. I shouldn't need to copy stuff between fields. 
 @3d4b19d1 thanks for the help though! 
β–² β–Ό
 nostr:npub194h76frd3mdsp67fn85kdemcn8m0ur5e6qcflnwwap9q25gwj96qdj4ewx That's the problem. You nee... 
 @3d4b19d1 yes so presumably I have to put both the excerpt AND the tags into that box, which I've already set elsewhere

Which is the bit that I find frustrating as the text is already in existing fields that Wordpress can read. I shouldn't need to copy stuff between fields. 
β–² β–Ό
 nostr:npub194h76frd3mdsp67fn85kdemcn8m0ur5e6qcflnwwap9q25gwj96qdj4ewx Do you add the tags to the ... 
 @3d4b19d1 no, just adding tags to the scheduled post, in the tags box 
β–² β–Ό
 nostr:npub194h76frd3mdsp67fn85kdemcn8m0ur5e6qcflnwwap9q25gwj96qdj4ewx The tags I'm adding to my W... 
 @3d4b19d1 hmm, OK I'll have another look.

I had a scheduled post get shared here earlier which had tags and an excerpt. The excerpt was used but not the tags. 
 Kind of annoying that the share to Mastodon option for blogs hosted on Wordpress.com doesn't include the tags.

Unless l'm missing something? 

#wordpress #mastodon 
 The commons: it’s OURS toΒ GIFT

I was thinking about some of the key elements we might want to see in a sustainable, participatory, ethical data commons and this popped into my head.

http://blog.ldodds.com/2023/09/17/the-commons-its-ours-to-gift/ 
 I got cross about people citing Hardin when Ostrom has the insights and the methods.

https://blog.ldodds.com/2023/09/16/please-skip-hardin-just-focus-on-ostrom/

#datacommons #ai #commons 
 Please skip Hardin, just focus onΒ Ostrom

A few weeks ago Aljazeera published this opinion piece on "AI and the tyranny of the data commons". It's not very good. The core observation can hardly be disputed: "platforms" have hoovered up data for their own benefit. Most recently through AI. Nothing much to disagree with there and nothing you can't find in a million other similar articles.

http://blog.ldodds.com/2023/09/16/please-skip-hardin-just-focus-on-ostrom/ 
β–² β–Ό
 nostr:npub194h76frd3mdsp67fn85kdemcn8m0ur5e6qcflnwwap9q25gwj96qdj4ewx AFAIK Supermarket chains (&... 
 @8498c3c0 the code from that thread was open, so could  reuse that to scrape website data. But agree with you that there's interesting additional observations to come from local data. 
 Fantastic thread on crawling and analysing supermarket price data. Would be great to see someone pick up this code and run it for the UK.

https://mastodon.gamedev.place/@badlogic/111071396799790275 
 Anyone got tips on finding places with outdoor dining in the SF Bay Area?

Searching Google Maps ... 
Event not found
 Hilbert's Pull Request 
Event not found
 @0947cf4e yes, I'd certainly like a better way to manage my information/data/whatever. 
Event not found
 @888826fe really enjoyed this one 
Event not found
 or I guess anything generated by an AI really. 
Event not found
 Now I want to know what are the most requested pages* at the Internet Archive.

* that are 404s 
Event not found
 @d73ffc67 nice setup! I've literally just cued that up as well, (although digitally) 
Event not found
 Had an excellent week in Denmark with the family. Aarhus for most of the week then a couple of nights in Copenhagen. πŸ‘