Dremor

Personally, I wouldn’t call it “viral” if it does not propagate to other files. It may create a confusion.
On the other hand, I don’t think there is an agreed upon terminology to describe it, so if my explanation help someone better understand the concept, I’m all good.

I think you misunderstood what “viral” mean in that context.

If a file, under GPL, is added to a project, the whole project becomes dual licensed under the original licence plus GPL, which propagate to the whole project, like a virus. I know comparing it to something like a virus sound derogative, but this is the best way to describe its effect.

If a file, under MPL, is added to a project, the project do not become MPL, only the added part is. Said project cannot change the MPL licensed part to another licence, but still can build anything it wish using it.

Globally, a GPL licensed project protects the user more, but also prevent the devs from doing a lot of thing, which MPL does not.

In the end, this is the devs freedom to chose which licence they wish to publish their code under, not ours.

Probably, but I won’t touch that shit unless I have no way doing otherwise.

Edit : As an example, I got an “add or update” stored procedure that start line 5, and ends line… 226.

Yeah, you can do pagination, but you need two request : one to select everything, the second to only return the results between id x and id y. Needless to say, the performances are far from ideal.

But in recent version you do skip and take x, which is far easier to write. But my codebase date back to the 2000’s, and it uses the old ways.

As an example, an SQL request to filter on an handful of parameters, and paginate, easily amount to 40-50 lines of SQL. And that’s the easy ones, because some request uses multiple view, in which case I wouldn’t be surprised to find a request doing more than 100 lines of SQL, maybe without even factoring the view in.

I work with a client using an Oracle DB. You have to do multiple request to even do something basic as pagination 😂.

They improved it over the years, but given the choice, I’d advice for anything else than Oracle. I’d even prefer MS Sql, which, given I’m pretty anti-MS, is a miracle.

To rethink something, it would require to think first.

Sound more like you learned the hard way what “abusing the system” mean.

Idk, I still see 256GB Emtec ones for 10€ in my local supermarket.

That a shitty analogy… But a good one.

I did, I use Lawnchair.

Which is alright. It’s their project after all. I find myself very happy from my Murena Fairphone (except the launcher, which I hate), so I’ll probably be a good Fairphone/Murena client for the years to come.

That’s fair. We all have our needs, and I find mine in Fairphone + e/OS, which is nice. And when I upgrade, I get to give my parents an almost new, still supported phone, which is nice.

Low-range, yes. Mid-range, no. As soon as you get de decent quality camera, given you know how to use it, you’ll always get better result than smartphones.

I’m not that much into photos, so I can’t really judge. In my book, it is OK.

If you want to get good pictures, nothing will ever beat a dedicated camera, even a mid-range one is way better than a smartphone, even an high-end one, due to the size limitations.

Some of those requirements are really hard to get for non-Google devices. EOM don’t get updates as early as Google engineers gets. It takes time to validate everything, especially since their don’t control their own hardware.

Those requirements are more a way to not appear like dicks by telling that they’ll only supports Pixels.

With unofficial parts you can get anything, from very good parts to outright dangerous ones (especially batteries).

The problem with IPhone is their association system (which is illegal in the EU BTW). Understandable with those dangerous part on the market, but far too overcharging. They could just warn you during boot or something like that.

As for the software wall, it is where Fairphones shines. Even when the official support ends, the custom ROMs keeps updating for a while. IPhones are great on that aspect too, Samsungs are OK, but can’t say for other brands.

The choice of only supporting Pixels comes from GrapheneOS’s side, not Fairphone. Fairphone got some great ROMs support, and even have an official partnership with one of them (e/OS).

First party spare parts or third party sketchy spare parts?

Spare part availability comes partly from the popularity of a phone, and iPhones were pretty popular.
Fairphone is just starting to get some steam, so third party spare part may start appearing in the future. same for used parts.

Fairphones got a lot better lately. I got both the 4, 5, and now gen 6, and the latest one feels like a good phone, unless the FP4 which is a brick in comparison. Still lacks several Flagship feature (wireless charging, amongs other), but as a mid-range phone it is quite good.

And the repeatability is great. I repaired my FP4 once (usb-c port), and it was easy as heck.

Better than a benchmark, you should try Boinc or Folding@Home.

Heating by science.

A model being local doesn’t make it magically better than cloud based ones. Especially since your local hardware may not be as optimized as professional hardware.

And I say that as a local AI user.

The way to make it less harmful mainly comes from external factors :

• The origin of the electricity (renewable)
• Shift consumption to a time of low demand (or use a residential battery)
• Use specialized hardware for specific tasks (use less energy per token)

Edit:

I’d add to that that you can reuse the heat generated to heat your apartment. But it only works during winter, as during summer any heat generated will make your AC (if you have one) work harder.