Re: Video storage in Postgres? - Mailing list pgsql-advocacy

From Joshua D. Drake
Subject Re: Video storage in Postgres?
Date
Msg-id 46C645D7.6060404@commandprompt.com
Whole thread Raw
In response to Re: Video storage in Postgres?  (Josh Berkus <josh@agliodbs.com>)
List pgsql-advocacy
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Josh Berkus wrote:
> Greg,
>
>> It's not as slick as having libpq do it in general but an awful lot of
>> things would have to change to make streaming out a video stored in a
>> single datum possible -- not just in libpq but in the server as well.
>
> Let me add it to TODO then.  We'd capture a whole new user community if we
> had a decent streaming API.  If we could use the same mechanism to return
> a few rows at a time, then that would be keen too ...

Well even more so, just having a more reasonable mechanism for pulling
large bits of data would be nice. If all of our data could be pulled in
a similar way to LO (where it is pulled a little bit at a time and
released), our efficiency would go up quite a bit.

Joshua D. Drake


>


- --

      === The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564   24x7/Emergency: +1.800.492.2240
PostgreSQL solutions since 1997  http://www.commandprompt.com/
            UNIQUE NOT NULL
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFGxkXXATb/zqfZUUQRApWJAJ9wHErgFlEciDeKxWuZUOa0JV3sQACfaWos
4wRv5astDWSsP/HgI4SQv/k=
=6n3N
-----END PGP SIGNATURE-----

pgsql-advocacy by date:

Previous
From: Josh Berkus
Date:
Subject: FOSS.IN Project Day?
Next
From: Hans-Juergen Schoenig
Date:
Subject: Re: Video storage in Postgres?