Skip site navigation (1) Skip section navigation (2)

Re: Storing file in postgresql and accessing them with psycopg

From: Federico Di Gregorio <fog(at)dndg(dot)it>
To: Ottavio Campana <ottavio(at)campana(dot)vi(dot)it>
Cc: psycopg(at)postgresql(dot)org
Subject: Re: Storing file in postgresql and accessing them with psycopg
Date: 2012-01-05 10:40:23
Message-ID: 4F057E17.3010300@dndg.it (view raw or flat)
Thread:
Lists: psycopg
On 05/01/12 11:29, Ottavio Campana wrote:
> I've been looking online about how to do it, and I've seen that there are
> two ways, i.e. with bytea and oid. Particularly I found this page
> http://www.zephid.dk/2008/08/09/oid-vs-bytea-in-postgresql/  , it's about
> php but it can give a few hints, even though it's more than three years
> old.

I'd like to see such a test done in Python using psycopg. From the text 
one doesn't understand if the overhead is due to PostgreSQL or the PHP 
driver. LOBs are nice because they have file-like semantics so probably 
have a less overhead for large files but I don't see why small files 
should have such an high impact on bytea.

federico


In response to

psycopg by date

Next:From: Giovanni MascellaniDate: 2012-01-10 08:51:51
Subject: Use lo_creat() when possible instead of lo_create()
Previous:From: Ottavio CampanaDate: 2012-01-05 10:29:56
Subject: Storing file in postgresql and accessing them with psycopg

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group