Re: [GENERAL] what is the best way of storing text+image documents in postgresql

2011-06-10 Thread Arash pajoohande
hello all and thank you for your advices On Thu, Jun 9, 2011 at 7:05 PM, Vincent Veyron vv.li...@wanadoo.fr wrote: Le mercredi 08 juin 2011 à 14:43 +0430, Arash pajoohande a écrit : and documents must display on web page when corresponding user requests occurs. I wonder why that is? is

Re: [GENERAL] what is the best way of storing text+image documents in postgresql

2011-06-10 Thread John R Pierce
On 06/10/11 12:04 AM, Arash pajoohande wrote: Actually, my word files consists of many exam questions. for each user, a random subset of questions must selected and displayed. it seem's that it would be nice if I have each question as an easy to handle document section (e.g. html div) and

Re: [GENERAL] what is the best way of storing text+image documents in postgresql

2011-06-10 Thread Craig Ringer
On 06/10/2011 03:26 PM, John R Pierce wrote: actually, for THAT requirement, I think I'd store the questions in the database as plain text and wrap them in HTML formatting in your View or Presentation layer as its being sent to the user I agree - sending a PDF, Word doc, RTF, etc for that

Re: [GENERAL] what is the best way of storing text+image documents in postgresql

2011-06-10 Thread Leif Biberg Kristensen
On Friday 10. June 2011 09.04.18 Arash pajoohande wrote: Actually, my word files consists of many exam questions. for each user, a random subset of questions must selected and displayed. it seem's that it would be nice if I have each question as an easy to handle document section (e.g. html

Re: [GENERAL] what is the best way of storing text+image documents in postgresql

2011-06-10 Thread Vincent Veyron
Le vendredi 10 juin 2011 à 11:34 +0430, Arash pajoohande a écrit : and documents must display on web page when corresponding user requests occurs. I wonder why that is? is there any reason you can't just store and serve

Re: [GENERAL] what is the best way of storing text+image documents in postgresql

2011-06-09 Thread Radosław Smogura
On Wed, 8 Jun 2011 14:43:16 +0430, Arash pajoohande wrote: hello i have a lot of files in microsoft word format. each file consists of text and images (other text formatting like font is not important). i want to store this documents in Postgresql, and documents must display on web page when

Re: [GENERAL] what is the best way of storing text+image documents in postgresql

2011-06-09 Thread Vincent Veyron
Le mercredi 08 juin 2011 à 14:43 +0430, Arash pajoohande a écrit : and documents must display on web page when corresponding user requests occurs. I wonder why that is? is there any reason you can't just store and serve the binary content as is, simply letting the proper application (Word in

[GENERAL] what is the best way of storing text+image documents in postgresql

2011-06-08 Thread Arash pajoohande
hello i have a lot of files in microsoft word format. each file consists of text and images (other text formatting like font is not important). i want to store this documents in Postgresql, and documents must display on web page when corresponding user requests occurs. it seems theres 2 way to do

Re: [GENERAL] what is the best way of storing text+image documents in postgresql

2011-06-08 Thread Craig Ringer
On 06/08/2011 06:13 PM, Arash pajoohande wrote: 1. save .doc documents in bytea columns. and show them with a word reader in web page (disadvantage: it needs a proper .doc reader installed on user computer) 1a: Convert the .doc files to a standard format like PDF that most browsers can

Re: [GENERAL] what is the best way of storing text+image documents in postgresql

2011-06-08 Thread John R Pierce
On 06/08/11 6:06 AM, Craig Ringer wrote: 1. save .doc documents in bytea columns. and show them with a word reader in web page (disadvantage: it needs a proper .doc reader installed on user computer) 1a: Convert the .doc files to a standard format like PDF that most browsers can display.

Re: [GENERAL] what is the best way of storing text+image documents in postgresql

2011-06-08 Thread Tomas Vondra
Dne 8.6.2011 21:37, John R Pierce napsal(a): On 06/08/11 6:06 AM, Craig Ringer wrote: 1. save .doc documents in bytea columns. and show them with a word reader in web page (disadvantage: it needs a proper .doc reader installed on user computer) 1a: Convert the .doc files to a standard format