News for hackers. Stuff that matters.

A comment on Mistakes Beginners Make When Working with Databases. Parent comment

Re:Mistakes Beginners Make When Working with Databases by falcolas on Wednesday June 08, 2016 @12:11PM (#11863242)
Personally, understanding how the engines usually work under the hood [0], I'd keep an integral PK, and have a `UNIQUE` external ID field.

[0] Having a string for a primary key will typically make there be a hidden integer primary key; better to have it explicit than implicit.

[ Parent | on HN ]
Re:Mistakes Beginners Make When Working with Databases by h43k3r on Wednesday June 08, 2016 @01:44PM (#11864041)
Can you point me to some docs that explain this ?
[ Parent | on HN ]