GitHub user Neilk1021 created a discussion: Proposal - Migrating User Authentication to a new table to support multiple log-in sources.
### What we're proposing <img width="257" height="305" alt="image" src="https://github.com/user-attachments/assets/d35a2283-faab-4bca-832d-2cc3a52add45"; /> <img width="461" height="305" alt="image" src="https://github.com/user-attachments/assets/80816ac3-ce45-4506-98b7-a0d04c447af1"; /> --- Split the current authentication from all existing on the `User` table to a new `AuthProvider` table. ### Why Currently everytime we want to add a new authentication service (e.g. facebook), we need to add a whole new set of columns to `TexeraDDL` and also provide code to migrate older databases. It prevents the Users table from being a bloated god table, and better follows SOC. ### Considerations There is a small performance overhead introduced by the needed psql query to join the User to their Authentication Providers, however, this is O(p) (where p is the number of providers a user has) operation and since p is small its effectively an O(1) op. ### Questions for discussion: * Are there modifications we want to this schema? * Is there any current reason it *needs* to be a single table, if so what? GitHub link: https://github.com/apache/texera/discussions/6716 ---- This is an automatically sent email for [email protected]. To unsubscribe, please send an email to: [email protected]
