Skip to main content

You are not logged in. Your edit will be placed in a queue until it is peer reviewed.

We welcome edits that make the post easier to understand and more valuable for readers. Because community members review edits, please try to make the post substantially better than how you found it, for example, by fixing grammar or adding additional resources and hyperlinks.

8
  • stackoverflow.com/questions/41132714/… that's mysql but it's still valid Commented Jan 5, 2017 at 7:47
  • And this postgresql stackoverflow.com/questions/41134260/… Commented Jan 5, 2017 at 7:48
  • @e4c5 yes I could normalize, I pretty much need to store the last 10 passwords a user used and not allow them to re-use when resetting. So when a new password is added need to pop off the 10th used password. Commented Jan 5, 2017 at 8:21
  • yeah, that's a reasonable situation for use of JSONB. I've used it with django but not sqlalchemy so can't give you specific syntax. However since it doesnt' sound like you are going to be doing any lookups on this field. Why not just Array ? Commented Jan 5, 2017 at 8:44
  • @e4c5 I wasn't sure if Array will always be the same order since I have to pop off the last one. In that case I could Commented Jan 5, 2017 at 8:59