I want ot store chunks of data (only about five Kb each) on a database
and have users download (across a network) these chunks to their local
disk drive. Is a blob a good way to store these chunks?

Thanks.

Search Discussions

  • Joshua D. Drake at Dec 7, 2009 at 5:39 pm

    On Mon, 2009-12-07 at 09:07 -0800, Daniel wrote:
    I want ot store chunks of data (only about five Kb each) on a database
    and have users download (across a network) these chunks to their local
    disk drive. Is a blob a good way to store these chunks?
    Well we don't have "blob". We have bytea and lo (which is bytea with a
    different delivery and storage mechanism).

    5k chunks is pretty small, bytea is probably fine.

    Joshua D. Drake

    Thanks.

    --
    PostgreSQL.org Major Contributor
    Command Prompt, Inc: http://www.commandprompt.com/ - 503.667.4564
    Consulting, Training, Support, Custom Development, Engineering
    If the world pushes look it in the eye and GRR. Then push back harder. - Salamander
  • Peter Geoghegan at Dec 7, 2009 at 5:40 pm
    Daniel,

    If the data will only be 5 Kb, I suggest you use bytea (binary string).

    Regards,
    Peter Geoghegan
  • Colin Streicher at Dec 8, 2009 at 1:32 am

    On December 7, 2009 12:07:49 pm Daniel wrote:
    I want ot store chunks of data (only about five Kb each) on a database
    and have users download (across a network) these chunks to their local
    disk drive. Is a blob a good way to store these chunks?

    Thanks.
    Put me on the list of recommending bytea,
    It works well for me, I use it for my virus database, and have noticed no
    perceptable lag from ~100k samples averaging probably 100kb.

    Colin
    --
    Best of all is never to have been born. Second best is to die soon.

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouppgsql-general @
categoriespostgresql
postedDec 7, '09 at 5:36p
activeDec 8, '09 at 1:32a
posts4
users4
websitepostgresql.org
irc#postgresql

People

Translate

site design / logo © 2021 Grokbase