Difference Between Int , long or Guid on Entity ID ? #4448

0

simedbn created 6 years ago

Hello,

What is the pros and cos for using int or long over GUID in the entity ?

Thank you in advance

0

bbakermmc created 6 years ago

Google says: <a class="postlink" href="https://www.exceptionnotfound.net/integers-vs-guids-the-great-primary-key-debate/">https://www.exceptionnotfound.net/integ ... ey-debate/</a>
0
aaron created 6 years ago
Support Team
Nice share, @BBakerMMC. "Google says" is a bit misleading though, more like "Google gives this link".

I would like to share a set of examples:

int: "Categories" of Items (many Items to one Category)

long: "Items" that any user can create

Guid: "Notifications" that are system-generated when an event occurs on an Item (many Notifications to one Item)

Deal breakers from the article:

You DON'T want your URLs to be "hackable" by your end-users (or can't do proper permission checking on ids) → Guid

You need to be able to combine data from difference sources with little-to-no chance of duplicate GUIDs → Guid

sequential integers may give away other information (from a comment on the article) → Guid

Have an answer to this question? Log in and write your answer.