photo manipulation in Studio 6.1 and/or Postgres
jim at jpcr.com
Wed Feb 15 10:18:19 EST 2017
Thought I'd follow up - I've purchased Kelly's ImageMagicker external, which will allow me to do the following:
1) Write a one-time Omnis routine to loop through and reduce the size of all too-large images currently in the database.
2) Automatically reduce the size of too-large images before they are inserted to the database.
>I'm storing some photos as binary data in a Postgres database. The
>column is defined as a PICTURE in the Omnis schema, and the user inserts/
>updates by pasting a photo into a picture field (kPictureObject) in an
>Omnis window. I can check the size of the pasted picture with the
>binlength() function and not do an insert or update if the image is too large.
>My immediate problem: I haven't been checking the size up till now, and
>there are about 500 photos already in the database that are really big
>(8mb or so). Is there a way in Omnis (or with some other tool) that I
>can fetch an image, reduce its size, and then update postgres?
>Thanks from snowy New England,
>JP Computer Resources
>Manage your list subscriptions at http://lists.omnis-dev.com
JP Computer Resources
More information about the omnisdev-en