Skip to content

Propose changing the user_metadata column type from text to jsonb in the user_metadata table. #1134

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Open
nnnLik opened this issue Mar 30, 2025 · 0 comments
Labels
enhancement New feature or request

Comments

@nnnLik
Copy link

nnnLik commented Mar 30, 2025

Problem

Currently, the user_metadata column is stored as plain text (TEXT type), which:

  1. Requires parsing/stringifying JSON for every read/write operation. Has worse performance
  2. Doesn't provide native JSON validation at the database level

Solution

Changing the column type to jsonb would:

  1. Provide native JSON support in PostgreSQL (As I know, mysql also supports json since v5.7)
  2. Enable more efficient querying of nested metadata fields
  3. Allow indexing specific metadata fields if needed
@nnnLik nnnLik added the enhancement New feature or request label Mar 30, 2025
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
enhancement New feature or request
Projects
None yet
Development

No branches or pull requests

1 participant