Data Design question: Storing formated documents

From: "Dr(dot) Evil" <drevil(at)sidereal(dot)kz>
To: pgsql-general(at)postgresql(dot)org
Subject: Data Design question: Storing formated documents
Date: 2001-10-10 02:49:00
Message-ID: 20011010024900.1914.qmail@sidereal.kz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


I have a complicated question: I am trying to design a database which
will allow users to store, edit, and display WAP pages. It's a
similar problem to storing, say, HTML or word processing documents.
You have a document which is like a graph. In the case of WAP it
would look be a hierarchy like this:

Deck
Card 1
Text element
Graphic
Link element
Text element
Card 2
Graphic element

etc...

Users will be able to construct and edit these pages, which should be
store in the DB.

I could have a datatype like this:

create table ... (
Deck TEXT,
...)

and then just include a bunch of WAP in the text field, but it seems
that it might be better to store everything parsed out into elements,
instead of trying to parse the text each time it needs to be edited.

What are your thoughts on the right approach to this?

Thanks

Browse pgsql-general by date

  From Date Subject
Next Message Gabriel Fernandez 2001-10-10 08:39:43 _timestamp invisible field
Previous Message Bruce Momjian 2001-10-10 01:17:05 Re: Mysql to postgres tools -reviews?