Viewing profile — jpmelos

I don't like this approach much because getting cryptic integers when you do a `SELECT` in the database is really cumbersome.

An enum stores a small reference to the enum value in the tuples, and the constraint approach stores the string itself. The constraint approach takes more space with (a) larger enu…

> Is there a reason ALTER TYPE name ADD VALUE new_enum_value wouldn't Just Work for the first example for 99% of use cases? I'm sorry, we don't have any examples in the article abo…

That would be an improvement on the `CHECK` constraint approach if the same `CHECK` constraint is used in multiple columns, to DRY it up. The `DOMAIN` types offer the same commands…

If understanding how Linux works interests you: http://www.linuxfromscratch.org/

This is something I really want to implement in 2019: a routine, and a general attitude, strategy, tactics and actions to "get my act together".

"Mindset: The New Psychology of Success". By Carol Dweck, PhD. This is a game-changer. It taught me what we believe is what really defines what we can or cannot do.