Skip to content
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

sql: jsonb support for postgres #516

Closed
therebelrobot opened this issue Jun 13, 2017 · 2 comments
Closed

sql: jsonb support for postgres #516

therebelrobot opened this issue Jun 13, 2017 · 2 comments
Labels
feat New feature or request. package/client package/jwk package/oauth2 upstream Issue is caused by an upstream dependency.
Milestone

Comments

@therebelrobot
Copy link
Contributor

The session_data in the access and refresh token tables are currently JSON strings, which don't allow for deep querying into the data when on postgres.

Would be great if there were a flag or something to enable jsonb for postgres instances, would save a bunch of time in db maintenance/querying/analytics.

@aeneasr aeneasr added this to the unplanned milestone Jun 13, 2017
@aeneasr aeneasr added feat New feature or request. upstream Issue is caused by an upstream dependency. labels Jun 13, 2017
@aeneasr
Copy link
Member

aeneasr commented Jun 13, 2017

Sort of upstream, because I want to wait for MySQL 5.7 to become more standard (a lot of people on 5.5 and 5.6) so we can upgrade postgres and mysql to jsonb.

@aeneasr aeneasr changed the title jsonb support for postgres storage: jsonb support for postgres Sep 15, 2017
@aeneasr aeneasr changed the title storage: jsonb support for postgres sql: jsonb support for postgres Sep 15, 2017
@aeneasr
Copy link
Member

aeneasr commented Aug 21, 2018

This has been open for over a year but no one else has complained, so it does not seem to be a big issue for anyone else. Closing.

@aeneasr aeneasr closed this as completed Aug 21, 2018
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
feat New feature or request. package/client package/jwk package/oauth2 upstream Issue is caused by an upstream dependency.
Projects
None yet
Development

No branches or pull requests

2 participants