Open
Description
When a project is created/removed, journals will exist with the project's name being case-sensitive.
We can have journals for project ABC
, and if it's been removed, project abc
can be created, and previous journal lookups will show nothing for ABC
, only abc
.
It's helpful to have the context in admin interfaces for projects as they change over time - uncertain of other places.
We could:
- change
journals.name
to becitext
instead oftext
- change
lower()
the input and resulting value at query time
Migration to citext could have some slowdown on this table (it's got ~23 million records). We already use citext
for journals.submitted_by
.
Using lower()
may have some query time performance issues, and we'd need to remember to use it everywhere we'd want to have those lookups be aligned.