Google Fusion Tables is a service for storing tabular data online. It has an API that allows you to make an SQL-like request for data from an online table, like the following: sql=SELECT * FROM 1906375 (clicking the link will…
Introduction to CORS CORS (Cross Origin Resource Sharing) is a mechanism specifies by W3C (draft), for allowing browsers to make cross origin requests for resources on other domains under certain conditions. It’s related to JSONP because it solves a similar…
Place each word on a separate line with sed and awk: sed -e ‘s/[^[:alpha:]]/ /g’ | awk ‘{ for (i=1;i
I read somewhere that if you take a list of words reverse the letters in each word sort the (reversed) words alphabetically then reverse the words back to normal
I keep forgetting how to do this. How to group on a date column (date_col in the example) in Oracle: SELECT count(*) FROM table GROUP ON TO_CHAR(date_col, ‘DD-MON-YYYY HH:MI:SS’) For other format strings than ‘DD-MON-YYYY HH:MI:SS’ see this page.
In this example I had a big log file (many million lines), that I wanted to split into smaller logfiles (each one million lines) for processing on Elastic MapReduce. -rw-r–r– 1 kostas staff 543067012012 Oct 11 13:45 huge_logfile This is…
Completely off topic. Just a thought, is this what China will look like in a few years? A country of old people, governed by the children of the one-child policy era… Wonder how that will affect the current financial situation…
Previous effort In a previous post I tried generating OpenStreetMap tiles using GeoServer. It ended when I couldn’t find a good style (SLD) to apply the OSM layer. The (new) idea, that also failed miserably In this post I tried…
There is a good little tool called s3funnel on GitHub for this. I used easy_install to install on my Mac. easy_install s3funnel
E.g. to select rows with a timestamp on minutes 0, 5, 10, …, 55 select * from t where mod(to_number(to_char(date_time_col, ‘mi’)),5)=0