houseofleft

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.

Man, I sure wish cybertrucks had been around to deflect when I spent 7 years driving a Fiat Panda.

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?

Thanks! Relieved it sounds easy enough to figure out

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.

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)

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.

What about a cap and trade market for battery fires?

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.

AI: "Have you tried funding public transport and regulating the carbon industry?"

Ok, now we need to make a new AI so that AI can solve global warming but without using an existing solution that might marginally inconvenience the mega rich.

Ok really tangential rant here!

I find societal attitudes to art and morality really crazy.

I don't necessarily disagree with the idea that art and morality should be linked, but it only ever seems to happen in a negative capacity of "don't listen to x because they did y".

There's a whole strain of:

• Artists who are not necessarily bad people, but whose art is aggresively immoral (I guess an obvious example would be Biggie Smalls or someone who frequently raps about sexual assault and violence in a positive way, but also the ammount of mainstream pop or country that has sexist or racist undertones)
• Artists who try hard to inject their morality into their work (such as Becky Chambers' climate positive fiction, or Giancinto Scelsi's anti-facist music)

On the whole, I don't see anyone care very much about the above two points, people just "like what they like", which is as if we think morality and art are two seperate things.

That makes sense, but then there's this wierd category where "oh that person did this bad thing, so now their art is invalid".

So, what's the overall attitude? Like, art isn't related to morality generally, but there's some mysterious line where if it's crossed art moves into the "forbidden zone"?

I'm all for calling bad people to account for their moral behaviour, but the way we do it in art is so jumbled and inconsistent.