From: | Nahum Castro <nahumcastro(at)gmail(dot)com> |
---|---|
To: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>, pgsql-es-ayuda <pgsql-es-ayuda(at)postgresql(dot)org> |
Subject: | Re: [psycopg] OT? plpython2u |
Date: | 2016-10-20 23:51:18 |
Message-ID: | CABqArLj9uoMnR_cn=jzs--u7Yiu8pM+1FrdqkVLetNtoUFK6Xg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-es-ayuda psycopg |
Hello Adrian.
The result image to replace the big one.
I have a table with images @ 12K but, went on vacation an when returned
someone replaced the pictures with high resolution images @6M. The app then
become very slow and halted.
I have already made the script in python to resize all the images from a
folder before to upload to the database, so it occurred to me do the same
but on the database.
Thanks again.
2016-10-20 18:32 GMT-05:00 Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>:
> On 10/20/2016 02:42 PM, Nahum Castro wrote:
>
>> Hello,
>>
>> The script always returns.
>> select encode(ajustar(foto), 'escape') from personal where id=193;
>> encode
>> -----------------------------------------------------------------
>> <PIL.Image.Image image mode=RGB size=300x347 at 0x7F08A11B1650>
>>
>>
>>
> So what do you want it to return a where do you want to return?
>
>
> --
> Adrian Klaver
> adrian(dot)klaver(at)aklaver(dot)com
>
--
*Nahum Castro González*
Blvd. Perdigón 214, Brisas del Lago.
CP 37207
León, Guanajuato, México
Tel (477)1950304
Cel (477)1274694
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Klaver | 2016-10-21 00:00:16 | Re: [psycopg] OT? plpython2u |
Previous Message | Adrian Klaver | 2016-10-20 19:55:21 | Re: OT? plpython2u |
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Klaver | 2016-10-21 00:00:16 | Re: [psycopg] OT? plpython2u |
Previous Message | Adrian Klaver | 2016-10-20 19:55:21 | Re: OT? plpython2u |