Suggestions how to resize/compress images to be stored in a DB?
Powerbuilder 11.5.1 application running on SQL Anywhere 11 DB
We are investigating possibilities to store images relating to rows in our table, we will probably do it as suggested, using Long Binary data type.
However, what would be really neat is if we had a way of resizing (cropping if needed) each image to a specific width / height in pixels, and also, just in case that these images were taken with a very large resolution, compress them down (photo quality not that important) to, say, 200kb-300kb at most. This would have to be done at the powerbuilder application level, when the user selects the image(s) to store.
Any ideas or guides on what is the best way to achieve this? There doesn't seem to be anything native in the libraries, does anyone know of any PB tools written that could accomplish this?