CiteBar
Menu
Login
Registration
SQL ENUM data type is evil.
Probability: 83%
83%
Save
Rated by: whysage
Reasons:
Add reason
Probability
100%
Impact
+100
1.
Changing the member list of SQL ENUM columns is very expensive.
+100
100%
2.
You can't reuse the member-list of an SQL ENUM column in other tables.
+100
100%
3.
Getting a list of distinct SQL ENUM members is a pain.
+100
100%
4.
It's impossible to add additional attributes or related info to SQL ENUM.
+100
100%
5.
SQL ENUM has limited portability to DBMS.
+38
60%
6.
SQL ENUM data is not being treated like data.
+30
100%
7.
SQL ENUM columns have noteable gotchas.
+15
71%
8.
SQL ENUM columns may only offer limited or negligible effects on optimization.
+5
100%
Info:
Cite code: 11
Created at: Aug. 24, 2022, 12:43 p.m.
Created by: whysage
Related:
SQL ENUM data is not being treated like data.
Probability: 100%
100%
Save
Rated by: whysage
SQL ENUM has limited portability to DBMS.
Probability: 60%
60%
Save
Rated by: whysage
SQL ENUM columns may only offer limited or negligible effects on optimization.
Probability: 100%
100%
Save
Rated by: whysage
It's impossible to add additional attributes or related info to SQL ENUM.
Probability: 100%
100%
Save
Rated by: whysage
SQL ENUM columns have noteable gotchas.
Probability: 71%
71%
Save
Rated by: whysage
You can't reuse the member-list of an SQL ENUM column in other tables.
Probability: 100%
100%
Save
Rated by: whysage
Getting a list of distinct SQL ENUM members is a pain.
Probability: 100%
100%
Save
Rated by: whysage
Changing the member list of SQL ENUM columns is very expensive.
Probability: 100%
100%
Save
Rated by: whysage
Choose not to be around people who will sabotage you.
Probability: 68%
68%
Save
Rated by: citebot
Choose to be around people who will support you.
Probability: 52%
52%
Save
Rated by: citebot
×