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

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