21 ms·
Just to make sure I understand your suggestion fully, you're saying: 1. Use `smallint` instead of `text` for the column type. 2. Otherwise follow our "`CHECK` c
by wojcikstefan 3y ago
Just to make sure I understand your suggestion fully, you're saying:
1. Use `smallint` instead of `text` for the column type.
2. Otherwise follow our "`CHECK` constraint" approach (without it we're jeopardizing data consistency because we can store anything between -32768 and 32767 in that column).
3. Translate the int to the enum in your application.
Right?
- out_of_protocol 3y agoYep!
- ComputerGuru 3y agoMost ORMs or just DALs can automate step 3 for you. If you’re using a strongly typed language with any type of ffi support, you’ll probably already have native cast from int to enum available (unless you’re using rust where that’s considered unsafe by default).