Skip to content

Instantly share code, notes, and snippets.

View crepererum's full-sized avatar
🦀
rusting

Marco Neumann crepererum

🦀
rusting
81 followers · 6 following
View GitHub Profile
@crepererum
crepererum / pg.md
Last active December 14, 2023 12:00
Postgresql Analysis

Postgres Analysis

Table Size

List sizes of tables in current schema.

SELECT
    table_name                                                      AS table_name,
    pg_size_pretty(pg_total_relation_size(quote_ident(table_name))) AS total_size,
    pg_size_pretty(pg_table_size(quote_ident(table_name)))          AS table_size,
@crepererum
crepererum / ingester_flight_api.log
Created July 21, 2023 09:25
ingester_flight_api.log
failures:
---- end_to_end_cases::ingester::ingester_flight_api stdout ----
2023-07-21T09:13:19.016261Z INFO test_helpers_end_to_end::server_fixture: ****************
2023-07-21T09:13:19.016290Z INFO test_helpers_end_to_end::server_fixture: Server Ingester Logging to "/tmp/.tmpsmZ1LX"
2023-07-21T09:13:19.016297Z INFO test_helpers_end_to_end::server_fixture: ****************
2023-07-21T09:13:19.593062Z INFO test_helpers_end_to_end::database: Initializing database... dsn=postgres://postgres@localhost/iox_shared schema_name=XDPhlKuZlNvCkAksheDD
2023-07-21T09:13:19.599417Z DEBUG sqlx::query: summary="select exists(SELECT 1 from …" db.statement="\n\nselect\n exists(\n SELECT\n 1\n from\n pg_database\n WHERE\n datname = $1\n )\n" rows_affected=0 rows_returned=1 elapsed=977.878µs
2023-07-21T09:13:19.988388Z INFO test_helpers_end_to_end: Running command: `INFLUXDB_IOX_BIND_ADDR=127.0.0.1:8191 INFLUXDB_IOX_CATALOG_DSN=postgres://postgres@localhost/iox_shared INFLUXDB_IOX_CATALOG_POSTGRES
@crepererum
crepererum / openpgp.md
Created March 14, 2023 21:51

openpgp4fpr:EC87D065FC9F90B4EF44D829B59BA3385EE1AA9E

@crepererum
crepererum / proof.txt
Created April 29, 2020 17:39
keys.pub proof
BEGIN MESSAGE.
aKoqMLNNv9eKKww jDwo9mBaD6nKRLD V5kDIMbliYkp5EF 9236sFpmc5WJqPI
UD2jUkIV6zY3LAJ bLKKh12dt2kTCKq 6Xr2MZHgg70hvcY nOuwowKEic414re
6oMNmtXOsCR8gAT R8HJw5ni5kHhkbJ Gvatju41FxfreGL YXRCbJPQu1XReHb
1Jp2ELcIigScpxT vZRply0CChBvQAn Nnkd27tiSkCT.
END MESSAGE.
@crepererum
crepererum / ghost2zola.py
Created March 3, 2019 13:36
from collections import defaultdict
import gzip
import json
import os
import os.path
import urllib.request
EXPORT_FILE = 'crepererum-net.ghost.2019-02-23.json'
OUT_PATH = 'out'
@crepererum
crepererum / f1_protocol.md
Created September 21, 2016 12:40
Traktor F1 USB

Traktor F1 USB Protocol

Devide Info

  • stateless protocol
  • vendor ID: 0x17cc
  • product ID: 0x1120
  • MSB 0 bit numbering
  • little endian

Input

@crepererum
crepererum / generic_algo.cc
Created August 31, 2016 11:06
Generic Algo Example
#include <iterator>
/*
* I: iterator type
* F: function that decides about good&bad
*/
template <typename I, typename F>
I bisect(I good, I bad, F&& f) { // use call-by-value for iterators and universal refs for function object
using D = typename std::iterator_traits<I>::difference_type;
D dist;
@crepererum
crepererum / rdxsort-rs-cla.md
Created August 12, 2016 20:13
rdxsort-rs CLA

rdxsort-rs Individual Contributor License Agreement

Thank you for your interest in contributing to rdxsort-rs ("We" or "Us").

This contributor agreement ("Agreement") documents the rights granted by contributors to Us. To make this document effective, please sign it and send it to Us by electronic submission, following the instructions at https://cla-assistant.io/. This is a legally binding document, so please read it carefully before agreeing to it. The Agreement may cover more than one software project managed by Us.

1. Definitions

"You" means the individual who Submits a Contribution to Us.

@crepererum
crepererum / website_checks.md
Created May 9, 2016 13:55
website checks
@crepererum
crepererum / 2015-07-16.md
Created July 16, 2015 07:49

general

  • events: OpenLab Summer Student Lectures :)

inveniosoftware/invenio

master:

  • PR#3336 [merged] Fix master after search replacement
    • thanks to Leo for the hard work
  • PR#3343 [merged] docker: read-only root images + RabbitMQ + Elasticsearch
  • PR#3348 [merged] docker: fix for production compose config