Re: USMARC and postgresql?

From: "Brett W(dot) McCoy" <bmccoy(at)chapelperilous(dot)net>
To: Andrew Sullivan <sullivana(at)bpl(dot)on(dot)ca>
Cc: user Postgresql ML <pgsql-general(at)postgresql(dot)org>
Subject: Re: USMARC and postgresql?
Date: 2000-05-09 13:26:09
Message-ID: Pine.LNX.4.10.10005090920500.17232-100000@chapelperilous.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, 9 May 2000, Andrew Sullivan wrote:

> BLOBs. It's a pain, though, because building the indices against the
> catalogue is difficult. I think, actually, that the PICK-based spproach is
> better, but PICK is going away. Anyway, you likely need to talk to someone
> about BLOBs. I can't help, sorry.

The MARC format is really intended to be used in a full-text search
environment, such as the old online systems like Dialog or Lexix-Nexis use
(although they don't use MARC specifically). They all predate SQL and
mapping one onto the other is not an easy task. It's easy to go from a
SQl database to one of the variable-length (or 80 column card image)
text-formats, but not the other way around unless you are into doing some
text-processing programming.

Brett W. McCoy
http://www.chapelperilous.net
---------------------------------------------------------------------------
If the very old will remember, the very young will listen.
-- Chief Dan George

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Brett W. McCoy 2000-05-09 13:50:44 Re: Postgres Tool Question
Previous Message Samuel A. Mullen 2000-05-09 13:20:52 Postgres Tool Question