Skip to content

Instantly share code, notes, and snippets.

View milesjordan's full-sized avatar

Miles Jordan milesjordan

  • Melbourne, Victoria
View GitHub Profile

Keybase proof

I hereby claim:

  • I am milesjordan on github.
  • I am m_ (https://keybase.io/m_) on keybase.
  • I have a public key whose fingerprint is 90FB 4701 DFBC A7A2 CC83 74EE E4EA 4E17 CCC0 B5CA

To claim this, I am signing this object:

@milesjordan
milesjordan / Circular Average SQL
Last active February 20, 2019 16:31 — forked from hegge/avg_cyclic()
How to get the circular average of a dataset in different databases
These files show how to get the circular average (cyclic mean) of a dataset using SQL, for different databases.
For MySQL an example select statement is shown, and for Oracle and PostgreSQL the way to create a user aggregate function that computes the circular average is shown.
Props to Hegge for kicking this off: https://gist.github.com/hegge/476950
@milesjordan
milesjordan / vpc.yaml
Last active April 4, 2024 02:37
Cloudformation template for a VPC with ipv6, with public and private subnets, calculating the subnet ipv6 CIDR blocks on the fly.
---
AWSTemplateFormatVersion: '2010-09-09'
Description: Public VPC and subnets
Resources:
#
# Public VPC
#
PublicVpc: