best solution is to use int/long primary keys, with a uuid column that has a unique index. then the uuid can be used with public-facing apis.