What the user was doing is that they don’t trust that the system truly deleted the account, and they worry it was just deactivated (while claiming it was “deleted”). So they tried to do a password recovery which often reactivates a falsely “deleted” account.
I’ve done this before and had to message the company and have them confirm the account is entirely deleted.
It’s not a movie. It’s prophecy.
Using Relational DBs where the data model is better suited to other sorts of DBs.
This is true if most or all of your data is such. But when you have only a few bits of data here and there, it’s still better to use the RDB.
For example, in a surveillance system (think Blue Iris, Zone Minder, or Shinobi) you want to use an RDB, but you’re going to have to store JSON data from alerts as well as other objects within the frame when alerts come in. Something like this:
{
"detection":{
"object":"person",
"time":"2024-07-29 11:12:50.123",
"camera":"LemmyCam",
"coords": {
"x":"23",
"y":"100",
"w":"50",
"h":"75"
}
}
},
"other_ojects":{
<repeat above format multipl times>
}
}
While it’s possible to store this in a flat format in a table. The question is why would you want to. Postgres’ JSONB datatype will store the data as efficiently as anything else, while also making it queryable. This gives you the advantage of not having to rework the the table structure if you need to expand the type of data points used in the detection software.
It definitely isn’t a solution for most things, but it’s 100% valid to use.
There’s also the consideration that you just want to store JSON data as it’s generated by whatever source without translating it in any way. Just store the actual data in it’s “raw” form. This allows you to do that also.
Edit: just to add to the example JSON, the other advantage is that it allows a variable number of objects within the array without having to accommodate it in the table. I can’t count how many times I’ve seen tables with “extra1, extra2, extra3, extra4, …” because they knew there would be extra data at some point, but no idea what it would be.
JSON data within a database is perfectly fine and has completely justified use cases. JSON is just a way to structure data. If it’s bespoke data or something that doesn’t need to be structured in a table, a JSON string can keep all that organized.
We use it for intake questionnaire data. It’s something that needs to be on file for record purposes, but it doesn’t need to be queried aside from simply being loaded with the rest of the record.
Edit: and just to add, even MS SQL/Azure SQL has the ability to both query and even index within a JSON object. Of course Postgres’ JSONB data type is far better suited for that.
The distro part is actually kinda easy. In my mind there’s only a few distros that should ever be considered by a new user. Fedora, or Ubuntu/Mint/Pop!_OS. The last three are effectively the same thing under the hood and all of them will do the job.
The real hard question is which desktop environment. Plasma is generally my go to suggestion. I feel it follows a tried and true paradigm for UI and UX. It’s incredibly polished, fast, and very full featured. The one that really sticks out as odd to me is gnome and is the one that I would never recommend. I wouldn’t discourage, just not recommend.
You forgot that you also need to create a new 32bit word entry with the value of the amount of system RAM in gigabytes times 2 divided by the square root of your age times 10.
Otherwise BSODWord won’t be picked up.
Edit: also you need to redo that every time your system updates because Windows update will reset all those values
However, now and I run across a windows issue. It’s a nightmare. I can put hours of work into trying to fix a driver issue or an issue with updates and get nowhere. Then go to reinstall the operating system and have to spend more hours just to get it installed.
Now in Linux, not only do I rarely have issues but also fixing those issues are pretty straightforward. And if I can’t fix it a reinstall takes minutes and I’m back up and running in no time.
THANK YOU. I’m sick of this rhetoric about Linux being hard and user-unfriendly because of the command-line.
Windows is such a pain to use for a while now. You need a ton of post install scripts and hacks to make it even remotely usable and when something goes wrong good luck figuring out what. The event viewer is usually just a bunch of vague COM errors with an ID. Then when you look up that ID it’s barely more useful than “something went wrong”.
But you can do nearly everything with the GUI in Linux for a while now. The level of stuff you would need to use the terminal for is the same level on Windows you would need the command-line for, or (SHUDDER) the registry.
In fact, I would argue that doing things in Linux via the GUI is easier than even on Windows. I’m speaking as a user of KDE Plasma. I personally dislike Gnome.
Needing to use command line for some things that should be a right click, not supporting right click
You can do nearly everything you need to via the GUI on the major distros (the ones that most people would use). There’s plenty of things on Windows you must use the command-line for.
And anytime you need to use the Run dialogue it’s the same argument. It’s the same “issue” of having to type instead of using your mouse.
And if you don’t need to use the command-line on Windows, it’s the registry. The awful, terrible, horrible, disgusting registry.
I’m not actually sure what on earth you mean with “not supporting right click”. Maybe you’re thinking of older Mac versions?
it’s just not a great general purpose desktop for the average user,
It has been for a while now.
My /home partition is the same one I setup almost 12 years ago. It’s been through multiple versions of Ubuntu, multiple Ubuntu reinstalls, a switch over to EndeavourOS, a reinstall of EndeavourOS, cloned to multiple drives as each one failed or was upgraded to a larger sized drive. But it’s the same exact /home data.
Fifteen years ago, you couldn’t run anything other than shitty FOSS games or the occasional Platinum AppDB rated game like World of Warcraft on Linux, and even for the latter the install instructions were convoluted.
Hey! I was playing LOTRO just fine on Linux back then. It actually worked better on Linux than Windows back then too.
Before there were scripted alternatives large scale Windows deployments were all imaged because of the hours it took to set up a single machine swapping floppies and writing to spinning rust.
With Windows 7 I was making golden images to simplify deployments.
Even now for the one Windows 10 VM I need for a very specific thing, I couldn’t use it without installing AtlasOS (an extensive powershell script to cut out as much of the bloat as possible). Otherwise the system would consistently slow down and stop responding. It was basically unusable (it’s running on Proxmox on a considerably old server).
Recently I decided I no longer wanted LUKS encryption on my laptop because I don’t travel anymore. So I followed the steps to do an in-place drive decryption. It worked, but I had missed a step to update the bootloader. So I fired up a live distro, chrooted to the installed system and 2 minutes later I had a working system.
None of these require your account to “exist”. There could simply be an acknowledgement stating those reasons with “after X days the data will be deleted, and xyz will be archived for legal reasons”.
This is the only valid reason. But even then this could be stated so that the user is fully aware. Then an email one week and another one day before deletion as a reminder, and a final confirmation after the fact. I’ve used services before that do this. It’s done well and appreciated.
This pseudo-deletion shadow account stuff is annoying.