Keep It Simple, Stupid | |
PerlMonks |
Re: Key to use for files in db!by SamCG (Hermit) |
on Jan 18, 2006 at 20:02 UTC ( [id://524054]=note: print w/replies, xml ) | Need Help?? |
Hmmm, looking at your problem, are you sure you want to use the path in the primary key at all? What happens if you move a set of files? Multiple updates on primary keys can be a pain...
I'd probably go with a unique number, something that I don't need to worry about updating, and then leave the path in a separate column(s).
In Section
Seekers of Perl Wisdom
|
|