Hey, I'm looking for some suggestions about the best way to access bytea or lob objects in Postgres using DBIx. I know there was a discussion about this last month, but there wasn't any code examples and to be honest I am a bit of a newb to this.
The only example I could find was over at the catalyst mailing list at: "http://www.gossamer-threads.com/lists/catalyst/users/7324?search_string=blobs%20postgresql;#7324"; which is probably more than I need, since my expected binary files will be measured in kbytes, not megabytes. Based on this I was hoping to use a bytea column instead of a lob and have to use the lob loader functions. Everyone seems to think using bytea is easier and preferable as long as you don't need to stream or work with very large files. However I can't find a good example of this. Using the standard ->create I find I am limited to 4000 bytes which is a bit too small for me needs. Any suggestion about where I can find some examples would be appreciated. I've already googled through the postgresql site an I checked over at the pgpdb mailing list. I'm posting this here because I'd like to stay within the DBIx model if possible and was hoping someone else has already run into this issue. The actual need I have is to store web images and flash video files in the database. Right now I store everything on the filesystem but I have a mandate from the user for it to be in the database. This is also my preference so I am not inclined to try to talk him out of it unless it just can't be done. Thanks for you suggestions in advance! --john __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com _______________________________________________ List: http://lists.rawmode.org/cgi-bin/mailman/listinfo/dbix-class Wiki: http://dbix-class.shadowcatsystems.co.uk/ IRC: irc.perl.org#dbix-class SVN: http://dev.catalyst.perl.org/repos/bast/trunk/DBIx-Class/ Searchable Archive: http://www.mail-archive.com/[email protected]/
