Re: [psycopg] OT? plpython2u

As far as I know the process to resize the image is:

read(bytea) -> load_to_memory(image) -> resize(image) ->
recode_to_bytea(image) -> store(bytea)

You helped me with the first two.

When I run the function ajustar(image)
update personal set image=ajustar(image)

I tried to do a direct resizing from bytea but python can't understand the
hexadecimal data from bytea as an jpeg image. Though I tried with with
plpython2u.
Thanks

2016-10-20 19:00 GMT-05:00 Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>:

> On 10/20/2016 04:51 PM, Nahum Castro wrote:
>
>> Hello Adrian.
>>
>> The result image to replace the big one.
>>
>
> So if you are replacing the data in a bytea column with a function that
> returns bytea, why encode it?
>
> Unless I am missing something why not just UPDATE with the raw(bytea)
> return value?
>
>
>> 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
>> <mailto: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 <mailto: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
>>
>
>
> --
> 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