Postgres integration about ooth HOT 4 OPEN

Hey thank you for your interest! I'd love to assist you and to add an ooth-postgres package to this library. It's going to be hard in the coming days since I'm doing a training this week. At any rate your best bet is to join the slack channel and @ me whenever you need me. If you take on the task here are a few thoughts:

the user object is structured this way:

{
  _id: "XXX"
  [strategyname]: {
    [key]: [value]
  }
}

where there could be many strategy names. Now the advantage of mongodb is that you can just store any kind of object, so no schema is needed. I'm not sure how you would solve this problem with postgres. So this might be a difficulty.

from ooth.

@nmaro sorry for the delay. Another project took priority and I got swamped. This would be fine for postgres since we could just use its jsonb storage to store that info. But when I have some time again Ill look at an alternative solution so that it can be used accross other sql databases as well, regardless of json support.

from ooth.

i found this reddit thread where people are discussing mongodb vs postgres with regards to user accounting

i found it noteworthy that the conversation is overwhelmingly in favor of postgres

from ooth.

@nmaro Any plan or roadmap for add Postgres support?
If Postgres support work then we can use it with other tools. For example we can use it for http://hasura.io/

see this links please:
https://docs.hasura.io/1.0/graphql/manual/auth/index.html
https://github.com/elitan/hasura-backend-plus

from ooth.