How to map/model files?

From: Joseph Schmidt (joseph_schmidt7..ahoo.com)
Date: Sat Mar 21 2009 - 15:18:32 EDT

  • Next message: csergiu77: "inheritance"

    How to model/map files (with their content) e.g. in webapplications?
    What is the best practice?
    (1) To put their content as blob fully in the DB plus fields for properties,
    or
    (2) to put the metadata about files only in the DB and the content
       in a file system?
    or
    (3) other solution?

    The second one seems to be the most efficient, but than the entire transaction
    support is lost :(.

    What's the best solution with Cayenne?

    Thank you,
    Joseph

    This archive was generated by hypermail 2.0.0 : Sat Mar 21 2009 - 15:20:42 EDT