Re: [Maria-discuss] quering images

2014-08-05 Thread Roberto Spadim
nice justin, i think it's a histogram analysis i'm thinking about a new index feature, like full text, but using mariadb, ideas are wellcome :) for example select * from table where image_match(table_image_blob_field,"some other image, maybe using base64","histogram")>50 or others functions, the

Re: [Maria-discuss] quering images

2014-08-05 Thread Justin Swanhart
Hi, I wrote software to do something like this a long time ago, when I worked at a usenet provider an we needed to track spam images. I broke each image down into smaller square images, and downsampled each to 8 bit, then calculated a "color average" of all the pixels in each sample. If one image

[Maria-discuss] quering images

2014-08-05 Thread Roberto Spadim
hi guys, does anyone know anything about querying images? for example, i have a database with images files (.jpg for example), and i have another image (for example my gmail picture), i want to search images similar or "near" to my image some points that i'm thinking about... images have many data