Is it good to store dynamically created file's paths in database ?

T开发者_高级运维his is in reference with my earlier question how to organize files created dynamically using php?

I edited the question , with one more aspect, that is storing paths in to the DB. Are there any advantages or disadvantages of doing this?

---

If you have no other way of finding the file, storing its path in the DB is probably OK.

Still, a couple of notes :

• I would generally try to see if I could "guess" the file's path from another field -- for instance, from the primary key
  • If it's possible, then, there is no need to store the path in the DB, as it would be some redundant information
• I would, as much as possible, store some relative path, and not an absolute one.
  • For instance, I would store images/my/image-test.png
  • But not /var/www/images/my/image-test.png
  • That way, moving the directory with the images to another place, or changing of server, using a new one with another path to the DocumentRoot, would still be OK and not break my application.