Re: How to migrate column type from uuid to serial - Mailing list pgsql-general

From Hemil Ruparel
Subject Re: How to migrate column type from uuid to serial
Date
Msg-id CANW1aT-Kx7RfdEmB3tnjJ7PP+87YC5a2w8Lm9D9=o9aytK2NYg@mail.gmail.com
Whole thread Raw
In response to Re: How to migrate column type from uuid to serial  ("Peter J. Holzer" <hjp-pgsql@hjp.at>)
List pgsql-general
oh. I get it now. Thanks


On Sat, Oct 10, 2020 at 3:41 PM Peter J. Holzer <hjp-pgsql@hjp.at> wrote:
On 2020-10-10 11:31:23 +0200, Peter J. Holzer wrote:
> On 2020-10-07 20:10:34 +0530, Hemil Ruparel wrote:
> > Sorry if this is silly but if it is a 128 bit number, why do we need 32
> > characters to represent it? Isn't 8 bits one byte?
>
> Yes, 8 bits are 1 byte. But that's 256 different values, so to display
> them in 1 character you would need 256 different characters. That's not
> possible in ASCII (ASCII has only 94 graphic characters), and even if
> you included accented characters and other alphabets (like Greek or
> Cyrillic) it would be hard to read.

I'm showing my European bias here.

I should have thought of Korean. The Hangul script is syllabic with a
very straightforward and easy to learn structure. Wikipedia tells me
that they have 19 consonants and 21 vowels, so you could just pick 16
consonants and 16 vowels to construct 256 syllables. That would even
make UUIDs pronounceable.

        hp

--
   _  | Peter J. Holzer    | Story must make more sense than reality.
|_|_) |                    |
| |   | hjp@hjp.at         |    -- Charles Stross, "Creative writing
__/   | http://www.hjp.at/ |       challenge!"

pgsql-general by date:

Previous
From: Thorsten Schöning
Date:
Subject: Re: What's your experience with using Postgres in IoT-contexts?
Next
From: Cory Nemelka
Date:
Subject: Re: Writing WAL files