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

From: Leif Biberg Kristensen <leif(at)solumslekt(dot)org>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: what is the best way of storing text+image documents in postgresql
Date: 2011-06-10 13:19:00
Message-ID: 201106101519.00189.leif@solumslekt.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Sanjay Rao 2011-06-10 15:13:22 Re: postgres server on windows with high availability and failover safe
Previous Message Craig Ringer 2011-06-10 12:50:04 Re: PGP encrypt/decrypt - Prereqistes