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.