However, it seems that the default set-up is to still have a “serial” (ie. auto-incrementing integer) as primary key.
This is not optimal; there's no need to have two surrogate keys for the same object.
Does anyone have experience in using UUIDs as the the (only) primary key? Can you do it without having Views and other modules puke?