Peter 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) )

ppKrauss / .block

Last active October 29, 2019 23:19

Brazilian States: Albers vs Mercator projections

	license: mit
	height: 600

ppKrauss / .block

Last active October 28, 2019 14:18 — forked from ruliana/.block

Brazilian States Topojson (Estados do Brasil)

	license: mit
	height: 600

ppKrauss / .block

Last active September 26, 2019 00:45

compareCurves

license: mit

ppKrauss / .block

Last active September 28, 2019 18:28

OLD TEST on sp-fill curves

license: mit

ppKrauss / index.html

Created July 5, 2019 19:52

Simple chart with C3 - in 5 minutes! // source https://jsbin.com/seriyih

	<!DOCTYPE html>
	<html>
	<head>
	<meta name="description" content="showing C3js bug">
	<meta charset="utf-8">
	<title>Simple chart with C3 - in 5 minutes! </title>

	<!-- Here are all the javascripts and css that you need, you can download them or linked them like here -->
	<script type="text/javascript" src="http://cdnjs.cloudflare.com/ajax/libs/d3/5.9.7/d3.min.js"></script>
	<script type="text/javascript" src="http://cdnjs.cloudflare.com/ajax/libs/c3/0.7.1/c3.js"></script>

ppKrauss / index.html

Created July 5, 2019 18:59

Simple chart with C3 - in 5 minutes! // source https://jsbin.com/seriyih

	<!DOCTYPE html>
	<html>
	<head>
	<meta charset="utf-8">
	<title>Simple chart with C3 - in 5 minutes! </title>

	<!-- Here are all the javascripts and css that you need, you can download them or linked them like here -->
	<script type="text/javascript" src="http://cdnjs.cloudflare.com/ajax/libs/d3/5.9.7/d3.min.js"></script>
	<script type="text/javascript" src="http://cdnjs.cloudflare.com/ajax/libs/c3/0.7.1/c3.js"></script>
	<link href="http://cdnjs.cloudflare.com/ajax/libs/c3/0.7.1/c3.css" rel="stylesheet" type="text/css">

ppKrauss / jsonb_object_summable.sql

Created August 16, 2018 07:34

Tool-kit for JSONb key-number objects

	/**
	* object_summable and "Merge sum" functions are for JSONb key-number objects,
	* most usually key-integer for counting, like json-bags.
	* They are "key counters", so, to merge two keys, the intValues must be added.
	* Change the core of jsonb_merge_sum(jsonb,jsonb) to the correct datatype.
	* The JSON "number" is equivalent to the SQL's ::numeric.
	* Any invalid or empty JSONb object will be represented as SQL NULL.
	*/

	CREATE or replace FUNCTION jsonb_is_summable(jsonb) RETURNS boolean AS $f$

ppKrauss / mod-jsonrpc.sql

Created December 30, 2017 14:41

JSON-RPC interface for PostgreSQL 9+ JSONb frameworks

	/**
	* JSON-RPC interface. Mini-lib, independent.
	* Works fine with REST.
	* See http://www.jsonrpc.org/specification (only error/code convention have little change)
	* Free error string code:
	* "$integer" = "$integer.0" = HTTP status code (only REST)
	* "$integer.$integer" = status and internal error code (DEFAULT)
	* use function rpc.errcode_merge() to merge default error reference and add internal part.
	*/

ppKrauss / benchmark_base.php

Last active August 29, 2015 14:04

Simple benchmark-base for use in any simple benchmarking task

	<?php
	/**
	* Simple benchmark-base for use in any simple benchmarking task.
	* Use at terminal as $php benchmark_base.php
	* For more complex or memory usage, see
	* http://php.net/manual/en/ref.xhprof.php
	* http://php.net/manual/en/function.set-time-limit.php
	* http://php.net/manual/en/features.gc.performance-considerations.php
	* From https://gist.github.com/ppKrauss/4cd3c9a5f7cec89be68e
	*/