Wednesday, September 30, 2015

Detecting duplicate images

https://www.reddit.com/r/Python/comments/3ndsj8/what_is_my_best_bet_for_detecting_duplicate/


http://blog.iconfinder.com/detecting-duplicate-images-using-python/

https://realpython.com/blog/python/fingerprinting-images-for-near-duplicate-detection/

http://www.hackerfactor.com/blog/index.php?/archives/432-Looks-Like-It.html
http://www.hackerfactor.com/blog/index.php?/archives/529-Kind-of-Like-That.html

http://blockhash.io/
http://www.pureftpd.org/project/libpuzzle
https://github.com/jedisct1/libpuzzle

https://www.safaribooksonline.com/blog/2013/11/26/image-hashing-with-python/

https://github.com/hszcg/pHash-0.9.6
https://github.com/polachok/py-phash

https://www.reddit.com/r/programming/comments/hql8b/looks_like_it_for_the_last_few_months_i_have_had/


Md5 file hashing:  http://pythoncentral.io/hashing-files-with-python/
Mysql in Python:
https://www.linode.com/docs/databases/mysql/how-to-install-mysql-on-ubuntu-14-04
http://stackoverflow.com/questions/19101243/error-1130-hy000-host-is-not-allowed-to-connect-to-this-mysql-server
http://stackoverflow.com/questions/7459766/installing-mysql-python
http://ianhowson.com/a-quick-guide-to-using-mysql-in-python.html

Optimize Mysql
http://mysqltuner.com/
https://rtcamp.com/tutorials/mysql/mysqltuner/
http://stackoverflow.com/questions/18468600/how-to-run-optimize-table-with-the-least-downtime

http://www.rndblog.com/how-to-select-random-rows-in-mysql/

https://www.digitalocean.com/community/tutorials/how-to-optimize-queries-and-tables-in-mysql-and-mariadb-on-a-vps

https://www.percona.com/blog/2013/09/20/innodb-performance-optimization-basics-updated/


Triggering a shell script from MySQL

https://patternbuffer.wordpress.com/2012/09/14/triggering-shell-script-from-mysql/
http://stackoverflow.com/questions/23382499/run-python-script-on-database-event


3 Ways to Make Tab Delimited Files from Your MySQL Table
http://spin.atomicobject.com/2011/05/28/3-ways-to-make-tab-delimited-files-from-your-mysql-table/

14 comments:

  1. http://stackoverflow.com/questions/7005765/implementing-a-k-d-tree-for-nearest-neighbor-search-in-mysql

    ReplyDelete
  2. https://blogs.bing.com/search-quality-insights/2013/11/22/deep-learning-for-image-understanding-in-bing/

    ReplyDelete
  3. http://stackoverflow.com/questions/84421/converting-an-integer-to-a-hexadecimal-string-in-ruby

    ReplyDelete
  4. https://www.amberbit.com/blog/2013/12/20/similar-images-detection-in-ruby-with-phash/

    ReplyDelete
  5. Similar image search by pHash distance in Elasticsearch
    http://stackoverflow.com/questions/32785803/similar-image-search-by-phash-distance-in-elasticsearch

    ReplyDelete
  6. Alternative to Fuzzy Search for pHash
    https://discuss.elastic.co/t/alternative-to-fuzzy-search-for-phash/30075/6

    ReplyDelete
  7. http://cloudinary.com/blog/how_to_automatically_identify_similar_images_using_phash

    ReplyDelete
  8. http://www.mysqlperformancetuning.com/how-to-speed-up-mysql-by-optimization

    ReplyDelete
  9. https://www.percona.com/blog/2015/04/27/indexing-101-optimizing-mysql-queries-on-a-single-table/

    ReplyDelete
  10. https://www.quora.com/What-is-the-best-way-to-limit-a-MySQL-query-on-a-large-table-to-optimize-execution-speed

    ReplyDelete
  11. Approximate Nearest Neighbor ANN
    http://www.cs.ubc.ca/research/flann/

    ReplyDelete
  12. Comparing algorithms:

    http://littlesvr.ca/grumble/2015/04/27/perceptual-hash-comparison-phash-vs-blockhash-false-positives/

    https://github.com/moravianlibrary/imagesearch.mzk.cz/issues/6

    https://hosunghwang.wordpress.com/2015/03/12/perceptual-hash/

    ReplyDelete
    Replies
    1. https://hosunghwang.wordpress.com/2015/06/11/mh-hash-mvp-tree-indexersearcher-for-mysqlphp/

      Delete
  13. Tutorial: http://bertolami.com/index.php?engine=blog&content=posts&detail=perceptual-hashing

    ReplyDelete