p3t3r67x0’s gists

p3t3r67x0 / setup_pgrouting.md

Created August 9, 2024 11:26

Install pgrouting2 on Ubuntu

sudo apt install osm2pgrouting
sudo apt install cmake g++ libboost-graph-dev
sudo apt install postgresql-16 postgresql-16-postgis postgresql-server-dev-16
sudo apt install postgresql-10-pgtap
sudo apt install sphinx-common
sudo apt install bzip2
wget -O pgrouting-3.0.6.tar.gz https://github.com/pgRouting/pgrouting/archive/v3.0.6.tar.gz

p3t3r67x0 / profiles.conf

Created October 5, 2023 09:46

dconf dump /org/gnome/terminal/legacy/profiles:/

	[/]
	audible-bell=false
	background-color='rgb(0,43,54)'
	background-transparency-percent=3
	default-size-columns=300
	default-size-rows=79
	font='MesloLGS NF 15'
	foreground-color='rgb(131,148,150)'
	palette=['rgb(7,54,66)', 'rgb(220,50,47)', 'rgb(251,117,117)', 'rgb(181,137,0)', 'rgb(54,143,205)', 'rgb(211,54,130)', 'rgb(42,161,152)', 'rgb(238,232,213)', 'rgb(0,43,54)', 'rgb(181,231,208)', 'rgb(229,77,43)', 'rgb(101,123,131)', 'rgb(131,148,150)', 'rgb(108,113,196)', 'rgb(147,161,161)', 'rgb(253,246,227)']
	scroll-on-keystroke=true

p3t3r67x0 / .vimrc

Created October 5, 2023 09:40

	call plug#begin()
	Plug 'https://github.com/junegunn/vim-plug.git'
	call plug#end()

	set backupcopy=yes

	" Don't try to be vi compatible
	set nocompatible

	" Helps force plugins to load correctly when it is turned back on below

p3t3r67x0 / .p10k.zsh

Created October 5, 2023 09:38

	# Generated by Powerlevel10k configuration wizard on 2023-10-05 at 11:27 CEST.
	# Based on romkatv/powerlevel10k/config/p10k-rainbow.zsh, checksum 42599.
	# Wizard options: nerdfont-complete + powerline, small icons, rainbow, unicode,
	# angled separators, sharp heads, round tails, 1 line, compact, many icons, concise,
	# instant_prompt=verbose.
	# Type `p10k configure` to generate another config.
	#
	# Config for Powerlevel10k with powerline prompt style with colorful background.
	# Type `p10k configure` to generate your own config based on it.
	#

p3t3r67x0 / unfallorte_bezeichnungen.sql

Created March 18, 2023 20:10

	DROP TABLE IF EXISTS uland;

	CREATE TABLE uland (
	id UUID DEFAULT gen_random_uuid() PRIMARY KEY,
	uland NUMERIC NOT NULL,
	name VARCHAR(255) NOT NULL
	);

	DROP TABLE IF EXISTS umonat;

p3t3r67x0 / schulen_flensburg.json

Created March 1, 2023 16:45

	[{
	"registrationnumber": "0702020",
	"schoolname": "Schule auf der Rude",
	"principal": "Frau Saar",
	"phone": "0461/852556",
	"fax": "0461/851642",
	"email": "schule-auf-der-rude.flensburg@schule.landsh.de",
	"website": "http://www.schule-auf-der-rude.lernnetz.de",
	"address": "Lundweg 30",
	"postalcode": "24941",

p3t3r67x0 / rewe_discounter_details.json

Created March 31, 2021 18:34

List of probably all german listed REWE discounters with address data as well as contact data.

This file has been truncated, but you can view the full file.

p3t3r67x0 / vue_tailwindcss_candar.vue

Created October 13, 2020 11:23

Simple Vue Tailwindcss Calendar with Modal

	<template>
	<div>
	<div class="bg-white rounded shadow overflow-hidden">
	<div class="flex items-center justify-between py-2 px-6">
	<div>
	<span class="text-lg font-bold text-gray-800">{{ monthNames[month] }}</span>
	<span class="ml-1 text-lg text-gray-600 font-normal">{{ year }}</span>
	</div>
	<div class="border rounded-lg px-1" style="padding-top: 2px;">
	<button type="button" class="leading-none rounded-lg transition ease-in-out duration-100 inline-flex cursor-pointer hover:bg-gray-200 p-1 items-center" :class="{'cursor-not-allowed opacity-25': month == 0 }"

p3t3r67x0 / create_index_cuchbase.sql

Last active September 18, 2020 12:21

	CREATE INDEX `md5_idx` ON `leakz`(`md5`);
	CREATE INDEX `sha1_idx` ON `leakz`(`sha1`);
	CREATE INDEX `sha224_idx` ON `leakz`(`sha224`);
	CREATE INDEX `sha256_idx` ON `leakz`(`sha256`);
	CREATE INDEX `sha384_idx` ON `leakz`(`sha384`);
	CREATE INDEX `sha512_idx` ON `leakz`(`sha512`);
	CREATE PRIMARY INDEX `primary_idx` ON `leakz`;

p3t3r67x0 / fulltext_idx.json

Last active September 18, 2020 13:07

curl -u admin:password -XPUT http://127.0.0.1:8094/api/index/fulltext_idx -H 'cache-control: no-cache' -H 'content-type: application/json' -d "$(cat fulltext_idx.json)"

	{
	"type": "fulltext-index",
	"name": "fulltext_idx",
	"sourceType": "couchbase",
	"sourceName": "leakz",
	"planParams": {
	"maxPartitionsPerPIndex": 171,
	"indexPartitions": 6
	},
	"params": {

Open Data Coder p3t3r67x0

Install pgrouting2 on Ubuntu