New URL: http://datachomp.com/archives/enums-for-when-you-just-cant-handle-another-foreign-key/
I’m seeing a github 404 at this address.
URL changed, and I can’t seem to edit now. Posted in a top level comment.
I’m not sure what the etiquette is, but you may want to delete and resubmit.
Its been too long it seems, I could not delete or edit. I would resubmit otherwise.
Enums are great, but I didn’t know they were a secret or anything. With psycopg2 (Python postgres driver), it’s pretty easy to set it up so that the Postgres enum is converted to a Python enum and a Python enum is converted to a Postgres enum. And by “Python enum,” I mean the new enum package which is also available on PyPI for Python 2.4+.
Also, I’m not afraid to admit that I chuckled a bit at this:
Neither your typical Rails Dev or ActiveRecord itself is going to try to implement the above without tears of sadness streaming down to their Mac.
You can do something similar on SqlServer using the built-in SQLCLR to support .NET enums.