• 3 Posts
  • 47 Comments
Joined 2 months ago
Cake day: August 16th, 2024
  • houseofleft@slrpnk.nettoFuck Cars@lemmy.ml•Bros who still buy Tesla's thinking they're morally superior need a reminderEnglish
    2·
    8 days ago

    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.

  • houseofleft@slrpnk.nettoProgramming@programming.dev•How proficient do you rate yourself in your most coded language?English
    6·
    8 days ago

    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.

  • houseofleft@slrpnk.nettoSolarpunk technology@slrpnk.net•Wine in Flat-Shaped Plastic Bottles: More Sustainable? - Core77English
    11·
    10 days ago

    I sorta have three not entirely coherent and increasingly cynical feelings about this.

    1. That’s neat! If redesigning bottles helps a little with emmissions then that’s cool!

    2. Even though it might reduce emmisions, sometimes I worry that people think this is what ecological stewardship looks like. “Keep on burning fossil fuels and running an economy based on the exploitation of the earth, just change the shape of your wine bottles and we’ll be ok!”. We’re not ok and this isn’t enough, small actions like this don’t cut it and we need to hold fossil fuel companies to account for the destruction they cause because it’s too late.

    3. Wait, it’s plastic!?!? Are we gonna pretend like CO2 is the only issue and killing millions of fish with plastic a year is something to ignore? Also, doesn’t that effect the global carbon heat pump? Seriously, why is it plastic!?!? My only thought here now is that this is some cynical greenwash of a decision that was made to maximise profits and reduce costs.

  • houseofleft@slrpnk.nettoClimate - truthful information about climate, related activism and politics.@slrpnk.net•UK’s £22 Billion Carbon Capture Pledge Follows Surge in Lobbying by Fossil Fuel Industry: Scope of corporate influence underscores how the technology will prolong demand for planet-heating methane gasEnglish
    1·
    14 days ago

    I don’t agree they’re looking at all areas at once, solar, wind and the net zero per mw by 2030 goal only relate to energy, not things like gas heating reduction, or public transport etc. Energy is also one of the few areas where as a country we’ve already made quite a bit of progress. There are points where only 10% of the UK’s energy comes from fossil fuels.

    In fairness, I did share the wrong article, sorry! Here’s the actual opinion piece it’s referring to (which was written in the Sun, I agree it’s a shit rag, but Kier Starmer chose to publish in it, so here we are): https://www.thesun.co.uk/news/30853358/keir-starmer-great-british-industry-net-zero/

    Specifically, the bits I’m referring to are:

    This ground-breaking technology, known as Carbon Capture Usage and Storage, is a game-changer in our efforts to fulfil our legal obligations to reach Net Zero by 2050 in a sensible way, while supporting jobs and industry.

    Shifting focus onto onto bare minimum meeting of legal obligations and positioning carbon capture as a central part of that strategy.

    To those drum-banging, finger-wagging extremists I say: I will never sacrifice Great British industry.

    Said in opposition to people wanting regulation of carbon emissions over carbon capture investment.

    But this is a third way that brings industry with us on our path to Net Zero

    Again, in opposition to regulating emissions more strictly.

    To be 100% clear, this is speculation from Labours messaging that implies they’re gearing up for a massive backslide, we won’t know for sure until their budget is announced over the next few weeks. I think this is where a lot of objection comes fron though. If we see large investment in public transport and heat pumps, and regulation of emissions, then I’ll be extremely happy to be proved wrong.