Skip to content

Instantly share code, notes, and snippets.

View p3t3r67x0's full-sized avatar

Open Data Coder p3t3r67x0

41 followers · 27 following
View GitHub Profile
@p3t3r67x0
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
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
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
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
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
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": "[email protected]",
"website": "http://www.schule-auf-der-rude.lernnetz.de",
"address": "Lundweg 30",
"postalcode": "24941",
@p3t3r67x0
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.
{"marketManager": "Daniela Fischer", "phone": "036452-762538", "advertisingCounty": null, "regionShort": "OS", "address": {"street": "Schwerstedter Str.", "houseNumber": "3-4", "postalCode": "99439", "city": "Am Ettersberg OT Berlstedt", "state": "Th\u00fcringen", "streetWithNumber": "Schwerstedter Str. 3-4"}, "type": {"name": "REWE", "id": null}, "openingHours": {"condensed": [{"days": "Mo-Fr", "hours": "06:00 - 22:00"}, {"days": "Sa", "hours": "07:00 - 20:00"}], "dayAndTimeRanges": [{"startDay": "MONDAY", "endDay": "FRIDAY", "startTime": {"hour": 6, "minute": 0, "second": 0, "nano": 0}, "endTime": {"hour": 22, "minute": 0, "second": 0, "nano": 0}, "seoRepresentation": "Mo-Fr 06:00-22:00", "opens": "06:00", "closes": "22:00"}, {"startDay": "SATURDAY", "endDay": null, "startTime": {"hour": 7, "minute": 0, "second": 0, "nano": 0}, "endTime": {"hour": 20, "minute": 0, "second": 0, "nano": 0}, "seoRepresentation": "Sa 07:00-20:00", "opens": "07:00", "closes": "20:00"}]}, "specialOpeningHours": null, "geoLocation
@p3t3r67x0
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
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
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": {