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.
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
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.
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.
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.
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.
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.
Surely that's what lots of non-developer white collar workers use Excel for? I imagine there's orders of magnitude more people using Excel for data processing rather than Python or R. I'm well aware it's not the best tool for the job, but yet people are using it for purposes such as that. I wanted to learn more about that experience.
What do you mean by this? What am I "recording" as the bottom of the data set?
My point was that it is very hard to have a dynamic number of rows feed a proportionate dynamic number of rows. Scripting makes it much simpler, but at least with Google Sheet's scripting, the API seemed pretty lacking for that processing (in the very least, it's very slow, since it's running as a very constrained shared resource).
That's exactly what I did. Now separate out some columns and perform some additional transformation on that FILTERed data. Can you do it without repeating yourself (duplicating the FILTER statement, or any of the other transformations you need to do, besides just filling down a column). Can you perform these transformations only on the row height of the data, and not have extra rows with broken formulas?
I honestly wouldn't even be surprised if the functionality to do the above does exist, but for all of my searching I couldn't find it.
Your aside is exactly why I wanted to use a spreadsheet. It's the only tool that has that market penetration for non-programmers, and I wanted to see what made it tick. It seems like that may have backfired by not using Excel, however.
I certainly get that, but I'm primarily pointing out that as a non-layman from the software side, it doesn't seem like a particularly amazing tool. It certainly could be the case that it's extremely good for non-programmers, I was simply pointing out that I naively think it's not very well designed for those usecases.
I recently sat down and built something more complicated than simple accounting in a spreadsheet. It's what I considered to be a pretty typical usecase for a non-math related sheet; taking in several tables of data and selectively joining them. You enter an ID, press a button, and it finds all of the data related to that ID and presents it to you.
I was horrified to find that even with the supporting scripting capabilities, the entire paradigm revolves around knowing the shape of your data in advance. (I was using Google Sheets, but I don't think Excel would have been much different). For example, it is very non-intuitive to write a formula that retrieves all the rows in another sheet that match this rule, and once you do that, 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.
I realize most people don't have the luxury or skills, but I quickly realized that I could spin up a whole CRUD webapp for this problem faster than I, someone who understands indexing and windowing and such, could build it in a spreadsheet.
After this experience, I can't help but wonder if Excel and spreadsheets largely exist due to pre-existing knowledge about how to use them, or if this is _actually_ the best way for non-programming minded people to solve these problems.
What are you doing at this time (not meant as judgement or pressure)? I'm at a year (intentionally) unemployed, and I'm still not at the point where I feel like I can make meaningful progress on the projects I want to work on.
I can't really foresee a way that will get me going again, and I don't know that I really want to. I feel ashamed that my wife is now working, for less pay and objectively harder, when I could be making twice as much.
This is essentially me, though I'm not day trading and I'm not sure how much better I feel since quitting. I am young, but I spent all of my time up until a year ago doing the best I could to understand what makes good products and how to write great software. This has made me a de facto leader in any team I've joined, including straight out of college. Now I have the work experience to be "senior" (whatever that means), but I've never had the mentorship or fact checking that I think reaching such a position requires.
I still don't feel ready to find a job, but I have no idea how I will ever hold one. Leading is so wearing, and I'm already in such a delicate mental state.
I hope you find where you want to be. For me, I think I _need_ to be where I feel I'm bringing some positive benefit to the world, and I hope that at some point I can find a way to both build good OSS and make some money doing it.
While the overloading is annoying, database normalization actually has a strict definition that is not unlike the standard mathematical use; that is, to imply consistency (to make normal): https://en.wikipedia.org/wiki/Database_normalization
I would also point out that normalization within mathematics does not have a single concrete definition either, and it depends on your domain and desired property to stabilize: https://en.wikipedia.org/wiki/Normalization_(statistics)
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.