News for hackers. Stuff that matters.
Re:My Notes on Gitlab's Postgres Schema Design (2022) by s4i on Sunday February 18, 2024 @02:37AM (#39417009)
It’s mentioned in the article. It’s more to do with business intelligence than security. A simple auto-incrementing ID will reveal how many total records you have in a table and/or their growth rate.

> If you expose the issues table primary key id then when you create an issue in your project it will not start with 1 and you can easily guess how many issues exist in the GitLab.

Re:My Notes on Gitlab's Postgres Schema Design (2022) by no-dr-onboard on Monday February 19, 2024 @06:43PM (#39436230)
Business intelligence isn’t really applicable on the database level with guids..way too many abstraction layers down.