[Maria-developers] RFC getting information from image (blob)
![](https://secure.gravatar.com/avatar/33fb5c08359d9d82c9358b7775aab4b9.jpg?s=120&d=mm&r=g)
Hi guys, i will implement a gis system, but my problem isn't gis, my problem is raster (bitmap) images I will save images at mariadb using longblobs And i will create a table with, datetime and image I will need read each r,g,b value from each pixel, example.. Select rvalue(1,2,loadimage(blobfield))
From table Order by datetime
Rvalue= red value of x1 and y2 What's the faster or at least, how to use less cpu and memory I didn't search about images udf functions for mysql Any help is wellcome and ideas too :) Well i will use others sum, max, min functions too I don't want to read all images at client side, i want that server do this job I don't know the image size (it can be any pratical size, max near to 16mega pixels), image format could be png, jpg, or another one but i can use client side to rewrite image file to right format I'm considering implement some imagemagick functions inside mariadb, what you think? Thanks guys
![](https://secure.gravatar.com/avatar/f8dadb41fe4fb69f346c61d4c352f0ab.jpg?s=120&d=mm&r=g)
On 07/21/2013 04:24 AM, Roberto Spadim wrote:
Hi guys, i will implement a gis system, but my problem isn't gis, my problem is raster (bitmap) images I will save images at mariadb using longblobs And i will create a table with, datetime and image I will need read each r,g,b value from each pixel, example..
i sort of hate to say this on this list, but ... have you checked the new raster data features of PostGIS 2.0? I'm not sure whether they provide exactly what you are looking for, but from the little i heard about this new PostGIS feature i think it may be more suitable for your task, or at least worth a closer look ... -- hartmut
![](https://secure.gravatar.com/avatar/33fb5c08359d9d82c9358b7775aab4b9.jpg?s=120&d=mm&r=g)
thanks hartmut! i'm reading the postgis now, any idea if mysql or mariadb will extend gis support?
participants (2)
-
Hartmut Holzgraefe
-
Roberto Spadim