À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
<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.
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.
Regards,
Carlos Correia
=========================
MEMÓRIA PERSISTENTE
GSM: 917 157 146
e-mail: ge...@memoriapersistente.pt
URL: http://www.memoriapersistente.pt
XMPP (Jabber): car...@memoriapersistente.pt
GnuPG: wwwkeys.eu.pgp.net
--
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/17eae9d8-a895-7a08-30d9-8712dead17e1%40memoriapersistente.pt.
