Re: Video storage in Postgres?

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: josh(at)agliodbs(dot)com
Cc: pgsql-advocacy(at)postgresql(dot)org
Subject: Re: Video storage in Postgres?
Date: 2007-08-18 01:05:27
Message-ID: 46C645D7.6060404@commandprompt.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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-----

In response to

Browse pgsql-advocacy by date

  From Date Subject
Next Message Hans-Juergen Schoenig 2007-08-18 09:35:51 Re: Video storage in Postgres?
Previous Message Josh Berkus 2007-08-17 23:48:47 FOSS.IN Project Day?