Skip to content

Instantly share code, notes, and snippets.

View maximecolin's full-sized avatar

Maxime COLIN maximecolin

View GitHub Profile
CREATE OR REPLACE FUNCTION orthodromic_distance(point, point) RETURNS float AS $_$
SELECT acos(sin(radians($1[0])) * sin(radians($2[0])) + cos(radians($1[0])) * cos(radians($2[0])) * cos(radians($2[1]) - radians($1[1]))) * 6371.0;
$_$ LANGUAGE sql IMMUTABLE;
@maximecolin
maximecolin / gzip.conf
Last active September 9, 2015 08:29 — forked from Tom32i/gzip.conf
GZIP config for Nginx
##
# Gzip Settings
##
gzip on;
gzip_disable "msie6";
gzip_vary on;
gzip_proxied any;
gzip_min_length 256;
gzip_comp_level 6;
@maximecolin
maximecolin / photos.sh
Created December 21, 2015 19:14
Stop Apple Photos from Auto Launching in OS X with One Command
//Stop Apple Photos from Auto Launching in OS X with One Command
defaults -currentHost write com.apple.ImageCapture disableHotPlug -bool YES
defaults -currentHost write com.apple.ImageCapture disableHotPlug -bool NO
Verifying that +mcbinome is my blockchain ID. https://onename.com/mcbinome
/**
* Has join
*
* @param string $root
* @param string $relation
*
* @return bool
*/
@maximecolin
maximecolin / System.json
Created November 17, 2016 09:15
Grafana System Dashboard
{
"__inputs": [
{
"name": "DS_INFLUXDB",
"label": "influxdb",
"description": "",
"type": "datasource",
"pluginId": "influxdb",
"pluginName": "InfluxDB"
}
@maximecolin
maximecolin / System.json
Created November 17, 2016 09:15
Grafana System Dashboard
{
"__inputs": [
{
"name": "DS_INFLUXDB",
"label": "influxdb",
"description": "",
"type": "datasource",
"pluginId": "influxdb",
"pluginName": "InfluxDB"
}
@maximecolin
maximecolin / all.yml
Last active September 14, 2017 21:34
Telegraf + InfluxDB + Grafana ansible provisoning with manala.io
_env: prod
##############
# Apt Config #
##############
manala_apt_preferences:
- influxdb@influxdata
- telegraf@influxdata
- grafana@grafana
<?php
namespace App;
use Symfony\Bundle\FrameworkBundle\Kernel\MicroKernelTrait;
use Symfony\Component\Config\Definition\Builder\TreeBuilder;
use Symfony\Component\Config\Definition\ConfigurationInterface;
use Symfony\Component\Config\Loader\LoaderInterface;
use Symfony\Component\DependencyInjection\ContainerBuilder;
use Symfony\Component\DependencyInjection\Extension\ConfigurationExtensionInterface;
@maximecolin
maximecolin / graphql.php
Created June 12, 2018 10:05
GraphQL multiple mutation test
<?php
// Test this using following command
// php -S localhost:8080 ./graphql.php &
// curl http://localhost:8080 -d '{"query": "query { echo(message: \"Hello World\") }" }'
// curl http://localhost:8080 -d '{"query": "mutation { sum(x: 2, y: 2) }" }'
require_once __DIR__ . '/vendor/autoload.php';
use GraphQL\Type\Definition\ObjectType;
use GraphQL\Type\Definition\Type;
use GraphQL\Type\Schema;