• 0 Posts
  • 20 Comments
Joined 2 years ago
cake
Cake day: August 6th, 2023

help-circle

  • It just does more and more easily. It styles things better, makes them more professional looking with a click. It can do certain things like nested tables in Word that Writer cannot do. Excel is much more powerful than calc, it has more functions, more refined functions, it’s easier to work with, has more and prettier chart options. And oh you can create tables in Excel that are sortable. There are many other cases.

    Now for the last two the die-hards will whine and whinge about how you should just use a software for creating charts and a database but sometimes you just want to make something quick, sometimes that’s overkill for what you need. Grandpa doesn’t need to learn how to deal with databases just to make a sortable list of books he’s read, he can just use excel and the Libreoffice people telling him to pound sand because they won’t add that feature to calc because it doesn’t belong there means he and many other people don’t use calc, they use MS office. Likewise the Libreoffice defense force saying of making graphs and charts to just use dedicated software, well many corporate types, business people, white collar workers don’t understand those things and may not be able to get them installed, what they understand, what they already have is MS office and it works and has lots of pretty, professional, very slick options which don’t make them look poorly in office meeting presentations.

    Just on the sortable tables front, I can’t tell you how many times I’ve run into hobby stuff that’s based on an excel file with tables that rely on being sortable. From stat sheet creators to mini-databases (<2000 rows) on some game created by fans.

    It’s useful for those who need the very bare basics of being able to open and read basic MS word documents, csv files, excel files, and to write an occasional letter. But the moment you need to start doing beyond basic formatting or dealing with files that have that, you run into issues.

    You have this gulf of usability, it’s useful for people at the very bottom of the basic needs pole, barely computer literate types who think facebook is the internet and it’s useful for highly technically competent people who can and do use other dedicated software, often without GUIs to solve problems, it’s a frustration for the middle 60% of the population who are more than basically computer literate but not scientifically trained, not CS or IT.


  • If by mainstream channels you mean major streaming services then there is no perfectly private option. But I would recommend an AppleTV as the closest thing (it also doesn’t have ads which I really appreciate).

    Other than that your options are devices that can’t access major streaming services at greater than 720p and are hackily put together on multiple levels but are fine for streaming local media you host yourself or more expensive than ATV devices and modding them with alternative launchers.



  • A dictator would never offer to step down.

    Not good logic regardless of whether you think Zelensky is or is not a dictator. A dictator might if the terms he demanded for it were those that both parties of the conflict had already ruled out.

    Making an impossible ask is hardly a sign of being reasonable or truly willing to do a thing. If I tell you I’ll give you ten million dollars but only if you can settle the mess in Palestine with the the “israeli” state and the Palestinian people permanently I’m not seriously offering you ten million dollars, my ask is impossible. No one would say it’s a good faith offer on my part.

    Trump’s team has acknowledged NATO is not viable and doesn’t even want to commit US troops in the event of a ceasefire (something Russia refuses anyways), preferring it be a Europe problem and Russia categorically will not accept Ukraine in NATO. This is a FACT.

    This conflict started over eastward NATO expansion, one of the primary, if not the most primary goals of Russia in their fight is to stop Ukraine from becoming part of NATO and stationing western weapons/troops there near them.

    Russia is winning and the support of the US is waning. They are not going to accept having spent all that treasure and blood and taken all these sanctions and in the end not get their primary goal just to get Zelensky to step down for another person who hates Russia.


  • I doubt they would be allowed to hand out keys (which they do not hold) to another government that would compromise American businesses, agencies, etc.

    Um, yes they would. The very point of eyes agreements is they allow countries intelligence agencies which aren’t allowed to spy on their own people to spy on each other’s people then pass each other the data. Snowden revealed this all a decade ago.

    The CIA and FBI do not store classified sensitive info on iPhones that are backed up anywhere. At least not anything that would come as a surprise to the British or be a risk. Nothing they wouldn’t have access to via the existing intelligence sharing.

    The UK and the US are thick as thieves and have been since the end of WW2.



  • This is frightening.

    They do not have the ability to just remove e2e back-ups in the UK alone and walk away from this, that’s not how the law is written as I understand it.

    The snooper’s charter gives the UK government the RIGHT to DEMAND access to encryption keys of any user GLOBALLY. The law is that they can force the cooperation of Apple to decrypt the account of an American user, of a German user, of a Russian user, of a South African user, of a Brazilian user, of a Japanese user who have never stepped foot in the UK.

    So they’re claiming that this protects their users, that they haven’t complied but the only way to avoid complying with these secret gag orders for compromising encryption GLOBALLY at the demand of the UK government is to remove themselves entirely from the jurisdiction of the UK. Is to remove all executives and technical personnel from UK soil, to not hire such people who live in or are citizens of the UK as technical personnel as they could be gag ordered and compelled to cooperate. To basically entirely pull out of any presence but maybe storefronts in the UK and take steps to prevent the arrest and pressuring of their executives and key technical people with access from being subject to UK coercion.

    That they haven’t done that means all users globally are still at risk. This may be a big PR stunt to convince people they haven’t caved when in fact they have in secret and will hand over data of global users to the UK which shares it via eyes agreements with the US, with France, Australia, etc. This has the added benefit of allowing the UK to keep such access secret by acting annoyed with Apple but not actually pressing any case. If they try and actually prosecute or pressure Apple that’s a sign that they haven’t cooperated globally, if they only offer angry words to the press IMO that’s a sign that in secret they’ve given access globally and only informed UK users that their cloud data isn’t protected.




  • i haven’t yet encountered an AP that is capable of providing all of the features that i currently use. ie ad blocking; personal vpn;

    Pfsense does both of these. pfblocker NG in particular is a very powerful network adblocker with lots of lists. Pfsense can also run VPNs, it supports openvpn and wireguard in both client and server mode and you can set up multiple so one client, one server.

    web hosting; and cloud-like internet accessible storage via ssh tunnel (in addition to others).

    If you just need personal services it would be best to run something local, setup a wireguard tunnel on pfsense that gives access to your network and VPN in to access things remotely. If you need to share with others I suppose this can become a problem.



  • The thing is. Alcohol can be used in for example cooking. Cigarettes have no good purpose, nothing you can really do with them that has utility outside of direct consumption that exposes you to the full health risks.

    And at that point I fear you’re also diminishing the unique harm and danger of cigarettes which produce second hand smoke which exposes others, including kids to health dangers without their consent.

    How about we slay the first demon here before starting to equate another lesser one with it? Most people do not have a risk of getting addicted to alcohol, nearly everyone has a risk with a few tries of getting addicted to nicotine and it’s spreading like a plague among children with candy and sweets flavored cartridges for the poison that is e-cigs. This undoing a generation of progress.

    It really does risk making more people dismissing the unique dangers and threat of nicotine and smoke products by equating the two and risks creating a DARE moment where the whole thing is just mocked by rising anti-science, anti-expert sentiment spurred on by capitalists eager to undo regulations. I mean things like this are catnip to people like RFK who want to torpedo evidence based science in favor of vibes and snake oil because it presents an in with your average person to criticize the health establishment over at least misplaced priorities.

    Drinking on its own is a danger to the drinker. Only when done to excess does it endanger others. Smoking at all produces second-hand smoke and can encourage others to join an addictive behavior that is very, very hard to quit and will be a monkey on their back for years, decades after they stop whereas MOST humans can stop drinking alcohol with less ill effects than stopping daily consumption of caffeine.

    Any amount of alcohol is a carcinogen and unhealthy, but at the same time we have to ask what level of risk is okay. Any amount of charred food cooked on charcoal is also a health risk for instance and can lead to exposure to carcinogens. The unique problems of cigarettes and nicotine were always impacts to others who didn’t make that choice including children trapped with smoker parents as well as the addictive properties which left most users trapped or facing a hard fight to stop as well as bad behaviors by industry to hook people while they were young and down. Yes the alcohol industry also tries to get teens and young people to drink but nearly all of them can just stop after they leave college and go on to have a healthy life with zero or limited interactions with alcohol, you cannot say the same for someone who starts using nicotine and uses it heavily for even 6 months.



  • As an extra step you can block DNS requests to external services from within your network to prevent devices trying to reach hardcoded for example Google DNS servers to bypass your filtering which isn’t uncommon with some IoT/streaming devices. Best to both block the known IPs as well as have DNS redirects for the urls that point back to your firewall at whatever IP it’s using to serve DNS from. There is a list called DoH servers by name or something like that which you can add to the blocklist to try and prevent usage of any DNS but your own.


  • Yeah they include a gigabit ethernet port which is really useful for full quality 4k, amazing how many cheaper streaming devices only have 10/100 ports which I suppose is adequate if all you do is stream Netflix.

    But to me it’s just cheaping out to save a dollar or two on the manufacturer’s part that with ethernet & protocol overhead could result in problems potentially even for 1080p streams. Whereas gigabit even with overhead and lackluster conditions you’re going to get 700-800mbps sustained. People think for 1080p bluray dumps for instance that oh bitrates are only around 40-50mbps average but if you fast forward, if you’re seeking around the actual bitrate being consumed jumps to double or more at times and that 100mbps port will choke on that and buffer whereas the gigabit will not flinch. And though I don’t use the playback speed option myself much Infuse does allow playing back at 1.5 and 2x speeds which consume around 1.5x and 2x the bitrate respectively.

    But it’s just nice to not have to deal with wireless hiccups too.


  • Putting this here as another comment so as to not get too lengthy in my original reply:

    The only other things I can recommend in the streaming space would be Dune-HD’s products which are more expensive than Apple TV (though not more than Nvidia shield pro) and are not quite as simple and easy to use but do offer customization and a nice virtualized linux+androidtv system on some of their models AND maybe the Nvidia Shield Pro with caveats. But I have a bit of a bone to pick with the Shield for a number of reasons:

    1. Price. They haven’t updated the hardware in 5 years and have changed it from a premium product without ads to standard AndroidTV with ads on the homescreen yet charge the same $200 price, meanwhile Apple dropped the price on their AppleTV and is eating their lunch with annual hardware updates and regular software updates that bring new functionality
    2. Features. The shield still has bugs around things like framerate switching while AppleTV does not nor does Dune-HD’s products
    3. The lack of updates, the move from a premium android experience without homescreen ads to one with ads. I feel it could be killed off any moment, they’re just lazily milking the product which is probably the only reason they haven’t. You /can/ with some effort alter the launcher to a 3rd party launcher to lose the ads but it’s not easy, it usually requires revisiting and you can do the same thing with the Dune-HD products and they care a lot more and offer a lot more IMO.

    The only reason you might really prefer Dune-HD over an Apple TV is the ability to side-load a modded youtube app if you use that a ton but even that feels up in the air with how hard Google is going in their war on anyone using things like that and how successful they’ve been against it. You can’t block ads in ad-supported major streaming services (Netflix, Max, Hulu, Disney+, etc), neither with pihole nor any other way I’m aware of.



  • Majestic@lemmy.mltoPrivacy@lemmy.mlApple TV Privacy over Roku?
    link
    fedilink
    arrow-up
    14
    arrow-down
    3
    ·
    edit-2
    1 month ago

    Yes. An Apple TV will be about as private as you can get for something that supports mainstream streaming apps (running a mini-pc won’t allow better than 720p quality and you’ll struggle to get remotes to work, it’ll be a clunky experience via web browsers often). It will be a lot better than a smart TV, especially a Roku who are among the worst.

    If you want a bit more privacy consider running a pihole and redirecting DNS traffic at your firewall to your pihole or blocking all DNS traffic not from your pihole. I run a firewall solution that includes DNS redirection and blocking and there are a lot of measurement endpoints for streaming apps that you can block without the app breaking so that’s another little ounce. This doesn’t require a ton more effort though it is more effort it can be a set and forget type of thing. Importantly this does not block in-app ads.

    For me the fact they don’t have any ads is what sells me on it. I don’t want ads on my homescreen. I don’t even want them in the apps but getting that peace and lack of clutter on the homescreen is so nice.

    Apple TVs are also just so smooth. Smart TV’s feel sluggish and pathetic compared to how well everything just works on a device that’s properly powered for the task and not constantly sucking up all your data.

    Apple TVs also have a lot of Apple privacy settings though obviously some of them apps may not allow like many streaming apps require a location check at least intermittently for licensing reasons to prove you’re still in the country but you can limit it as much as possible.

    If you have a decent wifi network and you know you’re not going to be streaming say homemade BluRay rips the wifi entry model is excellent (currently it supports wifi 6 and has a really good wifi chip). I personally run Plex and a media server so I choose the wifi+ethernet model to have the reliability of ethernet and don’t regret it but it’s understandable if your situation precludes being able to use a wired connection or you want to save the $20 extra they charge.


  • Why not HEVC 10bit? We’re quickly approaching the age of AV1 and HEVC has been on the scene for a decade now so might as well have a relatively recent codec and HEVC offers improvements of 20% bitrate reduction for same quality even for 480p content vs 264. Modern devices don’t have any issues decoding it either even in software and open source encoders are mature enough. AV1 might be an even better bet but encoding time takes a really noticeable hit compared to HEVC and client device support still isn’t entirely there, the encoders are also still a little more finicky than HEVC.

    As to ripping DVDs to EAC3, I wouldn’t.

    Almost all DVDs are natively AC3 regular dolby digital. You can’t add more quality by doing lossy conversions and the bitrates typically present for DVDs are low enough that doing a conversion to lower the bitrate doesn’t really make sense. We’re talking 512-640kbps for 5.1 audio (and 192 to 240 for stereo) which isn’t unreasonable and the damage incurred in conversion to save say half that IMO just doesn’t make sense with modern storage prices and the amount of storage being used for 480p content. You can easily save as much without damaging the audio by choosing HEVC10 as your video encoder. If you insist on doing a conversion for DVD audio I would suggest doing so to either AAC if you have a good encoder and know how to use it or Opus but I wouldn’t recommend it (all TVs pretty much natively play/decode AC3 audio so given you’re not saving that many bits you’re just inducing degradation of conversion from AC3 to AAC/Opus and again back to AC3 for playback).

    Now for BluRays I fully agree converting from those massive 2000-4000kbps DTS-HD MA, TrueHD, PCM audio streams to EAC3 at 640kbps for multi-channel audio can save a fair amount of space at scale and doesn’t incur meaningful audio degradation (while offering equivalent quality to 1000kbps AC3).