Andrew W. Hill andrewxhill

## AXH_Vector_Sum.sql
CREATE AGGREGATE vector_sum (
    sfunc = AXH_Vector_Sum,
    basetype = int[],
    stype = int[],
    initcond = '{0}'
);

DROP FUNCTION IF EXISTS AXH_Vector_Sum(int[], int[]);
CREATE OR REPLACE FUNCTION AXH_Vector_Sum(int[], int[])
    RETURNS int[] AS $$

## slack-pointers.md

      
              1 file
            
          
              1 fork
            
          
              0 comments
            
          
              3 stars
            
          
                andrewxhill
                / slack-pointers.md
            
            
              Last active
              November 19, 2020 12:40
            
          
    On chatting to people

Chat is not the same as conversation. When you tag someone using the "@" or if you send them a direct message, you may be directly forcing them to change their focus to your problem. While this is good for you, it can be bad for a healthy and productive community. Here are a couple of rules to abide.

Only "@" tag people's names in the following cases.

Your comment is urgent/time-sensitive and you need the help of the "@" target. What is urgent? You are running a production application with 100s of users facing a broken API, it's urgent. You are experimenting or taking part in a competition and want an answer quickly, it's not urgent.
Your comment has grown stale and you still need an answer that the "@" target can provide. What is stale? In most cases, more than 2 days seems reasonable or if it's a weekend, 3 or more.
You comment is in a channel or thread where the "@" target is not present but you need them aware.


Abide by the "no hello" rule at all times. Provide


## README.md

      
              3 files
            
          
              3 forks
            
          
              4 comments
            
          
              8 stars
            
          
                andrewxhill
                / README.md
            
            
              Last active
              September 18, 2020 18:53
            
              
                How to fully customize infowindows in CartoDB
              
          
    Advanced Infowindow Design

Getting Started

In this section, we will show you the advanced methods for controlling infowindows styles using the CartoDB interface. These skills will allow you to have highly customized infowindows for your published maps, created directly on your account. You don't need any programming skills to edit infowindows and you can see a tutorial of basic methods here. This section is about advanced methods and you will be required to use basic skills in HTML and later CSS.
Editing Infowindow HTML

CartoDB gives you direct access to the HTML that controls the layout of your infowindows. If you don't feel ready to edit HTML and CSS see the tutorial of basic methods. In CartoDB you can find the advanced editor by selecting the Infowindow Wizard and then clicking the small code tag in the upper right.

  
## cdb_latlng.sql
--
-- Create a valid GEOMETRY in 4326 from a lat/lng pair
--
-- @param lat A numeric latitude value.
--
-- @param lng A numeric longitude value.
--
--

CREATE OR REPLACE FUNCTION CDB_LatLng (lat NUMERIC, lng NUMERIC) RETURNS geometry as $$

## index.html
<!DOCTYPE html>
<html lang="en">
  <head>
    <meta charset="utf-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0, shrink-to-fit=no">
    <meta name="description" content="Template cloned from https://github.com/erengy/under-construction.">
    <title>textile.io</title>
    <style type="text/css">
      html, body {
        height: 100%;

## pseudo-bucket-example.ts

/**
 * Buckets
 *
 * You can now create Buckets for your User.
 * Bucket contain raw files and documents.
 */
const buckets = new Buckets(db.context);

const roots = await buckets.list();

## Powergate-Demo.md

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              2 stars
            
          
                andrewxhill
                / Powergate-Demo.md
            
            
              Last active
              March 25, 2020 19:08
            
          
    Powergate Show & Tell

Objective:

Create drop-in Filecoin API Management tools for systems and apps.
Key components:


Reputation Indices: A collection of data collected from the network for miner selection. Includes miner activity duration, slashing events, and deals.


## index.html
<!doctype><html><head>
  <meta charset="utf-8">
  <meta http-equiv="X-UA-Compatible" content="IE=edge">
  <title>Odyssey.js Slides</title>
  <meta name="description" content="">
  <meta name="viewport" content="width=device-width, initial-scale=1.0">

  <link rel="icon" type="image/x-icon" href="http://cartodb.github.io/odyssey.js/sandbox/favicon.png">
  <link rel="icon" type="image/png" href="http://cartodb.github.io/odyssey.js/sandbox/favicon.png">

## README.md

      
              6 files
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                andrewxhill
                / README.md
            
            
              Last active
              June 11, 2019 18:52
            
          
    Setup a new game of cmd-line tag!

Create a new game

sh new-game.sh 
sh new-game.sh "Game 1"

  
## cloudflare-ipfs-update.sh
#!/bin/bash
set -e # abort on any error

HASH=${1?param missing - hash.}

echo "Hi $PAGES_CLOUDFLARE_EMAIL"
if [[ -z "${PAGES_CLOUDFLARE_API_KEY}" ]]; then
    echo "See setup instructions to set PAGES_CLOUDFLARE_API_KEY"
    exit 1
fi
	CREATE AGGREGATE vector_sum (
	sfunc = AXH_Vector_Sum,
	basetype = int[],
	stype = int[],
	initcond = '{0}'
	);

	DROP FUNCTION IF EXISTS AXH_Vector_Sum(int[], int[]);
	CREATE OR REPLACE FUNCTION AXH_Vector_Sum(int[], int[])
	RETURNS int[] AS $$
	--
	-- Create a valid GEOMETRY in 4326 from a lat/lng pair
	--
	-- @param lat A numeric latitude value.
	--
	-- @param lng A numeric longitude value.
	--
	--

	CREATE OR REPLACE FUNCTION CDB_LatLng (lat NUMERIC, lng NUMERIC) RETURNS geometry as $$
	<!DOCTYPE html>
	<html lang="en">
	<head>
	<meta charset="utf-8">
	<meta name="viewport" content="width=device-width, initial-scale=1.0, shrink-to-fit=no">
	<meta name="description" content="Template cloned from https://github.com/erengy/under-construction.">
	<title>textile.io</title>
	<style type="text/css">
	html, body {
	height: 100%;

	/**
	* Buckets
	*
	* You can now create Buckets for your User.
	* Bucket contain raw files and documents.
	*/
	const buckets = new Buckets(db.context);

	const roots = await buckets.list();
	<!doctype><html><head>
	<meta charset="utf-8">
	<meta http-equiv="X-UA-Compatible" content="IE=edge">
	<title>Odyssey.js Slides</title>
	<meta name="description" content="">
	<meta name="viewport" content="width=device-width, initial-scale=1.0">

	<link rel="icon" type="image/x-icon" href="http://cartodb.github.io/odyssey.js/sandbox/favicon.png">
	<link rel="icon" type="image/png" href="http://cartodb.github.io/odyssey.js/sandbox/favicon.png">
	#!/bin/bash
	set -e # abort on any error

	HASH=${1?param missing - hash.}

	echo "Hi $PAGES_CLOUDFLARE_EMAIL"
	if [[ -z "${PAGES_CLOUDFLARE_API_KEY}" ]]; then
	echo "See setup instructions to set PAGES_CLOUDFLARE_API_KEY"
	exit 1
	fi