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 main feature is create a nice index to speed this features, i don't know if this exist or could be created, just checking what we have before planning something new some links related that we could use to 'search images': histogram/template/feature match: http://docs.opencv.org/doc/tutorials/imgproc/histograms/template_matching/te... http://docs.opencv.org/doc/tutorials/imgproc/histograms/histogram_comparison... http://docs.opencv.org/doc/tutorials/features2d/feature_flann_matcher/featur... barcode: http://zbar.sourceforge.net/ exif (image meta data) http://pt.wikipedia.org/wiki/Exchangeable_image_file_format (exif information) and others algorithms, search faces, thumb, hands, eyes, etc 2014-08-05 17:34 GMT-03:00 Justin Swanhart <greenlion@gmail.com>:

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 matched enough samples to another image they were considered the same.

It didn't work for what i needed though, because it would find similar images (a person moved an arm, but everything else was the same for example). Unfortunately, I don't have the source available.

On Tue, Aug 5, 2014 at 11:40 AM, Roberto Spadim <roberto@spadim.com.br> wrote:

...

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, including meta data, maybe not only querying images (faces for example) but search a barcode or a ocr text, and many others features (i know some features when i worked with some opencv projects)

ideas and informations and experiences are wellcome :)

-- Roberto Spadim

_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp

-- Roberto Spadim SPAEmpresarial Eng. Automação e Controle