On Wednesday, January 15, 2020 at 7:06:27 AM UTC-8, Carlos Correia wrote:
>
> Às 05:45 de 15/01/20, Dave S escreveu:
>
>
>
> On Sunday, January 12, 2020 at 9:36:14 AM UTC-8, Carlos Correia wrote: 
>>
>> Às 22:51 de 10/01/20, Dave S escreveu: 
>> > For web2py/pydal when the backend is PostGres, are blob fields 
>> translated to 
>> > bytea or to large object? 
>> > 
>> > If bytea, does the adapter check that the value being added fits the 1G 
>> limit 
>> > of PostGres, or can a 2G field be sent (and then rejected by the 
>> backend)? 
>>
>>
>> Psycopg2 (not Web2py) maps blobs to bytea, but has the 1GB limit. 
>>
>> This thread explains how to deal with that (using lo_import and 
>> lo_export): 
>>
>>
>> https://postgresrocks.enterprisedb.com/t5/EDB-Postgres/problems-with-writing-reading-a-data-bytea/td-p/2095
>>  
>>
>>
>
> Thanks for the pointer.  I'm a little disappointed the example didn't show 
> how to use lo_import() and lo_export() in the python portion, and not just 
> in the psql access, but it appears I can avoid that if I can guarantee 
> fitting into 500MB.
>
>
> To use lo_* functions in Python you should use db.executesql( '...' ) 
> directly.
>

So it seems.
 

> One approach (for files bigger then 500MB) would be to store them in the 
> filesystem and store their pathnames in a DB field as mentioned in one of 
> the comments.
>

Yes.  Under the hood, that seems to be what PostGres  does (the 1G limit 
comes from taking a couple bits as marker for this), and what the PG 
originla Large Object system did.

Regards,
>
> Carlos Correia
>
>
I regard your contributions with thanks!

/dps
 

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/web2py/f909abf8-020d-49d6-a37f-562629bc91f6%40googlegroups.com.

Reply via email to