←back to thread

85 points behnamoh | 1 comments | | HN request time: 0s | source
Show context
HPMOR ◴[] No.46340199[source]
Why is this the case? I don't understand, can somebody explain the logic to me here?
replies(6): >>46340207 #>>46340237 #>>46340299 #>>46340414 #>>46340431 #>>46340585 #
ares623 ◴[] No.46340237[source]
Maybe used the email address as a primary key. Ask me how I know.
replies(4): >>46340307 #>>46340346 #>>46340384 #>>46340390 #
prmph ◴[] No.46340346[source]
So with all their billions they could not get a proper software engineer to architect their project?

Unless there is some deep technical reason why things have to be this way, which I very much doubt.

And now they can't change it? Where is Claude when you need him/her

replies(1): >>46340549 #
1. jaggederest ◴[] No.46340549[source]
The funny thing is that if you ask Claude if you should use email address as a primary key it will pretty adamantly warn you away from it:

> I'd recommend against using email as the primary key for a large LLM chat website. Here's why:

> Problems with email as primary key:

> 1. Emails change - Users often want to update their email addresses. With email as PK, you'd need to cascade updates across all related tables (chat sessions, messages, settings, etc.), which is expensive and error-prone

> [Edited for length]