What are the reasons for using a text-based format instead of a structured format like JSON for data field in notifications table ? #46981
Replies: 1 comment 1 reply
-
|
Feel free to modify column in your projects, it should work fine |
Beta Was this translation helpful? Give feedback.
1 reply
-
|
It should be noted that there may be reasons why the 'data' column is defined as 'text' type. |
Beta Was this translation helpful? Give feedback.
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
-
The 'data' field in the notifications schema has been defined as text. While text format is suitable for storing simple strings, developers may try to send JSON queries in the 'data' field, which can cause unexpected errors in Postgres.
Beta Was this translation helpful? Give feedback.
All reactions