-
Notifications
You must be signed in to change notification settings - Fork 56
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
Suggest to use jsonb
instead of json
#110
Comments
I like the idea. More generally, we could have a detector that looks for columns of type X and recommends converting to type Y. Can you think of any other examples where this would be a good idea? Also, please hold off with development as I'd like to clean up the PR backlog first. |
From the top of my head - nope, but need to research.
😄 |
This is PostgreSQL specific. The problem is described here - https://github.com/fatkodima/online_migrations#adding-a-json-column.
Also seems like
jsonb
is the preferred type and it also shows a better performance.The text was updated successfully, but these errors were encountered: