← Back to team overview

maria-discuss team mailing list archive

Re: quering images


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:


exif (image meta data)
http://pt.wikipedia.org/wiki/Exchangeable_image_file_format (exif

and others algorithms, search faces, thumb, hands, eyes, etc

2014-08-05 17:34 GMT-03:00 Justin Swanhart <greenlion@xxxxxxxxx>:

> 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@xxxxxxxxxxxxx>
> 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@xxxxxxxxxxxxxxxxxxx
>> Unsubscribe : https://launchpad.net/~maria-discuss
>> More help   : https://help.launchpad.net/ListHelp

Roberto Spadim
Eng. Automação e Controle