• 3 Posts
  • 156 Comments
Joined 2 years ago
cake
Cake day: June 12th, 2023

help-circle


  • Ugh I hate excel. It can’t do the most basic things like search and replace things reliably in all cases. I have moved literally all data analysis besides the absolute basic “count” and “sum” operations to python in spyder. 200x faster, repeatable, won’t freeze up with large datssetd, and has never once failed a basic operation like a search and replace. Not to mention the localization issues and the fact that it will fuck things up completely if you install a new printer because Microsoft decided the printer has priority of your document and spreadsheet layouts over choosing a default.

    I had some evaluation board software that whenever the value dipped below -1, would place the comma completely randomly in the floating point number.

    Excel almost had a heart attack when I asked it to search and replace ”-1” with “-1,” and it found all of the cases just fine, but decides to ignore the replace and not place a comma at all. If I tried to convert them to a number, it freaked out and placed the decimal place also randomly, different than the input. And of course trying to do in-place operations on a column for export is just painful.

    Hell, in notepad++ I could just regex the digit range that was preceded by a ”-1” and get everything replaced using a few brackets.

    Not to mention how terrible the graphs work in comparison and how bad they look with the default options 😅. But hey, you can automatically put in a drop shadow or frame it in a useless way.

    There are some people who can work very efficiently and do some crazy things in excel (like the excel doom) but unless you have literally been using it daily for many years and actively looking for ways to speed up, then it is just as easy or easier to do things in an actual data processing program like matlab, octave, python, or R (And I am not a coder) and you can literally copy paste a file name for the next full dataset.



  • This is absolutely so true. All of the “hunting” survivalists don’t realize that you would essentially have 1000 people hunting every 1 deer if you live in the suburbs and not that much better rurally. This isn’t 1800 anymore.

    The best thing you can do is have enough land to farm, learn how to farm, and stock the hell up on base ingredients (wheat, rice, dry beans, lentils) and stock up on as many seeds as you know how to grow. Even then; one bad harvest and you starve.

    But seriously, I can’t stress dry beans and lentils enough. They last forever, they can be sprouted and replanted, and they have many many times more protein than corn or rice which is very important when you go vegan.

    Also getting ducks will give eggs for additional protein and B12 vitamins that you would miss out on otherwise.


  • Dropping instead of blocking might technically be better because it wastes a bit more bot time and they see it as “it doesn’t exist” rather than an obsticle to try exploits on. Not sure if that is true though.

    For me:

    • ssh server only with keys

    • absolutely no ssh forwarding, only available to local network via firewall rules

    • docker socket proxy for everything that needs socket access

    • drop non-used ports, limit IPs for local-only services (e.g. paperless)

    • crowdsec on traefik for the rest (sadly it blocks my VPN IPs also)

    • Authelia over everything that doesn’t break the native apps (jellyfin and home assistant are the two that it breaks so far, and HA was very intermittent so I made a separate authelia rule and mobile DNS entry for slightly reduced rules)

    • proper umask rules on all docker directories (or as much as possible)

    • main drive FDE with a separate boot drive with FDE keyfile on a dongle that is removed except for updates and booting to make snatch-and-grabs useless and compromising bootloader impractical

    • full disk encryption with passworded data drives, so even if a smash and grab happens when I leave the dongle in, the sensitive data is still encrypted and the keys aren’t in memory (makes a startup script with a password needed, so no automated startups for me)

    For more info, I followed a lot of stuff on: https://github.com/imthenachoman/How-To-Secure-A-Linux-Server









  • The only thing about jellyfin is the damn subtitles. Subtitle sync is horrible. They added a subtitle offset feature last year which was a good workaround and then removed it a few months ago on androidtv and android. Now the subtitle offset on the web player doesn’t do anything anymore either

    Even Subgen generated subtitles, which are pretty perfectly in sync in reality, are sometimes played back at an incorrect speed so it will progressively get more and more out of sync, but there is no way to tell what speed the subtitles are being played at.

    Also it just ignores themes a lot of times or only displays themes on the admin console and nowhere else.

    That said, jellyfin is still amazing!


  • You are really missing out

    impossible to join

    Lol yeah many of us know we are missing out but can’t join any decent private trackers because they are impossible to join. The one small one I was able to join has so few users that maintaining a good ratio is literally impossible because not enough people download anything but brand-new media. Luckily they give points for keeping things alive that can be traded for ratio.

    I think without the points I would have like a 0.05 ratio or something dumb while I am 24/7 seeding over 300 files. On public trackers I have 3.1TB down, 20.7TB up seeding ~600.


  • Crazy enough, I have everything going that I want to on my server!

    • *arr suite and jellyfin
    • traefik reverse proxy with crowdsec + bouncer for some sites (e.g. not documents or media)
    • paperless-ngx for documents
    • immich for photos
    • leantime to manage personal projects
    • Book stack for a personal wiki
    • calibre-web for my library
    • syncthing for file and music syncing so I don’t have to stream music
    • valheim server for me and my friends
    • boinc for turning my server to a productive heater in the winter
    • home assistant for my in-renovation smart home

    As far as my server goes, I have everything I need. Maybe setting up something for sharing files over the web if needed. I used nextcloud for that before it killed itself completely and I realized I never really needed it.

    Next is working on my smart home because we had to fully strip the house to renovate. KNX first, zwave for things that KNX doesn’t have or are crazy expensive, ESPHome for everything that the other two can’t accomplish. Minimal 2.4GHz interference and don’t have to rely as much as possible on flaky wireless in a brick house.



  • It really really depends on what you have for heating.

    Floor heating + heat pump? You don’t need to mess around with target temp much because the principle behind it is thermal mass buildup and maintaining that. You have to tune thermostatic valves on the room level. Then you can have one central thermostat simply slightly change the target temperature with many hours of delay. That doesn’t seem too useful to me to automate.

    Do you have radiators? Then you can get zwave or ZigBee valves and tie them together with whatever thermostat that you want in home assistant. Then you can set per room/zone heat depending on whatever sensors you have.

    Do you have central forced air heating and air conditioning? Then you have pretty much target temp and on/off control unless you want to put in motorized automatic registers or redesign your entire duct system for per-room duct valves.

    Individual heat pumps/airco units with radiator based heating is the most “per room” customizable and probably the most useful to put automations on in Home Assistant.

    Ventilation can be useful by monitoring CO2 levels and humidity. Then you can use either the fan units themselves or socket switches to actuate those and put whatever sensors you want wherever it is useful.

    I am probably missing some stuff here, but there are only a few HVAC setups that actually benefit from automation, in my opinion. Mainly ventilation, infrared, and non centralized forced air heat pumps. Plus heating and cooling is something you want to work 100% flawlessly even if your router dies, your home assistant falls off a cliff, and your ZigBee/zwave controller dies.