Magic words:
psql -U postgresIf run with -E flag, it will describe the underlaying queries of the \ commands (cool for learning!).
Most \d commands support additional param of __schema__.name__ and accept wildcards like *.*
| ### Keybase proof | |
| I hereby claim: | |
| * I am herrbuerger on github. | |
| * I am herrbuerger (https://keybase.io/herrbuerger) on keybase. | |
| * I have a public key ASDehSwsfC_aKN2WUeEHyWdANSMW8ppk7RjIDs8tFXekTQo | |
| To claim this, I am signing this object: |
| #include <Python.h> | |
| #include <numpy/arrayobject.h> | |
| #include "euclidean.h" | |
| /* Docstrings */ | |
| static char module_docstring[] = | |
| "This module provides an interface for calculating squared euclidean distance"; | |
| static char euclidean_docstring[] = | |
| "Calculate the squared euclidean distance of two 128-dimensional vectors"; | |
| from annoy import AnnoyIndex | |
| a = AnnoyIndex(3) | |
| a.add_item(10, [1, 0, 0]) | |
| a.add_item(11, [0, 1, 0]) | |
| a.add_item(13, [0, 0, 1]) | |
| a.build(-1) | |
| print a.get_nns_by_item(13, 10) | |
| print a.get_nns_by_item(1, 10) |
| from annoy import AnnoyIndex | |
| index = AnnoyIndex(1) | |
| for x in range(10000): | |
| id = "%d000%d" % (x,x) | |
| index.add_item(int(id),[x]) |
| 48000693 | |
| 49000693 | |
| 50000693 | |
| 51000693 | |
| 52000693 | |
| 53000693 | |
| 54000693 | |
| 55000693 | |
| 56000693 | |
| 57000693 |
This is a very basic method to do rotating snapshots for Elasticsearch. For this to work you will need to have jq installed (http://stedolan.github.io/jq/).
PLEASE, PLEASE, PLEASE don't put this blindly in your commandline and execute it :)
curl -s -S -XGET "localhost:9200/_snapshot/my_s3_repository/_all?pretty=true" | jq '.snapshots[] | .snapshot + " " + .end_time' | sed 's/^.\(.*\).$/\1/' | sort -k 2 -r | awk '{ if (NR > 1) { system("curl -XDELETE " "localhost:9200/_snapshot/my_s3_repository/"$1) } } END { system("curl -XPUT " "localhost:9200/_snapshot/my_s3_repository/`date +\%s`") }'
| from math import sqrt | |
| def confidence(ups, downs): | |
| n = ups + downs | |
| if n == 0: | |
| return 0 | |
| z = 1.96 #1.96 = 95% | |
| phat = float(ups) / n |
| ➜ sample imagedups . --search -f 92bc12786d430083be1e166a2174b4888ba0b4ba.jpg | |
| 92bc12786d430083be1e166a2174b4888ba0b4ba.jpg | |
| Traceback (most recent call last): | |
| File "/usr/local/bin/imagedups", line 228, in <module> | |
| prog.main() | |
| File "/usr/local/bin/imagedups", line 60, in main | |
| self.cmd_search() | |
| File "/usr/local/bin/imagedups", line 90, in cmd_search | |
| self.compare_with_db(hashdb, self.args.samplefile) | |
| File "/usr/local/bin/imagedups", line 193, in compare_with_db |
| <context-param> | |
| <param-name>net.myrrix.web.InitListener.USER_NAME</param-name> | |
| <param-value>admin</param-value> | |
| </context-param> | |
| <context-param> | |
| <param-name>net.myrrix.web.InitListener.PASSWORD</param-name> | |
| <param-value>password</param-value> | |
| </context-param> |