Skip to content

Instantly share code, notes, and snippets.

@bennettandrews
bennettandrews / tables.sql
Created November 25, 2017 15:52
biggest tables in postgres database
SELECT
relname AS "relation",
pg_size_pretty (
pg_total_relation_size (C .oid)
) AS "total_size"
FROM
pg_class C
LEFT JOIN pg_namespace N ON (N.oid = C .relnamespace)
WHERE
nspname NOT IN (
def value(DOTNO, OBJECTID):
if DOTNO is None or DOTNO == 0:
return OBJECTID
else:
return DOTNO

Keybase proof

I hereby claim:

  • I am bennettandrews on github.
  • I am bennettandrews (https://keybase.io/bennettandrews) on keybase.
  • I have a public key whose fingerprint is F49E 83F6 2A14 BF27 609F 9900 6783 9DC7 47F5 FCE3

To claim this, I am signing this object:

@bennettandrews
bennettandrews / number_station.sh
Created January 24, 2014 17:20
number station
#!/bin/bash
# http://en.wikipedia.org/wiki/Number_station
while [ 1 ]
do
cat /dev/urandom | base64 | tr -dc "[:alnum:]" | head -c$(($RANDOM % 100)) | say -v "Whisper"
sleep $(($RANDOM % 100))
done
package org.apache.http.examples.client;
import java.io.IOException;
import java.io.InputStream;
import org.apache.http.HttpEntity;
import org.apache.http.client.methods.CloseableHttpResponse;
import org.apache.http.client.methods.HttpGet;
import org.apache.http.impl.client.CloseableHttpClient;
/**
* The correlation between two vectors A, B is
* cov(A, B) / (stdDev(A) * stdDev(B))
*
* This is equivalent to
* [n * dotProduct(A, B) - sum(A) * sum(B)] /
* sqrt{ [n * norm(A)^2 - sum(A)^2] [n * norm(B)^2 - sum(B)^2] }
*/
def correlation(size : Double, dotProduct : Double, ratingSum : Double,
look do | cut -c -4 | say -r 200 -v 'Pipe Organ'
@bennettandrews
bennettandrews / gist:3079012
Created July 9, 2012 21:19
asyncbase + finagle
import com.stumbleupon.async.{Callback, Deferred}
import org.hbase.async._
import com.twitter.util.{Future, Promise, Return, Throw}
import java.util.ArrayList
import java.nio.ByteBuffer
object Main {
val client = new HBaseClient("127.0.0.1")
implicit def futureFromDeferred[A](d: Deferred[A]): Future[A] = {
@bennettandrews
bennettandrews / gist:3006312
Created June 27, 2012 19:41
RedisTracingFilter
private class RedisTracingFilter extends SimpleFilter[Command, Reply] {
override def apply(command: Command, service: Service[Command, Reply]) = Trace.unwind {
Trace.recordRpcname("redis", command.command)
Trace.record(Annotation.ClientSend())
service(command) map { response =>
Trace.record(Annotation.ClientRecv())
response
}
}
}
#!/bin/bash
while [ 1 ]
do
cat /dev/urandom | base64 | tr -dc "[:alnum:]" | head -c$(($RANDOM % 100)) | say -v "Whisper"
sleep $(($RANDOM % 100))
done