• 2 Posts
  • 46 Comments
Joined 3 months ago
cake
Cake day: August 16th, 2024

help-circle
  • I have a Fairphone 4 and would definitely give them the biggest recommendation I could.

    Any part can be replaced with a screwdriver which is an order of magnitude better than I’ve seen with other brands. I dropped and broke my phone screen and although I had to buy a new screen, after that I had a phone working as if it was brand new.

    I also got mortar into my usb charging socket and was able to replace the charging socket.

    You might be able to tell that I’m not the best at looking after things, I’m working on this but in the meantime, fairphone have saved me at least two situations where I’d normally need to buy a new phone. Can’t recommend them enough.



  • I think there’s a lot of focus on minimizing individual’s impact, and don’t get me wrong, that’s a great thing to do, but it puts burden and guilt on people for things that are out of their control

    If your government (wherever you are) held fossil fuel companies and the agro-industrial complex to account and encouraged investment in renewables, public transport and ground sourced heating, you would be living a low impact lifestyle just by going to work, buying your groceries and living normally.

    If you have the money to invest in solar panels, EVs etc, that’s fantastic, but don’t feel guilt for not being priviledged!

    The most impactful thing you can do is put pressure on your government to recognise the impact we’re having on our ecology. Sign petitions, write to your representative, fund and/or join activist groups.

    Importantly, try not to feel shamed, as an individual you didn’t cause the situation (unless maybe you are a fossil fuel lobbyist, or oilcompany CEO) - go easy on yourself and just do what you can.


  • Thanks for such a detailed response! I’m planning on mainly using it for smallish trips, say heading into my local town. I’ve recently move to being just outside walking distance but it’s very short distance to drive for.

    I also live around a lot of woods and it’d be good to be able to ride on a dirt path now and then.

    From what I can see a ‘hybrid’ sounds like it’d be a good fit?





  • By the power invested in me by, well, nobody whatsoever, can I just take a minute to say, let’s all cool down a little in the comments!

    There’s a lot of arguing against:

    • The idea that acknowledging the tragic reality of climate change makes you defeatist
    • The idea that because we have had some great advantages in green tech we can sit back and let climate change fix itself

    I don’t see anyone making those arguments here though! Just lots of people concerned about climate change with different skews of how positive/negative we should feel.

    Personally, I swing between powerful optimism and waking in terror at 3:00am for the future we’re hurtling towards. I’m sure other people are the same, so let’s just be friendly to the fact that other people are in different vibes to us.

    There are some people working together very well right now to dismantle the climate, so let’s all remember that when we’re talking with each other.

    Peace and love!








  • 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 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.