Skip to content

Instantly share code, notes, and snippets.

@marchelbling
marchelbling / 100-local-citus.sql
Last active July 5, 2023 15:47
Local Citus cluster setup — bis
-- user:
CREATE ROLE citus WITH NOSUPERUSER LOGIN IN ROLE pg_monitor;
-- database:
ALTER DATABASE citus SET citus.shard_replication_factor = 1;
ALTER DATABASE citus OWNER TO citus;
-- extensions:
CREATE EXTENSION IF NOT EXISTS "hll";
CREATE EXTENSION IF NOT EXISTS "topn";
@marchelbling
marchelbling / README.md
Last active April 1, 2022 06:35
C++ json writer

why?

This code implements a naive JSON writer in C++ complying with RFC 4627. I wrote this as I believe it is a very good example of a real life problem involving lots of C++ constructs. This sample only supports writing JSON and does not support heterogenous ‘object’ serialization and extension are left as an exercice. See Writing json in C++ for some details.

what?

  • json_stream: a std::ofstream wrapper fulfilling RFC 4627 constraints;
  • utf8_json: some code to decode/“json encode” std::string UTF-8 buffers
  • json_test.cpp: a very simple program testing the code
@marchelbling
marchelbling / README.md
Last active February 13, 2020 01:00
git hooks

Git hooks for better pivotal integration:

  • pre-commit:
    • prevents commiting on a branch that is not suffixed by an issue number. Some special branches (develop, master) and hotfixes are not constrained
    • lints modified python files and exits upon non correctly formatted modules
    • other formats (js, scss) have pending code that is not currently called as the workflow for front code is not clear
  • prepare-commit-msg: prepend issue number to commit message if it's missing and if it is set in the branch name (see pre-commit hook)
  • post-checkout: [optional] automatically update submodules when checkouting a branch (requires to define the AUTO_SUBMODULE_UPDATE environment variable)

For easy setup:

@marchelbling
marchelbling / local-citus.sh
Last active August 22, 2018 09:27
Local Citus cluster setup
#!/bin/bash
role=citus
database=citus
port=5432
workers=2
timeout=30
# start cluster with 2 workers
[ -f docker-compose.yml ] || wget https://raw.githubusercontent.com/citusdata/docker/master/docker-compose.yml
@marchelbling
marchelbling / gist:c8ef8a2dadbacf3587b292ad9dc1c408
Created January 23, 2018 11:08 — forked from lxneng/gist:741932
install PostgreSQL 9 in Mac OSX via Homebrew
install PostgreSQL 9 in Mac OSX via Homebrew
Mac OS X Snow Leopard
System Version: Mac OS X 10.6.5
Kernel Version: Darwin 10.5.0
Install notes for PostgreSQL 9.0.1 install using Homebrew:
sh-3.2# brew install postgresql
@marchelbling
marchelbling / delve.sh
Created January 22, 2018 17:27
install delve
#!/bin/bash
echo """[ req ]
default_bits = 2048 # RSA key size
encrypt_key = no # Protect private key
default_md = sha512 # MD to use
prompt = no # Prompt for DN
distinguished_name = codesign_dn # DN template
[ codesign_dn ]
commonName = "dlv-cert"
@marchelbling
marchelbling / XPS-15 9560 Getting Nvidia To Work on KDE Neon
Last active June 6, 2017 05:12 — forked from whizzzkid/XPS-15 9560 Getting Nvidia To Work on KDE Neon
Making Nvidia Drivers + CUDA 8 + Bumblebee work together on XPS 15 Early 2017 9560 kabylake.
1. disable secure boot
2. clean install windows (see https://www.reddit.com/r/Dell/comments/5qe3oh/how_to_fresh_install_on_xps_15_9560/)
2.1 in case usb does not show on boot: http://www.dell.com/support/article/us/en/19/SLN297060/xps-13-9343--how-to-install-ubuntu-developer-edition-1404-on-a-dell-pc-configured-for-the-unified-extensible-firmware-interface--uefi--bios?lang=EN
# Update kernel (is this mandatory?)
( mkdir /tmp/kernel-4.10.6
cd /tmp/kernel-4.10.6
wget http://kernel.ubuntu.com/~kernel-ppa/mainline/v4.10.6/linux-headers-4.10.6-041006_4.10.6-041006.201703260832_all.deb
wget http://kernel.ubuntu.com/~kernel-ppa/mainline/v4.10.6/linux-headers-4.10.6-041006-generic_4.10.6-041006.201703260832_amd64.deb
wget http://kernel.ubuntu.com/~kernel-ppa/mainline/v4.10.6/linux-image-4.10.6-041006-generic_4.10.6-041006.201703260832_amd64.deb
@marchelbling
marchelbling / Profiler
Last active April 11, 2017 07:23
Simple (intrusive) OSG profiler
#ifndef PROFILER
#define PROFILER
#include <map>
#include <string>
#include <utility>
#include <fstream>
#include <iomanip>
#include <osg/Timer>
@marchelbling
marchelbling / 3d.md
Last active February 24, 2016 09:45
3d companies
@marchelbling
marchelbling / debug_build.sh
Created September 25, 2013 13:23
script to build osg
#!/bin/bash
CXXFLAGS="-pipe" cmake ../ -DCMAKE_BUILD_TYPE=Debug -DCMAKE_OSX_ARCHITECTURES=x86_64 -DCMAKE_INSTALL_PREFIX=`pwd`/build -DCMAKE_DEBUG_POSTFIX='' -DBUILD_OSG_ANIMATIONTEST=NO -DOSG_WINDOWING_SYSTEM=Cocoa -DBUILD_OSG_EXAMPLES=NO -DwxWidgets_CONFIG_EXECUTABLE=wxWidgets_CONFIG_EXECUTABLE-NOTFOUND -DCMAKE_OSX_SYSROOT=/Applications/Xcode.app/Contents/Developer/Platforms/MacOSX.platform/Developer/SDKs/MacOSX10.7.sdk
make
source debug_env.sh