houseofleft

It doesn’t split, but I’d guess 99.9% of those online meets are dating apps (rather than other ways of meeting online).

That’s kind of sad, not because there’s any one way people should meet, but because meeting people is now mostly mediated through for profit companies.

How much CO2 does AI use compared to other industries? I know it’s a horrific use compared to all other software, but have no idea how it factors in global carbon emmissions?

Also, just to be clear, I’m genuinely curious and not defending burning huge amounts of carbon for profit if the AI sector is comparatively small. That kind of backwards “but it just a small amount of everything else” logic would be a great way to accelerate our already too fast death spiral.

Yeah, hopefully this is some genuinely good news, but it’s hard not to see it as an unbelievably positive spin on the fact that this year we’ll emit more CO2 than any year in record.

I don’t know specifics on this battery farm, but almost all are essentially fleets of shipping containers filled with smaller batteries, rather than some super-cool-mega-battery, so it’s probably a safe assumption that this is a landmark project in scale, rather than in technology specifics.

Yes, for sure!! I hope my call for policitcal action didn’t come across as “don’t do anything and wait for politicians to sort it out!”.

I was trying to get at the need for collective discussion and action, over the idea of a climate change fix that’s based on people’s feeling superior for their individual actions, especially because without political change, a lot of even the individual changes we need to make (more heatpumps, EVs over ICEs, etc) are only accessible to those with sufficient wealth.

Oh boy, have fun! CTEs have pretty wide support, so you might be in luck (well at least in that respect, in all other cases you’re still using saleforce amd my commiserations are with you)

Honestly moral superiority needs to get taken out of climate change as a whole. It’s a global issue that needs political solutions. Nobody’s individual actions are gonna change their nation’s heating systems from gas, grids energy make up to solar, or billionaires to climate activists.

I have advice that you didn’t ask for at all!

SQL’s declarative ordering annoys me too. In most languages you order things based on when you want them to happen, SQL doesn’t work like that- you need to order query dyntax based on where that bit goes according to the rules of SQL. It’s meant to aid readability, some people like it a lot,but for me it’s just a bunch of extra rules to remember.

Anyway, for nested expressions, I think CTEs make stuff a lot easier, and SQL query optimisers mean you probably shouldn’t have to worry about performance.

I.e. instead of:

SELECT
  one.col_a,
  two.col_b
FROM one
LEFT JOIN
    (SELECT * FROM somewhere WHERE something) as two
    ON one.x = two.x

you can do this:

WITH two as (
     SELECT * FROM somewhere
     WHERE something
)

SELECT
  one.col_a,
  two.col_b
FROM one
LEFT JOIN two
ON one.x = two.x

Especially when things are a little gnarly with lots of nested CTEs, this style makes stuff a tonne easier to reason with.

I find meat eaters ask me “would you eat grown meat?” a lot, but my response is always just “I guess maybe? I honestly don’t miss meat that much”. I haven’t come across any vegetarians/vegans who are particularly psyched about it either.

This is all speculation, but I’m not particularly convinced there’s much of a market for lab grown meat over soy based products given how much more expensive they need to be.

I know your comment is satirical so I don’t really want to take it in bad faith, but all the same. . . .

Lots of people are working reeaaally hard at changing society for the better, and reducing environmental catastrophe, the studies from the 80s sparked soneof the biggest environmental groups we have today (the likes of Green Peace and Friends of the Earth).

Lots of other people, often with money, are cynically blocking the protection of the human race for their own gain. And the majority of people are caught between these groups, often feeling despondent.

My point is, don’t get despondent, get involved! You can join the first groups efforts today, and it you do, you’ll be concretely helping the survival of our planet and society.

If you’re interested in specifics, both Green Peace and Just Stop Oil hold regular monthly/weekly welcome to all sessions (if you know about others, post them here!)