Magic words:
psql -U postgres
If 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> |