>> There is no need for manually storing files on filesystem, because
>> large objects are doing that for You. I am storing whole binary files
>> in blobs(synonym for large objects from some other platforms), and I do
>> not remember that I had a single problem with that. Do not forget that
>> libp
Network Administrator <[EMAIL PROTECTED]> writes:
> Quoting Tom Lane <[EMAIL PROTECTED]>:
>> Commonly this means that you open a "handle" or "cursor" referring to
>> one particular blob and then read or write it through that handle.
> I understand the value of handles but aren't cursors used to br
I thought "bytea" was PG's version of BLOBs. I don't see a "blob" type in the
current docs.
Also, I saw your example code as well. I use Perl as well but I use the native
Pg.pm module. There doesn't seem to be a way to switch the input to binary data
but there is support for what is called "lar
BLOBs are PostgreSQL wierdness from before PostgreSQL had TOAST (which
removed the 8kb row limit). See
http://www.postgresql.org/docs/7.3/static/largeobjects.html
For info on the old BLOB interface.
Jon
On Thu, 11 Sep 2003, Network Administrator wrote:
> I thought "bytea" was PG's version of
>> If You are using Delphi, there is great project called "Zeos
>> objects", and if I remember correctly it has support for large
>> objects.
>>
>Zeos are useing a lot of memory...
Another issue I had with Zeos was that when I looked into possibly using
those components (this was probably over
What is the size limit of bytea, I thought it was 8K?
How do you dump your database when you have bytea, do you need to do a
binary dump?
What are you using to insert the binary data?
Thank you in advance.
Guy
Jonathan Bartlett wrote:
For the education of me and maybe others too, why was
tha
Quoting Andrew Ayers <[EMAIL PROTECTED]>:
> 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'v
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 m
Thanks that is extremely helpfull.
Guy
Jonathan Bartlett wrote:
What is the size limit of bytea, I thought it was 8K?
No limit that I've found. Some are several meg.
How do you dump your database when you have bytea, do you need to do a
binary dump?
Nope. pg_dump automagicall
Hi,
I think both ways can be used. For editing/working pictures can
be stored in db - easy interface and others... For speed of reading
files should be stored outside db.
Regards,
Michał Zaborowski (TeXXaS)
---(end of broadcast)---
TIP 5: Have
Darko Prenosil wrote:
There is no need for manually storing files on filesystem, because large
objects are doing that for You. I am storing whole binary files in
blobs(synonym for large objects from some other platforms), and I do not
remember that I had a single problem with that. Do not forget th
This discussion provides an opportunity to capture the
essentials of how to store and retrieve images using
PostgreSQL, and the issues (performance,
administration etc.) associated with each possible
method.
A discussion article on Techdocs (or even General
Bits?) would be a fine thing. My observ
On Wednesday 10 September 2003 17:17, Derrick Betts wrote:
> Is the size limit 8K for 'text' field types as well?
>
> > What is the size limit of bytea, I thought it was 8K?
Not for some time now - the TOAST system (Tom Lane's work IIRC) means you can
store large text fields in a table. By large
How do you deal with backing up the images? Right now i can remote
backup my filesystem using rsync to an offsite location many times a
day, only taking a very small amount of I/O, bandwidth and time.
Dealing with the backup scared me away from using postgres in the first
place. The idea
Network Administrator wrote:
I'll have to research that base64 encoding part because I'll
only every do text dumps.
Then the base64 storage in the database is perfect.
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregi
Is the size limit 8K for 'text' field types as well?
- Original Message -
From: "Guy Fraser" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, September 10, 2003 9:40 AM
Subject: Re: [GENERAL] Picture with Postgres and Delphi
> What is th
--- Jonathan Bartlett <[EMAIL PROTECTED]> 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?
_
I'm a big fan of bytea. In every case where I've done the filesystem
method I wished I hadn't.
Jon
On Tue, 9 Sep 2003, Edwin Quijada wrote:
> Hi !! Everybody
> I am developing app using Delphi and I have a question:
> I have to save pictures into my database. Each picture has 20 o 30k aprox.
>
On Tue, 9 Sep 2003, Darko Prenosil wrote:
>
> - Original Message -
> From: "Edwin Quijada" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Tuesday, September 09, 2003 6:54 PM
> Subject: [GENERAL] Picture with Postgres and Delphi
>
>
- Original Message -
From: "listy.mailowe" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, September 09, 2003 8:10 PM
Subject: Re: [GENERAL] Picture with Postgres and Delphi
> Hi,
>
> Edwin Quijada wrote:
>
> > Hi !! Everybody
> >
- Original Message -
From: "Edwin Quijada" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, September 09, 2003 6:54 PM
Subject: [GENERAL] Picture with Postgres and Delphi
> Hi !! Everybody
> I am developing app using Delphi and I have a question:
&g
Hi Edwin,
it depends on the components u use in Delphi. Normally Pictures and
ohter binary data is stored in the FieldType oid. I noticed that bytea
isn't mapped as TBlobField in Delphi in most components. I also don't
know if you are able to use the PG-Functions lo_import(), lo_export()
and so on
Hi,
Edwin Quijada wrote:
Hi !! Everybody
I am developing app using Delphi and I have a question:
I have to save pictures into my database. Each picture has 20 o 30k aprox.
What is the way more optimus?
That 's table will have 50 records around. Somebody said the best way to
do that was encode
Hi !! Everybody
I am developing app using Delphi and I have a question:
I have to save pictures into my database. Each picture has 20 o 30k aprox.
What is the way more optimus?
That 's table will have 50 records around. Somebody said the best way to
do that was encoder the picture to field byte
24 matches
Mail list logo
