Re: [psycopg] OT? plpython2u

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

In response to

Responses

Browse pgsql-es-ayuda by date

  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

Browse psycopg by date

  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