bjorney

Right? it screams wayyyy pre-y2k but MySQL was only release in 95

will it become a relic of the past?

Probably

why YEAR in the first place, who would actually make use of it?

Accounting systems in the 90s that needed to squeeze out every drop of performance imaginable

I expect it won’t

The year datatype is a 1 byte integer, but the engine adds/subtracts 1900 to the value under the hood and has special handling for zero.

If you need to store more than 255 years range, you can use a 2 byte integer, which doesn’t need that special handling under the hood, because with 2 bytes you can store 65000+ years

The nests (and many other thermostats) let you operate the fan independent from the AC.

I configured my fan to run 15 minutes every hour regardless of whether or not the AC/heat is running and it fixed all of my issues with the upstairs being way too hot.

There are like 10,000 different solutions, but I would just recommend using what’s built in to python

If you have multiple versions installed you should be able to call python3.12 to use 3.12, etc

Best practice is to use a different virtual environment for every project, which is basically a copy of an existing installed python version with its own packages folder. Calling pip with the system python installs it for the entire OS. Calling it with sudo puts the packages in a separate package directory reserved for the operating system and can create conflicts and break stuff (as far as I remember, this could have changed in recent versions)

Make a virtual environment with python3.13 -m venv venv the 2nd one is the directory name. Instead of calling the system python, call the executable at venv/bin/python3

If you do source venv/bin/activate it will temporarily replace all your bash commands to point to the executables in your venv instead of the system python install (for pip, etc). deactivate to revert. IDEs should detect the virtual environment in your project folder and automatically activate it

A server produces an amount of heat equivalent to it’s wattage.

A 500W server rack will produce 1/3rd the amount of heat as a 1500W space heater. If your rack draws 100W at idle, than that’s how much heat it produces. So if it’s cold outside you could spin up folding at home or some other thing to burn excess CPU cycles

As long as your server is inside your house it is offsetting the amount of heat your HVAC system needs to produce - granted it is also greatly increasing the amount of work your AC needs to do in the summer

There is a cricket farm in Quebec that heats it’s enclosures with Bitcoin mining rigs.

Not with 64gb ram and 16+ cores on that budget

They aren’t being made anymore - people are just reselling old hoarded stock

https://eyeondesign.aiga.org/we-spoke-with-the-last-person-standing-in-the-floppy-disk-business/

“how dare they use the right tool for the job without taking the time to learn how to do it sub optimally first”

You are implying people choose to work in HR because they are heartless corporate bootlickers who like crushing people’s lives, and not because, idk, it’s a job they get paid to do

The plastic liners in and on tins and cans - referred to as lacquer in the industry - don’t impact recycling. When the tins are heated to thousands of degrees for recycling, what is left of the plastic liner, the inks and UV materials; is separated and basically skimmed off, leaving the metal.

https://ekko.world/plastic-lining-on-beverage-food-cans/226751

the recycling pickup people

It’s not, it’s usually retirees or homeless people doing it for cash

numbers are just cursory googles so they may be off, e.g. “carbon footprint of a burger” (~3.2kg CO2 per) followed by “calories in a big mac” (590)

The majority of the calories in a burger come from the bun and condiments, so it’s pretty far from a “stupid” amount of meat - As sad as it is, the average american eats 12.2oz of meat a day, and a big mac only has 3.2oz

Food production (particularly beef and rice) are among the worlds largest sources for methane (a worse GHG) - also usually fossil fuels burned by production/transportation is generally factored into these estimates

Regardless, the point i was poorly making is that this infographic sucks because it makes a false equivalency between “energy efficiency” and “good for the environment”. As I noted - biking is substantially more energy efficient than driving an ICE (~21x; 800 vs 16680), but after adjusting for the carbon footprint of food, that 21x becomes somewhere in the range of ~1-9x depending on diet. I suspect this graphic doesn’t list ICEs because they weight half as much and likely come in at a higher efficiency (despite being better for the environment) - which of course goes against the narrative it’s trying to present

lol all good - I posted some napkin math above - https://lemmy.ca/comment/7747680

Long story short this figure is just all around bad because it’s conflating energy efficiency with environmental friendliness.

Electric vehicles, despite being greener, are probably less efficient (which is why ICEs are mysteriously absent from this figure), it takes a lot more watts of power to move a 5000 pound car than it does a 2000 pound one). Similar story with biking - based on my Garmin figures, biking is about 22x more energy efficient than driving an ICE car, but the carbon footprint of that energy source is much higher watt-for-watt, so if you eat a meat heavy diet, the bike is barely greener than driving (caveat: I didn’t amortize the footprint of constructing the car, which is a probably a huge deal - if cycling is actually an option for you, your mileage probably isn’t that high).

Granted - you are spot on with oats, if you pick a greener crop like corn you are down to 0.5kg carbon per 1L of gasoline equivalent - as the guy below wrote, biking is a “greener choice” if you are vegan (3-6x less carbon footprint), but at the end of the day, manual transportation is a thing people choose for health or pleasure reasons, or when the distance is so low that other methods don’t make sense. if you are going to try and shame people into doing it out of a sense of environmental responsibility, you shouldn’t need to use dubious math to accomplish that end

that’s one burger, you would need at least a dozen burgers (14.2 big macs) to match a liter of gasoline (8340 kcal)

You burn calories when you exercise

My 30km round trip bike to work burns about ~800 calories, or 1.33 big-mac equivalents, which has a carbon footprint of about 4.2kg CO2

That same round trip would burn 2L gasoline in my car, which has a carbon footprint of about 4.6kg CO2

Energy efficiency and carbon footprint are very different things - pretty sure the carbon footprint of 15 big macs (8500kcal) is substantially greater than 1L of gasoline (let alone an electric grid equivalent)

Python 3.12’s compiler tells you to fuck off

OSError: File or directory not found “C:WindowsSystem32”

To be fair, your arguments basically boil down to “show me equivalent Linux support for Microsoft products”

You could make all the same arguments and conclude Macs are less suitable for doing work than windows, yet there are tons of professionals using MacBooks who get by just fine. If you don’t need to be fully ingrained in the Microsoft ecosystem you don’t NEED to be on windows.