Skip to content

Instantly share code, notes, and snippets.

View dstainer's full-sized avatar

Derek Stainer dstainer

View GitHub Profile
@leonardofed
leonardofed / README.md
Last active October 23, 2025 11:18
A curated list of AWS resources to prepare for the AWS Certifications


A curated list of AWS resources to prepare for the AWS Certifications

A curated list of awesome AWS resources you need to prepare for the all 5 AWS Certifications. This gist will include: open source repos, blogs & blogposts, ebooks, PDF, whitepapers, video courses, free lecture, slides, sample test and many other resources.


@chanmix51
chanmix51 / orthodromic.sql
Last active July 19, 2018 23:08
Latitude, longitude and orthodromic distance in PgSQL
CREATE DOMAIN latlong AS point CHECK (VALUE[0] BETWEEN -90.0 AND 90.0 AND VALUE[1] BETWEEN -180 AND 180);
CREATE OR REPLACE FUNCTION orthodromic_distance(latlong, latlong) RETURNS float AS $_$
SELECT acos(
sin(radians($1[0]))
*
sin(radians($2[0]))
+
cos(radians($1[0]))
*