Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsGeneralPHPASPPerlColdFusionFlashHTML, CSS, ScriptsBrowsers

Webmaster Forum / Perl / DBI Library / July 2008



Tip: Looking for answers? Try searching our database.

Nonnumeric Primary Keys

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Karen Hoofnagle - 03 Jul 2008 18:41 GMT
Hey, all I have a db in production that uses a whole lot of string  
values as primary keys. (It's Oracle, FWIW)  Does DBIX::Class care  
what data type a primary key is?  I *vaguely* remember hearing some  
sort of remark in the Catalyst master class Jon Rockway taught at YAPC  
that this is an issue, but I might have imagined it.

Thanks,
Karen
C.J. Adams-Collier - 03 Jul 2008 21:20 GMT
Maybe it had to do with string comparisons being more expensive than
numeric comparisons?  I think you can make whatever datatype you'd like
a primary key.

> Hey, all I have a db in production that uses a whole lot of string  
> values as primary keys. (It's Oracle, FWIW)  Does DBIX::Class care  
[quoted text clipped - 4 lines]
> Thanks,
> Karen
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.