Conversation

Notices

1. Embed this notice
   Hyperhidrosis (hyperhidrosis@shitposter.world)'s status on Wednesday, 12-Feb-2025 06:17:57 JST Hyperhidrosis
   the gubbernmen uses excel
   • Doughnut Lollipop 【記録係】:blobfoxgooglymlem: repeated this.
   • Embed this notice
     Harblinger (harblinger@wizard.casa)'s status on Wednesday, 12-Feb-2025 06:17:56 JST Harblinger

     in reply to

     @Hyperhidrosis

     Pissed Hippo likes this.
   • Embed this notice
     Pissed Hippo (sun@shitposter.world)'s status on Wednesday, 12-Feb-2025 06:22:38 JST Pissed Hippo

     in reply to
     @Hyperhidrosis They're both wrong. The SSN is:
     
     1. a natural primary key, you don't use those as your real primary key, you make a synthetic one
     2. there are in fact duplicate SSNs because it is a manual process going back to the earliest 20th century. That's why you don't use them for your real primary key. I used to work on a system that would find duplicate SSNs.
     
     Musk is right that giant systems don't necessarily use SQL but they're still keyed on something.
     Doughnut Lollipop 【記録係】:blobfoxgooglymlem: likes this.
   • Embed this notice
     Jeff "never puts away anything, especially oven mitts" Cliff, Bringer of Nightmares 🏴‍☠️🦝🐙 🇱🇧🧯 🇨🇦🐧 (jeffcliff@shitposter.world)'s status on Wednesday, 12-Feb-2025 06:28:20 JST Jeff "never puts away anything, especially oven mitts" Cliff, Bringer of Nightmares 🏴‍☠️🦝🐙 🇱🇧🧯 🇨🇦🐧

     in reply to

     • Pissed Hippo
     @sun @Hyperhidrosis also
     
     The SSN was never intended as a primary key, the concept of a primary key didn't really exist, and it should never be used that way outside of social security(do y'all even still have that?). It should be used as a social security identifier that's it.
     
     it's abused if it's used for *any* other purpose by the US govt including whatever musk is doing to them, just like the SIN is abused by every government department here
   • Embed this notice
     Pissed Hippo (sun@shitposter.world)'s status on Wednesday, 12-Feb-2025 06:28:20 JST Pissed Hippo

     in reply to

     • Jeff "never puts away anything, especially oven mitts" Cliff, Bringer of Nightmares 🏴‍☠️🦝🐙 🇱🇧🧯 🇨🇦🐧
     @jeffcliff @Hyperhidrosis since the patriot act, the government is allowed to use SSN as a person identifier. but the reason it's used in these systems is because they're all attached to taxable events and for most human americans your SSN is your tax id.
   • Embed this notice
     Pissed Hippo (sun@shitposter.world)'s status on Wednesday, 12-Feb-2025 06:29:01 JST Pissed Hippo

     in reply to

     • Pissed Hippo
     • Jeff "never puts away anything, especially oven mitts" Cliff, Bringer of Nightmares 🏴‍☠️🦝🐙 🇱🇧🧯 🇨🇦🐧
     @jeffcliff @Hyperhidrosis you're right it wasn't supposed to be used as one, but every citizen is supposed to have a unique SSN so it's a natural primary key.
   • Embed this notice
     Pissed Hippo (sun@shitposter.world)'s status on Wednesday, 12-Feb-2025 06:30:10 JST Pissed Hippo

     in reply to

     • Jeff "never puts away anything, especially oven mitts" Cliff, Bringer of Nightmares 🏴‍☠️🦝🐙 🇱🇧🧯 🇨🇦🐧
     @jeffcliff @Hyperhidrosis we need a single id that is set up so it's not presumed to be private.
   • Embed this notice
     Jeff "never puts away anything, especially oven mitts" Cliff, Bringer of Nightmares 🏴‍☠️🦝🐙 🇱🇧🧯 🇨🇦🐧 (jeffcliff@shitposter.world)'s status on Wednesday, 12-Feb-2025 06:30:11 JST Jeff "never puts away anything, especially oven mitts" Cliff, Bringer of Nightmares 🏴‍☠️🦝🐙 🇱🇧🧯 🇨🇦🐧

     in reply to

     • Pissed Hippo
     @sun @Hyperhidrosis yea that's something to fix
     
     ie the US needs a 'temporary, private taxable event id' that is different from SSN just like we do
     Another Linux Walt Alt likes this.
   • Embed this notice
     Jeff "never puts away anything, especially oven mitts" Cliff, Bringer of Nightmares 🏴‍☠️🦝🐙 🇱🇧🧯 🇨🇦🐧 (jeffcliff@shitposter.world)'s status on Wednesday, 12-Feb-2025 06:30:18 JST Jeff "never puts away anything, especially oven mitts" Cliff, Bringer of Nightmares 🏴‍☠️🦝🐙 🇱🇧🧯 🇨🇦🐧

     in reply to

     • Pissed Hippo
     @sun @Hyperhidrosis except that it's shared and unique, so that's not good.
     
     ie people should be able to just use a *public* key for whatever purposes SSNs serve
     Pissed Hippo likes this.
   • Embed this notice
     Pissed Hippo (sun@shitposter.world)'s status on Wednesday, 12-Feb-2025 06:30:47 JST Pissed Hippo

     in reply to

     • Jeff "never puts away anything, especially oven mitts" Cliff, Bringer of Nightmares 🏴‍☠️🦝🐙 🇱🇧🧯 🇨🇦🐧
     @jeffcliff @Hyperhidrosis yeah like a 32 byte ecc public key
   • Embed this notice
     cookiejarobserver@dill.burggit.moe's status on Wednesday, 12-Feb-2025 06:41:11 JST CookieJarObserver

     in reply to

     • Pissed Hippo

     @sun@shitposter.world @Hyperhidrosis@shitposter.world
     
     What do you think they use?
     
     And how much of a difference does it make?

   • Embed this notice
     Pissed Hippo (sun@shitposter.world)'s status on Wednesday, 12-Feb-2025 06:41:11 JST Pissed Hippo

     in reply to

     • CookieJarObserver
     @CookieJarObserver @Hyperhidrosis A lot of them still do actually use SQL, but a lot of government systems use document databases utilizing XML, called MarkLogic
   • Embed this notice
     Pissed Hippo (sun@shitposter.world)'s status on Wednesday, 12-Feb-2025 06:42:37 JST Pissed Hippo

     in reply to

     • Pissed Hippo
     • CookieJarObserver
     @CookieJarObserver @Hyperhidrosis the duplicated information Musk refers to may in fact be connected to using a document database but who knows.
   • Embed this notice
     Pissed Hippo (sun@shitposter.world)'s status on Wednesday, 12-Feb-2025 06:48:54 JST Pissed Hippo

     in reply to

     • CookieJarObserver
     @CookieJarObserver @Hyperhidrosis lot of stuff is still run on mainframe too, which can actually be the right tool for the job.
   • Embed this notice
     cookiejarobserver@dill.burggit.moe's status on Wednesday, 12-Feb-2025 06:48:55 JST CookieJarObserver

     in reply to

     • Pissed Hippo

     @sun@shitposter.world @Hyperhidrosis@shitposter.world
     
     Ah interesting. Makes sense on one hand and on the other i can see how thats a bad idea for speed, efficiency and security when handling government amounts of data. But maybe someone did a great software for that that i don't know off.
     
     Still screams "i don't know shit" from musks direction regardless.