From: | David Garamond <lists(at)zara(dot)6(dot)isreserved(dot)com> |
---|---|
To: | David Helgason <david(at)uti(dot)is> |
Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: YAGT (yet another GUID thread) |
Date: | 2004-01-17 05:05:58 |
Message-ID: | 4008C2B6.2060208@zara.6.isreserved.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
David Helgason wrote:
> I'm already using 'real' GUIDs, which in my case means that the database
> never generates them (since I don't have a generate_real_guid() function
> in the database (and don't need to).
>
> Neither GUID project on gborg (mentioned in another thread) seem to be
> Mac OSX compatible, which is my current platform (but I want to stay
> more-or-less free of platform dependance just yet).
What do you use for generating GUID in OSX? Does OSX have a GUID
generation API/syscall? What is its algorithm, does it show the MAC
address verbatim on the resulting GUID?
> However the client app uses a hex representation internally (don't tell
> me it's silly, it's already coded, due to intricacies of our project
> management), and my PL/PgSQL hex2bit() and bit2hex() functions are damn
> slow, so I'll be converting them to C any day not-so-soon (tried PL/Perl
> too, but even its simpler implementation was 5x slower yet !?)
Interesting. Care to share your plperl code? I would expect Perl to be
not so far behind C for this (at least if your using hex() &
pack()/unpack() and the "b" template; since the hard work will be done
in C routine anyway).
--
dave
From | Date | Subject | |
---|---|---|---|
Next Message | David Garamond | 2004-01-17 05:11:43 | Re: embedded/"serverless" (Re: serverless postgresql) |
Previous Message | Tom Lane | 2004-01-17 05:05:20 | Re: error creating sql function |