How do you like your primary keys? [closed]

by

If you’re going to be doing any syncing between databases with occasionally connected apps, then you should be using GUIDs for your primary keys. It is kind of a pain for debugging, so apart from that case I tend to stick to ints that autoincrement.

Autoincrement ints should be your default, and not using them should be justified.

More Related Contents:

  1. Why use multiple columns as primary keys (composite primary key)
  2. Complexity of absolute difference and sum
  3. C++ Sorting Algorithms [closed]
  4. Sum a number with divisors to get another number
  5. What is the optimal algorithm for the game 2048?
  6. Reverse the ordering of words in a string
  7. Converting a Uniform Distribution to a Normal Distribution
  8. Can hash tables really be O(1)?
  9. Difference between Big-O and Little-O Notation
  10. Diff Algorithm? [closed]
  11. Leap year calculation
  12. Backtracking in A star
  13. What algorithms compute directions from point A to point B on a map?
  14. What is dynamic programming? [closed]
  15. Puzzle: Find largest rectangle (maximal rectangle problem)
  16. How can I calculate the age of a person in year, month, days?
  17. Performing Breadth First Search recursively
  18. Find the index of a given permutation in the sorted list of the permutations of a given string
  19. What is the most efficient algorithm to find a straight line that goes through most points?
  20. (Database Design – products attributes): What is better option for product attribute database design? [closed]
  21. How modern X86 processors actually compute multiplications?
  22. how do I create a line of arbitrary thickness using Bresenham?
  23. need an algorithm for collapsing netblock ranges into lists of superset ranges
  24. What is the best way to check the strength of a password?
  25. Algorithm for merging two max heaps?
  26. Why is vector array doubled?
  27. Can brute force algorithms scale?
  28. What is the algorithm that opencv uses for finding contours?
  29. Find XOR of all numbers in a given range
  30. Best algorithm for matching colours.

Leave a Comment