Skip to content

Instantly share code, notes, and snippets.

View ppKrauss's full-sized avatar

Peter ppKrauss

57 followers · 2 following
View GitHub Profile
@ppKrauss
ppKrauss / .block
Last active September 26, 2019 00:45
compareCurves
license: mit
@ppKrauss
ppKrauss / .block
Last active October 28, 2019 14:18 — forked from ruliana/.block
Brazilian States Topojson (Estados do Brasil)
license: mit
height: 600
@ppKrauss
ppKrauss / .block
Last active October 29, 2019 23:19
Brazilian States: Albers vs Mercator projections
license: mit
height: 600
@ppKrauss
ppKrauss / pg_bitstring_benchmark.sql
Last active March 11, 2025 20:30
BitString vs ltree benchmark
-- for https://dba.stackexchange.com/q/345559/90651
------------------
CREATE EXTENSION IF NOT EXISTS ltree;
DROP SCHEMA IF EXISTS treetest CASCADE;
CREATE SCHEMA treetest;
CREATE FUNCTION treetest.hiddenBig_to_vBit(x bigint) RETURNS varbit AS $f$
SELECT substring( x_bin from 1+position(B'1' in x_bin) )