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

From Craig Ringer
Subject Re: what is the best way of storing text+image documents in postgresql
Date
Msg-id 4DF20F26.7020009@postnewspapers.com.au
Whole thread Raw
In response to Re: what is the best way of storing text+image documents in postgresql  (John R Pierce <pierce@hogranch.com>)
List pgsql-general
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 is just horrid.

Consider saveing the Word docs as plain text, then parsing them with a
Perl script or something to split them into questions and answers you
can store in the database.

Even if the script only does a rough job it might do enough of the job
that you could quickly go through and fix them up / check them against
the original documents.

There are almost certainly existing questionnaire / exam scripts or
applications you can re-use for the presentation side.

--
Craig Ringer

pgsql-general by date:

Previous
From: Willy-Bas Loos
Date:
Subject: [PERFORM] change sample size for statistics
Next
From: Craig Ringer
Date:
Subject: Re: PGP encrypt/decrypt - Prereqistes