RE: Question re large objects - Mailing list pgsql-php
From | Justin Long |
---|---|
Subject | RE: Question re large objects |
Date | |
Msg-id | PBEMJIMKFNACLPCNPDEBEEMNEHAA.justinlong@strategicnetwork.org Whole thread Raw |
In response to | Question re large objects (chriswood@wvda.com) |
List | pgsql-php |
Point #1: I've heard rumors that BLOBs have been buggy in the past (I'm using 7.0 right now...). Point #2: I would be interested in knowing if you come up with a way to do this. Right now we have a large web site with databases of over 10GB and many image files. We are storing them on a single shared directory on one server as we can't find any way to do what you are saying... Of course, I've never asked anyone for help, either, so kudos for your bravery! :-) Justin Long _________________________________________________________________ Justin Long Network for Strategic Missions 1732 South Park Court Never retreat. Never surrender. Chesapeake, VA 23320, USA Never cut a deal with a dragon. 757-213-2055, ICQ 97269932 http://www.strategicnetwork.org Monday Morning Reality Check: reality-check-subscribe@egroups.com -----Original Message----- From: pgsql-php-owner@postgresql.org [mailto:pgsql-php-owner@postgresql.org]On Behalf Of chriswood@wvda.com Sent: Tuesday, November 28, 2000 12:26 PM To: pgsql-php@postgresql.org Subject: [PHP] Question re large objects (Hopefully I'm addressing this to the right list... This is my first time with BLOBs anywhere.) I'm working on a web page template system (PHP/PostgreSQL) which will (in part, other stuff is done) allow users to upload a gif or jpeg via a form on another site. The image will then slot into a predetermined place on their template website. I've considered the alternatives (store files in a directory or in the db), and I think storing the image files in the database is the way to go. Unless anybody can think of why I should just upload the files to a directory on the server instead of storing them as BLOBs. I can upload a binary file just fine, and retrieve it from the database just fine. The problem is that the file (using pg_loreadall) just plunks itself into my test page as text/plain. How do I get a mime type header associated with this data so my browser will recognize it as a gif or jpeg? Do I have to export the file to a web-accessible directory (owned by web server user, I know) and then use an <img> tag? Or is there a way to get my browser to recognize that the BLOB is in fact an image when PHP pulls it out of the PostgreSQL database? Be gentle if I've asked a stupid question... :-) -------------------------------------------------------- Christopher Wood, Community Access Technical Coordinator Western Valley Development Authority Nova Scotia's Smart Community Box 251 Bridgetown, Nova Scotia B0S 1C0 tel: (902) 665-4083/ fax: (902) 665-2878 www.wvda.com www.wvcn.ns.ca --------------------------------------------------------