KillingTimeItself
@KillingTimeItself@lemmy.dbzer0.com
- Comment on ‘The tyranny of apps’: those without smartphones are unfairly penalised, say campaigners 5 days ago:
i’m really not sure how the non tesla super charger experience looks, that concerns me. Though i assume that must be a somewhat solve problem, if people are using it so.
just use a web browser. I verified I can login through my web browser to manage my account, my products, my payment method. Not the car features though. I have no idea if this is new, but just use any web browser
that’s good, there should definitely be some available features for the card, but you can at least handle payment. Though i would still prefer not needing to provide my payment info to a third party anywhere except for time of transaction. Just opens me up to more bullshit.
- Comment on ‘The tyranny of apps’: those without smartphones are unfairly penalised, say campaigners 6 days ago:
i mean sure, but do i WANT to use it for that? No, i just want to fucking pay for my shit and leave. I don’t want your stupid little QR codes, i don’t want your silly little NFC, just accept card or fuck off.
Just because you can invent some schizophrenic use for a smartphone, doesn’t mean i have a use for it.
- Comment on ‘The tyranny of apps’: those without smartphones are unfairly penalised, say campaigners 6 days ago:
Bad example.
what are you going to do setup android emulation so you can install the tesla app (which might not work in emulation because that’s sus, but maybe they dont have good security anyway lmao) sure, you can set it up once, but like, what do you do if your credit card is cancelled, or the app suddenly stops accepting purchases because “you haven’t been online in a week” and it’s for “security purposes” or some other stupid shit like that. This is the entire reason card based payment exists lmao. Why are we just reinventing it.
i guess theoretically if it’s a webapp you could do it on the browser, but then like, how is it going to link information back to you personally? Unless you own a tesla, where you basically just save your payment info on the car directly at that point. Maybe they will invent credit card 2 electric boogaloo. Are they going to start installing NFC/RFID into charging ports for payment link info? Seems silly to me.
If you own a non tesla, this is as you mentioned, a huge issue, considering that NACS is the charging standard for all of north america now.
- Comment on Jellyfin is not just good... but *better* than Plex now?! 1 week ago:
both, probably.
- Comment on Jellyfin is not just good... but *better* than Plex now?! 1 week ago:
jellyfin is quite literally seamless in this regard, the only thing that wont work is metadata scraping (which if like me you run a yt archive, can be relatively frequent, but often isn’t even a huge problem) I only notice network outages when other shit breaks lmao.
- Comment on Jellyfin is not just good... but *better* than Plex now?! 1 week ago:
Hardware acceleration still kind of sucks. You can get it to work, but the Jellyfin port of ffmpeg doesn’t work anywhere near as well as Plex’s.
pretty much just works for me on intel QSV. as long as you have drivers and hardware support it seems perfectly fine. Maybe plex has a cleaner implementation? Not sure, never used it.
Public network support is finicky. This is hard to quantify, but I’ve been on several remote networks where my Jellyfin connection dropped in and out and Plex did not. I suspect this is due to the Plex Relay service making up for bad routes between my house and the network.
depending on your network configuration, and routing of the network, this is most likely to be plex relays, this wouldn’t be a jellyfin issue, it would be a plex feature. You could easily fix this with a relay VPN server or something like that. (you probably shouldn’t publicly expose services these days anyway.)
- Comment on Jellyfin is not just good... but *better* than Plex now?! 1 week ago:
i only wish jellyfin would add chapter titles and hover cards (maybe thats in the new thumbs now? I haven’t yet migrated because lazy lmao)
and that they fix the weird UI shenanigans from it’s emby days. Some QOL shit would be nice, auto sorting so that its not manually default to the stupidest setting ever. and the other usual shit.
I’m still having issues with my client freezing on playback of high bitrate video (like heavy 4K content) but transcoding down fixes that, im not sure what causes that, something gets caught up i guess, a refresh fixes it though.
- Comment on Jellyfin is not just good... but *better* than Plex now?! 1 week ago:
there’s finamp. and i think jellyfin is just running a sonic server? Not sure, but that’s basically what it is under the hood, so.
- Comment on ‘The tyranny of apps’: those without smartphones are unfairly penalised, say campaigners 1 week ago:
BRB pulling up to a QR code scanner with my 15 inch thinkpad w520 running on 92whr of battery consuming literal watts of power because it’s from 2012.
Hopefully i’m not an inconvenience.
- Comment on ‘The tyranny of apps’: those without smartphones are unfairly penalised, say campaigners 1 week ago:
I’d never do it, but we have one at work and he’s singlehandedly causing so much grief at work.
tell him the funny internet man that replied to you told him that he was based and that we collectively appreciate his efforts of basedness.
- Comment on ‘The tyranny of apps’: those without smartphones are unfairly penalised, say campaigners 1 week ago:
Society must revert their mentality and not expect constant immediate access to everything. Absolutely nothing happens on the internet for personal activity that can’t wait a few hours or the next day.
yeah ok so, counterpoint, you pull up to an EV charging station (it’s tesla because of course it’s tesla) please show me where the card reader is. I’ll wait.
- Comment on ‘The tyranny of apps’: those without smartphones are unfairly penalised, say campaigners 1 week ago:
THIS IS ACTUALLY SO REAL FUCKING SMARTPHONES I HATE STEVE JOBS FUCK YOU WHY DID YOU RUIN TECHNOLOGY.
ok rant over, but seriously though, it’s so fucked how you basically just need a smartphone to do ANYTHING these days. I don’t want a phone, i have no use for one.
- Comment on Facepalm on multiple levels 1 week ago:
he literally did, definitionally he launched a failed coup. At the very least an attempted insurrection.
- Comment on Facepalm on multiple levels 1 week ago:
dont let the defenestration allegations hit you on the way out
- Comment on Facepalm on multiple levels 1 week ago:
well then you better hope DJT goes first i guess, because that statement does not meet the logical extent of that circumstance.
- Comment on How does this pic show that Elon Musk doesnt know SQL? 1 week ago:
yeah, that sounds about right, ok i think we’ve figured this one out now. lol
- Comment on How does this pic show that Elon Musk doesnt know SQL? 2 weeks ago:
… That’s what I said, you’d just update the row, i.e. replace the existing data, i.e. overwrite what’s already there
u were talking about not keeping historical data, which is one of the proposed reasons you would have “duplicate” entries, i was just clarifying that.
… I don’t think you understand how modern databases are designed
it’s my understanding that when it comes to storing data that it shouldn’t be possible to have two independent stores of the exact same thing, in two separate places, you could have duplicate data entries, but that’s irrelevant to the discussion of de-duplication aside from data consolidation. Which i don’t imagine is an intended usecase for a DB. Considering that you literally already have one identical entry. Of course you could simply make it non identical, that goes without saying.
Also, we’re talking about the DB used for the social security database, not fucking tigerbeetle.
- Comment on How does this pic show that Elon Musk doesnt know SQL? 2 weeks ago:
On June 25, 2011, the Social Security Administration changed the SSN assignment process to “SSN randomization”,[36] which did the following:
The Social Security Administration does not reuse Social Security numbers. It has issued over 450 million since the start of the program, about 5.5 million per year. It says it has enough to last several generations without reuse and without changing the number of digits. www.ssa.gov/history/hfaq.html
evidently they must be doing something else on the backend for this to be working, assuming there are quite literally 100M numbers, which is going to be static due to math, obviously, but they clearly can’t be reassigning numbers to 3 people on average at any given time, without some sort of external mechanism.
There are approximately 420 million numbers available for assignment.
www.ssa.gov/employer/randomization.html
that certainly doesnt seem like it would support several generations, possibly at our current birth rate i suppose.
DDG AI bullshit tells me that there are a billion codes. marketplace.org/…/will-we-ever-run-out-of-social-… this article says it’s 1 billion
www.ssn-verify.com/how-many-ssns
this website also lists it as approximately 1 billion.
- Comment on How does this pic show that Elon Musk doesnt know SQL? 2 weeks ago:
Also, elons remark is stupid as is. Im sure the row has a unique id, even if its just a rowid column.
even then, i wonder if there’s some sort of “row has function” that takes a hash of all the data in a single entry, and generates a universally unique hash of that entry, as a form of “global id”
- Comment on How does this pic show that Elon Musk doesnt know SQL? 2 weeks ago:
Well, there’s not always a benefit to keeping historical data. Sometimes you only want the most up-to-date information in a particular table or database, so you’d just update the row (replace). It depends on the use case of a given table.
in this case you would just overwrite the existing row, you wouldn’t use de-duplication because it would do the opposite of what you wanted in that case. Maybe even use historical backups or CoW to retain that kind of data.
Elon believes that each row in a table should be unique based on the SSN only, so a given SSN should appear only once with the person’s name and details on it. Yes, it’s an extremely dumb idea, but he’s a famously stupid person.
and naturally, he doesn’t know what the term “de-duplication” means. Definitionally, the actual identity of the person MUST be unique, otherwise you’re going to somehow return two rows, when you call one, which is functionally impossible given how a DB is designed.
- Comment on ‘If 1.5m Germans have them there must be something in it’: how balcony solar is taking off 2 weeks ago:
there’s definitely an interesting way to do it, i just don’t think it would be something i want, though i’m always up for some theory crafting, so who knows, maybe there is a good way of doing it.
Maybe the trick is just doing like 1 AC outlet per wall, and then using DC outlets for most other receptacles, since most devices are going to be low draw.
- Comment on ‘If 1.5m Germans have them there must be something in it’: how balcony solar is taking off 2 weeks ago:
it requires you to put in your address to locate your lat and long so it can properly calculate your energy production, especially throughout the year. It may still do some tracking on that, but it’s unlikely to be anything significant unless you have an account and money tied to it somehow.
But yes, a place close by you will work just as fine. Though you can expect some level of inaccuracy, it’s probably not that significant if you’re reasonably close.
- Comment on How does this pic show that Elon Musk doesnt know SQL? 2 weeks ago:
Big thing I’m prying at is whether there would be a legitimate purpose to have duplicated SSNs in the database
formally, changing the identity of someone would have a very explicit reason to keep a “duplicate” ssn entry, if purely for historical reasons for example. I’m sure there are a myriad of technical reasons to be doing this.
- Comment on How does this pic show that Elon Musk doesnt know SQL? 2 weeks ago:
it seems that nobody really cares about the word retard anymore, it’s quite funny how it went from super common language, to being less common, to people just saying it again now.
I’m curious how many people actually consider the word a slur, and how many people even care these days.
- Comment on How does this pic show that Elon Musk doesnt know SQL? 2 weeks ago:
it’s probably using some sort of proprietary home grown database, because it’s probably old enough that no database could support what they needed, could be wrong on that one, but it was my best guess.
- Comment on How does this pic show that Elon Musk doesnt know SQL? 2 weeks ago:
i’ve heard conflicting reports on this, i have no idea to what degree this is true, but i would be cautious about making this statement unless you demonstrate it somehow.
- Comment on How does this pic show that Elon Musk doesnt know SQL? 2 weeks ago:
TL;DR de-deuplication in that form is used to refer a technique where you reference two different pieces of data in the file system, with one single piece of data on the drive, the intention being to optimize file storage size, and minimize fragmentation.
You can imagine this would be very useful when taking backups for instance, we call this a “Copy on Write” approach, since generally it works by copying the existing file to a second reference point, where you can then add an edit on top of the original file, while retaining 100% of the original file size, and both copies of the file (its more complicated than this obviously, but you get the idea)
now just to be clear, if you did implement this into a DB, which you could do fairly trivially, this would change nothing about the DB operates, it wouldn’t remove “duplicates” it would only coalesce duplicate data into one single tree to optimize disk usage. I have no clue what elon thinks it does.
The problem here, as a non programmer, is that i don’t understand why you would ever de-duplicate a database. Maybe there’s a reason to do it, but i genuinely cannot think of a single instance where you would want to delete one entry, and replace it with a reference to another, or what elon is implying here (remove “duplicate” entries, however that’s supposed to work)
Elon doesn’t know what “de-duplication” is, and i don’t know why you would ever want that in a DB, seems like a really good way to explode everything,
- Comment on Bad UX is keeping the majority of people away from Lemmy 2 weeks ago:
it’s confusing from the perspective of choice paralysis, ultimately you can just make a new account and move to another instance if you really don’t like the one you’re on.
- Comment on Bad UX is keeping the majority of people away from Lemmy 2 weeks ago:
“feels like old reddit” is a weird way to say “it feels like new reddit, but doesn’t leak ram, doesn’t take as much or more processing power as AI does to run, and interjects ads randomly into the feeds”
- Comment on ‘If 1.5m Germans have them there must be something in it’: how balcony solar is taking off 2 weeks ago:
i can understand the thought process, especially if you’re going to do a full DC and no AC at all setup. The problem that i have is that switching from AC mains, to DC mains is such an incredibly tall order that you have to think about literally everything you integrate fairly significantly, otherwise you’re going to end up implementing AC mains as well, and then you’re not in a much better spot, even though you may now have more losses, chances are you could just offset them with more production and storage, or better inversion.
It’s an interesting project for sure, just not likely to be one i would ever invest time into lol.