404 karma · joined August 4, 2015
And that will cause blocks by IP. It's not like authorities in those countries care that much if a user can't access a not-blocked site, as long as they can't access a blocked one.
And why are unique MAC addresses a problem?
Private networking is good. IPv6 doesn't help here at all.
It made me veeeeeeeeery uncomfortable. Still a very good talk.
So USA can only watch, while China can actually steal.
Say you have a unique constraint on two columns (column_a, column_b). column_a is not nullable, column_b IS nullable. Obviously these values are unique:
(1, 2) (1, 3) (2, 2)
But these values ARE ALSO UNIQUE:
(1, NULL) (1, NULL)
It is obvious in hindsight (NULL isn't equal to NULL), but can be quite a surprise.
...
Oh wait, postgres 15 deals with just this situation. Huh.