triage icon indicating copy to clipboard operation
triage copied to clipboard

Use the Postgres UUID column type for UUID values

Open jtwalsh0 opened this issue 3 years ago • 1 comments

We've been using SQLAlchemy text type for UUID columns rather than Postgres's native UUID column type. (See here for an example.) The latter is 1) more efficient and 2) more robust because it handles inconsistent hyphen use.

The biggest drawback to the Postgres type is that it ties triage to Postgres. Are we hoping to remain database agnostic?

Perhaps I'm being optimistic, but I'd expect this to be an easy change, and I'd be happy to do it if there are no objections.

jtwalsh0 avatar Sep 04 '21 21:09 jtwalsh0

triage is not db agnostic :)

nanounanue avatar Sep 17 '21 20:09 nanounanue