Re: Sequence vs UUID

2023-01-26 Thread Ron
On 1/26/23 15:55, Erik Wienhold wrote: On 26/01/2023 20:17 CET veem v wrote: Hello, We were trying to understand whether we should use UUID or Sequence in general for primary keys. In many of the blogs (one is below) across multiple databases, I saw over the internet and all are mostly stating

Re: Sequence vs UUID

2023-01-26 Thread Merlin Moncure
On Thu, Jan 26, 2023 at 3:50 PM Rob Sargent wrote: > On 1/26/23 14:36, Merlin Moncure wrote: > > On Thu, Jan 26, 2023 at 1:18 PM veem v wrote: > >> Hello, We were trying to understand whether we should use UUID or >> Sequence in general for primary keys. In many of the blogs(one is below) >> acr

Re: Sequence vs UUID

2023-01-26 Thread Benedict Holland
You could always create a uuid matching table for anything displayed to users and keep a private ID for anything internal. From my particle standpoint, one is 8 bytes, the other is 16 or 32. Any database implementation should guarantee a unique value. I have had cases where it didn't work but those

Re: Sequence vs UUID

2023-01-26 Thread Erik Wienhold
> On 26/01/2023 20:17 CET veem v wrote: > > Hello, We were trying to understand whether we should use UUID or Sequence in > general for primary keys. In many of the blogs (one is below) across multiple > databases, I saw over the internet and all are mostly stating the sequence is > better as comp

Re: Sequence vs UUID

2023-01-26 Thread Rob Sargent
On 1/26/23 14:36, Merlin Moncure wrote: On Thu, Jan 26, 2023 at 1:18 PM veem v wrote: Hello, We were trying to understand whether we should use UUID or Sequence in general for primary keys. In many of the blogs(one is below) across multiple databases, I saw over the internet and all

Re: Sequence vs UUID

2023-01-26 Thread Merlin Moncure
On Thu, Jan 26, 2023 at 1:18 PM veem v wrote: > Hello, We were trying to understand whether we should use UUID or Sequence > in general for primary keys. In many of the blogs(one is below) across > multiple databases, I saw over the internet and all are mostly stating the > sequence is better as

Re: Sequence vs UUID

2023-01-26 Thread Christophe Pettus
> On Jan 26, 2023, at 11:17, veem v wrote: > So we want to understand from experts here, if there are any clear rules > available or if we have any pros vs cons list available for each of those to > understand the exact scenario in which we should go for one over other? Clear rules are a bit

Sequence vs UUID

2023-01-26 Thread veem v
Hello, We were trying to understand whether we should use UUID or Sequence in general for primary keys. In many of the blogs(one is below) across multiple databases, I saw over the internet and all are mostly stating the sequence is better as compared to UUID. But I think in the case of concurrent