Skip to content

Instantly share code, notes, and snippets.

Avatar

Open Data Coder p3t3r67x0

View GitHub Profile
View unfallorte_bezeichnungen.sql
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;
View schulen_flensburg.json
[{
"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
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.
View rewe_discounter_details.json
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
View vue_tailwindcss_candar.vue
<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 }"
View create_index_cuchbase.sql
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)"
View fulltext_idx.json
{
"type": "fulltext-index",
"name": "fulltext_idx",
"sourceType": "couchbase",
"sourceName": "leakz",
"planParams": {
"maxPartitionsPerPIndex": 171,
"indexPartitions": 6
},
"params": {
@p3t3r67x0
p3t3r67x0 / hashcat_benchmark.md
Created September 13, 2020 01:05
GeForce GTX 1070 Ti - hashcat benchmark on Ubuntu 20.04 with CUDA 11
View hashcat_benchmark.md

hashcat --benchmark --optimized-kernel-enable

hashcat (v6.1.1) starting in benchmark mode...

CUDA API (CUDA 11.0)
====================
* Device #1: GeForce GTX 1070 Ti, 7730/8118 MB, 19MCU

OpenCL API (OpenCL 1.2 CUDA 11.0.228) - Platform #1 [NVIDIA Corporation]
@p3t3r67x0
p3t3r67x0 / tensorflow2.3_build_error.md
Last active September 13, 2020 07:05
A short story how I did build Tensorflow 2.3 from source on Ubuntu 20.4.1 LTS with CUDA 11.0.207
View tensorflow2.3_build_error.md

Building Tensorflow 2.3 from source on Ubuntu 20.4.1 LTS

GPU

ASUS ROG Strix GeForce GTX 1070 Ti 8GB

System

@p3t3r67x0
p3t3r67x0 / terminator.config
Created August 28, 2020 05:10
My Terminator config
View terminator.config
[global_config]
window_state = fullscreen
borderless = True
extra_styling = False
title_transmit_fg_color = "#729fcf"
title_transmit_bg_color = "#002b36"
title_receive_fg_color = "#eeeeec"
title_inactive_bg_color = "#002b36"
[keybindings]
[profiles]
View convert_svg_matrix.md

convert_svg_matrix

def delta_transform_point(matrix, point):
    dx = point['x'] * matrix['a'] + point['y'] * matrix['c'] + 0
    dy = point['x'] * matrix['b'] + point['y'] * matrix['d'] + 0

    return {'x': dx, 'y': dy}