Using blobs and Cayenne

From: Eric Lazarus (ericllazaru..ahoo.com)
Date: Tue Sep 19 2006 - 18:18:11 EDT

  • Next message: Dov Rosenberg: "Re: MS SQL Server Unicode Support"

    Hi, Folks!

    We are happy and up and running again.

    Question: We have text were were thinking we would
    store on a file system on the webserver and just keep
    the name of the file in the database.

    These files may be as large as a million characters.

    Would we be wise to use a clob field or to stay with
    what has been working for us, i.e., just storing the
    files as files to the database?

    I like the transactional nature of storing things in
    the database but I don't know what other problems we
    might be getting ourselves into by storing such data
    in the database.

    We use Postgresql under Linux with TomCat.

    We are concerned, for example, that we will not find
    it easy to backup the database or that other issues,
    not nec. cayenne related my mess us up.

    Thanks!

    Eric
    +1 (917) 589-6579

    __________________________________________________
    Do You Yahoo!?
    Tired of spam? Yahoo! Mail has the best spam protection around
    http://mail.yahoo.com

    This archive was generated by hypermail 2.0.0 : Tue Sep 19 2006 - 18:18:21 EDT