Skip to content

Instantly share code, notes, and snippets.

View bertt's full-sized avatar

Bert Temme bertt

View GitHub Profile
@bertt
bertt / gist:4446f3b6d75007305f6d07024e721bf7
Created June 28, 2016 12:43
Sample spatial queries in PostGIS using SRID and GeoJSON
// create table with srid=4326
CREATE TABLE testbert1
(
id bigserial NOT NULL,
description character varying(500),
encodingtype integer,
location public.geometry(geometry,4326)
)
// insert geometry
@bertt
bertt / ApacheKafkahelloWorld.txt
Last active November 7, 2016 19:34
Apache Kafka Hello World
Apache Kafka hello World
1] Zookeeper
docker run -d -p 2181:2181 --name zookeeper jplock/zookeeper
2] Kafka
docker run -d --name kafka --link zookeeper:zookeeper ches/kafka
3] Create Consumer:
docker run -t -i --rm geertvb/kafkacat kafkacat -C -b 172.17.0.3:9092 -t testtopic
4] Create Producer:
docker run -t -i --rm geertvb/kafkacat kafkacat -P -b 172.17.0.3:9092 -t testtopic
tip: use Python 2.7 (not 3.5) and the right bit version (64) otherwise
things will go wrong
1] Install
linux:
sudo apt-get install libgeos-dev
pip install shapely
sudo -H pip install quantized-mesh-tile
mac:
How to enable NuGet package publishing on AppVeyor
1] Create nuspec file next to .csproj file in GitHub (same name)
2] Enable NuGet packaging
AppVeyor -> settings- > Build -> MsBuild -> Automatic packaging -> check 'Package NuGet projects'
3] Add NuGet Api key
AppVeyor -> settings -> deployment -> deployment provider -> select NuGet -> Api Key -> fill in your NuGet api key
Optional: secure api key with https://ci.appveyor.com/tools/encrypt
4] Add version number patching
AppVeyor -> settings -> General -> AssemblyInfo patching -> Check 'On'
"use strict"
let UA_KEY = 'your_Universal_analytics_key (starts with UA)'
var ua = require('universal-analytics');
let visitor = ua(UA_KEY);
let value= 35;
visitor.event('sensor 1', value,function (err){
if (err) return console.log("error:" + err);
console.log('Sent event to GA', 'Gesture', value);
@bertt
bertt / gist:39775ec987f3a3a62481904baf111ff2
Created June 29, 2017 07:30
Aliases for developing on WSL
alias dev='cd /mnt/d/dev/github.com'
alias godev='cd /mnt/d/dev/go/src/github.com'
@bertt
bertt / gist:c35ef7852374c1e58905c70a526258f7
Created July 6, 2017 07:12
Install golang 1.8.3 on Raspberry Pi
wget https://storage.googleapis.com/golang/go1.8.3.linux-armv6l.tar.gz
sudo tar -C /usr/local -xzf go1.8.3.linux-armv6l.tar.gz
export PATH=$PATH:/usr/local/go/bin
api tdf2017
// teams
http://fep-api.dimensiondata.com/v2/teams
// riders (race=19)
http://fep-api.dimensiondata.com/v2/rider/v2/19
// stages
http://fep-api.dimensiondata.com/v2/race/19/stages
@bertt
bertt / connection.cs
Last active September 15, 2017 07:53 — forked from glennc/connection.cs
SignalRAnnouncement
var connection = new HubConnectionBuilder()
.WithUrl("http://localhost:5000/chat")
.WithConsoleLogger()
.Build();
connection.On<string>("Send", data =>
{
Console.WriteLine($"Received: {data}");
});
package main
import (
"fmt"
"net/http"
"sort"
"strings"
)
func handler(w http.ResponseWriter, r *http.Request) {