Skip to content

Instantly share code, notes, and snippets.

@ses4j
ses4j / load-ebird-data.sql
Created August 23, 2020 17:00
Load eBird data export into PostgreSQL
/*
This script will create a database called ebirddb with a table called ebird.
It will import the standard eBird export format file, as specified by `ebird_export_path` below into
the new table. Then it will create some indexes and geo points. Customize to suit.
*/
-- Set the desired tablespace, if you want, to put it on a drive with room. Skip this if desired.
SET default_tablespace = d_space;
\set ON_ERROR_STOP on
@ses4j
ses4j / fuelsdk-account.rb
Last active November 3, 2015 17:46
Example code for
# Sample database table to use to store ExactTarget credentials.
create_table "vestorly_marketing_cloud_accounts", force: :cascade do |t|
t.string "exacttarget_user_id", limit: 256, null: false
t.string "exacttarget_user_email", limit: 256
t.string "exacttarget_internal_oauth_token", limit: 512
t.string "exacttarget_oauth_token", limit: 512
t.string "exacttarget_refresh_token", limit: 512
t.datetime "exacttarget_token_expiration_date"
end
@ses4j
ses4j / format_human_readable_number.js
Last active August 29, 2015 14:07
Format javascript number as an actually-readable string
// Format javascript number as an actually-readable string
// using different d3.formats for different magnitudes.
// If it's NaN or otherwise not a number (ie a string), pass it through.
// For instance:
// 0.0000103 -> 10.3µ
// 0.000103 -> 0.000103
// 0.103 -> 0.103
// 10.34 -> 10.3
// 1034 -> 1,034
// 1034.1 -> 1,034.1
@ses4j
ses4j / incrementalmr.py
Created March 29, 2012 03:42
Periodically-updating pymongo/MongoDB incremental MapReduce example
def incremental_map_reduce(
map_f,
reduce_f,
db,
source_table_name,
target_table_name,
source_queued_date_field_name,
counter_table_name = "IncrementalMRCounters",
counter_key = None,
max_datetime = None,