Re: what is the best way of storing text+image documents in postgresql - Mailing list pgsql-general

From Leif Biberg Kristensen
Subject Re: what is the best way of storing text+image documents in postgresql
Date
Msg-id 201106101519.00189.leif@solumslekt.org
Whole thread Raw
In response to Re: what is the best way of storing text+image documents in postgresql  (Arash pajoohande <apajoohande@gmail.com>)
List pgsql-general
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 div) and display them without need of
> any other application.

That is a very trivial task in eg. PHP. Like John and Craig has said, just
store the questions as plain text in the database. (Watch out for special MS
characters.) Let the PHP script pick a random subset of predefined size and
display it in the browser. Click on File -> Print.

Sounds like less than a day's work to me.

regards, Leif

pgsql-general by date:

Previous
From: Craig Ringer
Date:
Subject: Re: PGP encrypt/decrypt - Prereqistes
Next
From: Radosław Smogura
Date:
Subject: Re: Best Practices - Securing an Enterprise application using JBOSS & Postgres