Skip to content

Instantly share code, notes, and snippets.

View jupiter's full-sized avatar

Pieter Raubenheimer jupiter

View GitHub Profile
import { Connection, DuckDB } from "node-duckdb";
const run = async () => {
const db = new DuckDB();
const connection = new Connection(db);
const result = await connection.executeIterator(
"SELECT * FROM read_csv_auto('data/yellow_tripdata_2019-01.csv')"
);
console.log(result.fetchRow());
};

Keybase proof

I hereby claim:

  • I am jupiter on github.
  • I am jupvic (https://keybase.io/jupvic) on keybase.
  • I have a public key ASDj3HnhiBLHLgrw1bBv-KOC9BAiI34caXIRSeKZkWiVFgo

To claim this, I am signing this object:

@jupiter
jupiter / auth_experiments.py
Created June 26, 2018 10:33
OpenTaxi Auth Experiment
import boto3
use_cognito_creds = True
my_opentaxi_id = 'my-verified-user-id'
cognito = boto3.client('cognito-identity')
token = cognito.get_open_id_token_for_developer_identity(
IdentityPoolId='eu-west-1:45190ad7-d66f-4e3f-abf1-010970283a1d',
Logins={
'open.taxi': my_opentaxi_id
@jupiter
jupiter / geo.py
Last active June 20, 2018 18:12
OpenTaxi Geo WIP
# See https://github.com/jupiter/open-taxi/blob/55017a22055eb9340e6d5b06dd916bf56becd4e1/src/opentaxi
import s2sphere
def get_cellid_at_level(latitude, longitude, level):
ll = s2sphere.LatLng.from_degrees(latitude, longitude)
cell = s2sphere.Cell.from_lat_lng(ll)
return cell.id().parent(level)
@jupiter
jupiter / OpenTaxi Topics.csv
Created June 18, 2018 21:21
Connecting Riders to Drivers
topic subscribers publishers
ot/replies/{client_id} {client_id} Anyone