tokumine

-- To calculate flexible quantile ranges in postgresql, for example to calculate n equal 
-- frequency buckets for your data for use in a visualisation (such as binning for a 
-- choropleth map), you can use the following SQL:

-- this functions returns 6 equal frequency bucket ranges for my_column.
SELECT ntile, avg(my_column) AS avgAmount, max(my_column) AS maxAmount, min(my_column) AS minAmount 
FROM (SELECT my_column, ntile(6) OVER (ORDER BY my_column) AS ntile FROM my_table) x
GROUP BY ntile ORDER BY ntile

-- more on the ntile() function and windowing here: 

jstrachan

# thanks to this gist for the iTerm2 tab naming stuff: https://gist.github.com/phette23/5270658
# can't remember where I cribbed the rest of this from!
# hacked it a bit to work on OS X

_bold=$(tput bold)
_normal=$(tput sgr0)

__vcs_dir() {
	local vcs base_dir sub_dir ref
	sub_dir() {

probonopd

USB Device ID 1f3a:1000 Allwinner F1E200 electronic postcard

I received a promotional folder that plays a video with sound when opening the folder. This contains a rechargeable LiPo battery, a TFT display, a speaker, a power switch, a push button, 256 MB flash memory, RAM, and a CPU.

All of this for watching one 1-minute video.

What a waste! Certainly not environmentally friedndly. Until repurposed creatively!

On the back it says that the product can be sent back to the manufacturer for free recycling. Still I was wondering if I could do more with it.

ereli

CREATE SEQUENCE country_seq;

CREATE TABLE IF NOT EXISTS country (
  id int NOT NULL DEFAULT NEXTVAL ('country_seq'),
  iso char(2) NOT NULL,
  name varchar(80) NOT NULL,
  nicename varchar(80) NOT NULL,
  iso3 char(3) DEFAULT NULL,
  numcode smallint DEFAULT NULL,
  phonecode int NOT NULL,

rikka0w0

Mount a jffs2 image

http://wiki.emacinc.com/wiki/Mounting_JFFS2_Images_on_a_Linux_PC

#!/bin/bash

## Script to mount jffs2 filesystem using mtd kernel modules.
## EMAC, Inc. 2011

if [[ $# -lt 2 ]]
then