adepressedthrow (u/adepressedthrow)

adepressedthrow commented on MacBooks from 2020 Are Being Sold for Scrap Because of Activation Lock vice.com/en/article/xgybq... · Posted by u/ColPanic

adepressedthrow · 3 years ago

I'm stuck with several relatively new (2015, HD, run tvOS 16) Apple TVs that came from a government auction. They were used in a school, and were never removed from "Apple School Manager", their MDM system for schools. Apparently Apple can mark serials as part of a school or business's fleet, and upon setting up the device, it automatically is registered and pulls down the MDM profiles.

Only the school can remove them from the system, and although Apple's terms of service _require_ them to be in control of the device for it to be registered (i.e. not sold to a third party, me), I have been completely unable to convince the school to help me on the matter. Contacting Apple doesn't seem like much of an option either, as they don't even publicly post contact info for this kind of support.

adepressedthrow commented on Ask HN: Those making $500+/month on side projects in 2023 – Show and tell · Posted by u/mbrain

trungdq88 · 3 years ago

I built a screenshot app for macOS and made ~$3k/mo from it :) https://xnapper.com

People like the app for its ability to turn a normal boring screenshot into a beautiful one that they can share on social media instantly.

adepressedthrow · 3 years ago

You might want to play around with the encoding on your videos. On a Windows machine with a i7-8770k (and dedicated GPU) with Firefox latest, the page was spiking up to 100% GPU usage, causing the browsing experience to slow to a crawl. It may be related due to me having a Twitch stream up on a second display.

Probably a Firefox bug, but it's preventing me from looking at this landing page that every one else seems to like :P

adepressedthrow commented on Managing tape drives and libraries with the Unix/Linux CLI blogs.intellique.com/cgi-... · Posted by u/wazoox

trynewideas · 3 years ago

> free, automated software for managing the system and performing tasks such as backups

Did you come across Amanda[1] or bacula + bacularis[2]?

1: http://www.amanda.org/

2: https://bacularis.app/doc/index.html

adepressedthrow · 3 years ago

I hadn't seen Amanda before. Bacularis looks like it might help with the complexity of setting up Backula. I might try that out.

It's hard to get the motivation to mess with these tools that have relatively little documentation/examples and are purely config file based.

adepressedthrow commented on Managing tape drives and libraries with the Unix/Linux CLI blogs.intellique.com/cgi-... · Posted by u/wazoox

adepressedthrow · 3 years ago

I was able to purchase a LTO-7 library full of tapes a few years ago for basically nothing, and still haven't gotten around to using it. There seems to be very little in terms of free, automated software for managing the system and performing tasks such as backups. tar doesn't exactly cut it for hands-off usage.

The best I've found is using Veeam Backup & Replication, but it's Windows only and not great still.

adepressedthrow commented on Ask HN: How to Stop Caring (Professionally)? · Posted by u/tropicalfruit

adepressedthrow · 3 years ago

This is a huge thing for me too. I got super burnt out because I care too much.

I hope you get better. I'm still struggling with it, a year after stopping work.

adepressedthrow commented on Analysis of Apple Watch running data applewatchrunner.substack... · Posted by u/maarten3

m1gu3l · 3 years ago

Sleep tracking always seemed like nonsense to me. You either know you are getting restful sleep or know you are not, and if you are not time is probably better spent taking a proactive approach to establishing healthier lifestyle habits that will lead to more restful sleep. How much is it worth really, to wake up and know exactly how much time you were tossing around not getting rest? I’d imagine you would feel it, statistics or not.

adepressedthrow · 3 years ago

It's very useful information when you are never rested and constantly are trying to tweak variables to observe the impacts to your sleep. I've long since stopped relying on trackers, however, as nothing seemed to display any accuracy whatsoever. I manually record my perception of sleep every night.

adepressedthrow commented on Faster, Meaner, Deadlier: The Evolution of “BattleBots” spectrum.ieee.org/battleb... · Posted by u/pseudolus

mikewarot · 3 years ago

What the world needs is the opposite... battle-bots built out of Lego pieces (with no glue or other means of keeping them attached). This single constraint could lower the barriers to entry, and make it fun for everyone.

adepressedthrow · 3 years ago

This is commonly done at Lego conventions, though usually not too many people participate.

adepressedthrow commented on Offline-First Apps: Why Should Apps Be Made to Work in an Offline State? dewsolutions.in/offline-f... · Posted by u/8bitsrule

adepressedthrow · 3 years ago

It seems that there are few options overall, but particularly few OSS options for doing offline storage and sync in native code (_without_ using JavaScript). The only thing I've encountered that really met those requirements (OSS, non-JS) was Couchbase, but it's really not a great experience, and requires complicated setup both for the binary and the server. Adding P2P or CRDT features is even more difficulty.

adepressedthrow commented on Did we all believe a myth about depression? bbc.co.uk/news/health-622... · Posted by u/pmoriarty

UI_at_80x24 · 3 years ago

I have been diagnosed with Major Depressive Disorder.

I have been struggling with depression for 35+ years.

I have attempted to kill myself. [Yes I failed at that too! =)]

I thought about (and planned) killing myself several times a day.

I have had 6+ Psychiatrists.

I have tried EVERY drug available.

Electric Shock Therapy was going to be next, but I have avoided it.

The best drugs only work for 6'ish months for me.

Then my doctor offered an experimental Ketamine treatment. I've had 3 rounds of treatment over the last 6 years. I didn't obsess about killing myself any longer. It's almost like I forgot to dwell on it.

I still have some bad days, but my bad days now are better then my best days used to be. So that's an improvement.

adepressedthrow · 3 years ago

I'm very happy you found something that works for you. What method of ketamine treatment have you been taking? I just stopped after 2 months of troches, which didn't seem to bring significant, if any, benefit.

Interestingly, I found myself abnormally susceptible to the psychedelic effects. When taking ketamine orally, the expectation is that most of the medicine is absorbed while you hold the troch in your mouth for 30+ minutes. After a lot of experimentation, I found that I barely absorb any medicine through my mouth, but once I swallow it I absorb it very rapidly. This made it difficult to control the delivery speed, and likely hindered my treatment.

I haven't been dealing with depression for anywhere near as long as you, but I do speak from experience about how terrible it is to not find anything that works. I've gone through ~13 of the most commonly prescribed drugs for depression, anxiety, and sleep, and none brought any relief. I've now tried and failed out of ketamine, which I was really hopeful for. Now I'm just back to sitting around trying to get _any_ doctor to actually see me and maybe get tested for various neurodivergent conditions.

adepressedthrow commented on Excel never dies (2021) notboring.co/p/excel-neve... · Posted by u/andriodsheep

_dain_ · 3 years ago

Can you give a more detailed description of what you were trying? I can't know for sure, but it sounds like Excel can easily handle what you've described, if you use it right.

>the entire paradigm revolves around knowing the shape of your data in advance.

How exactly do you program without knowing the shape of your data in advance? You need to know your database columns, or your JSON schema, etc.

>(I was using Google Sheets, but I don't think Excel would have been much different).

It would have been very different, because Excel has tables and Powerquery and Google Sheets doesn't.

>since it's a variable number of rows returned, it is difficult to then operate on that data without filling your formulas down for some indeterminate number of rows.

Were you using dynamic array formulae? They can handle the old problem of needing to fill down formulae to an arbitrary depth. Or again, tables.

Programmers routinely underestimate Excel. Unlike most Microsoft products, it has improved year on year over the past few decades. There are heaps of great power-user features they keep introducing. The skill ceiling is very high .. not as high as proper software engineering, but still damned high.

It also really annoys me when I see Linux/FOSS partisans tell Windows normies "oh you can do everything you can do in Excel in LibreOffice Calc" -- no you fucking well cannot. (And I use Linux on my personal computers full time).

adepressedthrow · 3 years ago

Your comment about FOSS is spot on. While I'm very aware that Google Sheets is not OSS, it felt much more amenable to me than Excel (and I'm sure Excel's online free version isn't particularly fantastic anyway, though it may be better than Sheets from what people are saying here).

> How exactly do you program without knowing the shape of your data in advance? You need to know your database columns, or your JSON schema, etc.

This was a bit overloaded in my opinion, as in spreadsheets world, "shape" includes the number of rows, hence my comments. I know that the column layout needs to be known.

> Were you using dynamic array formulae

I looked into it, but couldn't figure out how to handle them without introducing a massive amount of formula duplication. The best I could figure out how to do was to do a single large FILTER (which is dynamic array) and doing a fill down on my other transformation formulas from there. I blacked out the rows past the end of the FILTER using conditional formatting rules (which felt very stupid to do, but I couldn't find anything better).

> The skill ceiling is very high

I don't doubt you, but if you can't discover the functionality, it might as well not exist. Admittedly I was clearly using the inferior tool, but in my searching for solutions I much more readily found Google's documentation over Excel's.

I also realize I'm not in the position of being forced into a corner; as most of us on this forum could, I just wave my magic wand and write the software to solve my problems. I imagine those who don't have that ability available to them will do "crazier and crazier" things to figure out how to accomplish their work in Excel, and therefore will learn much better ways than I have in my little experience with it.

----

I was building a tool to track the completion of finding parts for a given Lego set. You enter the set ID, it pulls the parts list for that set (Rebrickable nicely offers their database as a set of CSVs https://rebrickable.com/downloads/) and formats it nicely for consumption.