Re: [sqlalchemy] Custom UUID type with variant impl

2010-05-21 Thread Yang Zhang
On Thu, May 20, 2010 at 8:06 PM, Michael Bayer mike...@zzzcomputing.com wrote: On May 20, 2010, at 4:49 PM, Yang Zhang wrote: I defined a TypeDecorator with impl=postgres.PGUuid so that I can work with raw UUID bytes (instead of hex strings), but I'd like to make this portable to other

Re: [sqlalchemy] Custom UUID type with variant impl

2010-05-21 Thread Yang Zhang
Thanks for your follow-up answers to my questions (and in the other thread). I am curious about what you said on BLOBs making for poor PKs. Can you elaborate on that and/or point me to something that does? Thanks in advance. On Thu, May 20, 2010 at 8:06 PM, Michael Bayer mike...@zzzcomputing.com

Re: [sqlalchemy] Custom UUID type with variant impl

2010-05-21 Thread Michael Bayer
On May 21, 2010, at 2:09 PM, Yang Zhang wrote: Thanks for your follow-up answers to my questions (and in the other thread). I am curious about what you said on BLOBs making for poor PKs. Can you elaborate on that and/or point me to something that does? Thanks in advance. BLOBs are optimized

[sqlalchemy] Custom UUID type with variant impl

2010-05-20 Thread Yang Zhang
I defined a TypeDecorator with impl=postgres.PGUuid so that I can work with raw UUID bytes (instead of hex strings), but I'd like to make this portable to other DBMSs, where i want the impl to be a BLOB. How can I do this? The reference docs are pretty sparse here. Thanks in advance. -- Yang

Re: [sqlalchemy] Custom UUID type with variant impl

2010-05-20 Thread Michael Bayer
On May 20, 2010, at 4:49 PM, Yang Zhang wrote: I defined a TypeDecorator with impl=postgres.PGUuid so that I can work with raw UUID bytes (instead of hex strings), but I'd like to make this portable to other DBMSs, where i want the impl to be a BLOB. How can I do this? The reference docs are