I think that is what someone mentioned earlier in this thread. I guess you can
do that with a "text" type which according to the docs doesn't have an upper
limit (although there is that 1Gb limit for a single character string. The way
that entire paragraph reads would have me to believe that it means you and do
1Gb of characters including the EOL but then there is no restriction on the
number of lines themselves)
Quoting "scott.marlowe" <scott.marlowe@ihs.com>:
> Well, assuming you can store a reasonable large text file in any database,
> you can also look at uuencoding / base-64 encoding as a way of storing
> things in the database.
>
> It's more easily ported than either bytea or large objects.
>
> On Wed, 10 Sep 2003, Network Administrator wrote:
>
> > I'd actually like to get some comments on this too because for
> compatibility and
> > throughput issues, I would think that storing the file path in the
> database
> > instead of the actually file would be "better". I've done one application
> like
> > this in the past that very worked well. I'm getting ready to do the final
> > e-commerce integration on a new site and if there is an advantage to
> storing the
> > files in the database (in this case about 300 jpeg images for a t-shirt
> site)
> > I'll try that out. I'll have to research that base64 encoding part because
> I'll
> > only every do text dumps.
> >
> > Keith-
> >
> > Quoting Jeff Eckermann <jeff_eckermann@yahoo.com>:
> >
> > > --- Jonathan Bartlett <johnnyb@eskimo.com> wrote:
> > > > I'm a big fan of bytea. In every case where I've
> > > > done the filesystem
> > > > method I wished I hadn't.
> > >
> > > For the education of me and maybe others too, why was
> > > that? i.e. what problems did you run into, that bytea avoids?
> > >
> > > __________________________________
> > > Do you Yahoo!?
> > > Yahoo! SiteBuilder - Free, easy-to-use web site design software
> > > http://sitebuilder.yahoo.com
> > >
> > > ---------------------------(end of broadcast)---------------------------
> > > TIP 8: explain analyze is your friend
> > >
> >
> >
>
--
Keith C. Perry
Director of Networks & Applications
VCSN, Inc.
http://vcsn.com
____________________________________
This email account is being host by:
VCSN, Inc : http://vcsn.com