Skip to content

Instantly share code, notes, and snippets.

View ccamel's full-sized avatar
🧙‍♂️
Coding for Community, Designing with Purpose.

Chris ccamel

🧙‍♂️
Coding for Community, Designing with Purpose.
View GitHub Profile
@ccamel
ccamel / katAI-graph-wizard.sh
Last active October 4, 2024 12:13
Simple magical one-line bash command to graph KatAI contributions over time (https://katai.xyz)
( export NODE="https://api.dentrite.axone.xyz:443/rpc"; \
export CONTRACT="axone1xa8wemfrzq03tkwqxnv9lun7rceec7wuhh8x3qjgxkaaj5fl50zsmj8u0n"; \
axoned query wasm contract-state smart \
"$CONTRACT" \
'{
"select": {
"query": {
"prefixes": [],
"select": [
{ "variable": "date" }
@ccamel
ccamel / dependabot-approve.sh
Created September 15, 2024 16:12
A bash script to automatically approve and politely ask Dependabot to merge its own PRs, because I’m a bit lazy and happy to let the bots handle the hard part (if the CI behaves)!
#!/bin/bash
set -euo pipefail
REVIEWER=$(gh api user --jq '.login' 2>/dev/null)
APPROVAL_MESSAGES=(
"Dependency update approved! ✅"
"Nice upgrade, Dependabot! 🚀"
"LGTM on the upgrade! 👍"
"Ready to roll with this update! 😃"
"Dependencies look solid. 👌"
@ccamel
ccamel / plot-dendrite-1-onboarding.sh
Created September 2, 2024 08:19
dendrite-1 testnet validators onboarding
gh pr list \
--state closed \
--search "label:\"chain: ⛓️ dentrite-1\" label:register-validator sort:created-asc" \
--limit 150 --json "createdAt,mergedAt" \
--template '{{ printf "%s\n" "# date count" }}{{ range . }}{{ if .mergedAt }}{{ printf "%s %d\n" .createdAt 1}}{{ end }}{{ end }}' \
-R axone-protocol/networks \
| gnuplot \
-p \
-e 'set terminal dumb size 150, 30; set autoscale; set xdata time; set timefmt "%Y-%m-%dT%H:%M:%S"; set title "dendrite-1 Validators onboarding"; set xlabel "Date"; set ylabel "Count"; cumulative_sum(x)=(count=count+x,count); count=0; plot "-" using 1:(cumulative_sum($2)) title "" with lines;'
@ccamel
ccamel / plot-druid-registration.sh
Last active December 5, 2022 10:58
nemeton-1 druid registration progress
gh pr list \
--search "label:register-validator sort:created-asc" \
--limit 150 --json "createdAt" \
--template '{{ printf "%s\n" "# date count" }}{{ range . }}{{ printf "%s %d\n" .createdAt 1}}{{ end }}' \
-R okp4/networks \
| gnuplot \
-p \
-e 'set terminal dumb size 150, 30; set autoscale; set xdata time; set timefmt "%Y-%m-%dT%H:%M:%S"; set title "Druids registration"; set xlabel "Date"; set ylabel "Count"; cumulative_sum(x)=(count=count+x,count); count=0; plot "-" using 1:(cumulative_sum($2)) title "" with lines;'
@ccamel
ccamel / #my-configuration-files.md
Last active January 1, 2023 11:00
🗂 My various configuration files

Various configuration files for my working environment

@ccamel
ccamel / dsm-event.md
Last active September 15, 2024 16:23
The Daily Sync: A 15-Minute Power-Up for the TechTeam

15-minutes time-boxed event by the TechTeam for the TechTeam in order to synchronize activities for the next 24 hours.

Few commandments:

📆 Be on time.

It's a mandatory meeting that the entire TechTeam needs to attend

⏳ Keep it short.

10 to 15 minutes

@ccamel
ccamel / pi.sql
Created March 21, 2019 16:46
Computation of π with PostgreSQL Recursive Query
-- just for fun
-- compute π using the Leibniz formula
with recursive leibniz (n, r) as (
select 0, 0.
union
select n + 1, r + cast(power(-1, n) as decimal) / (2. * n + 1.)
from leibniz
where n < 10000
)
select 4. * r as pi from numbers offset 10000;
@ccamel
ccamel / keybase.md
Created March 11, 2019 14:38
keybase.md

Keybase proof

I hereby claim:

  • I am ccamel on github.
  • I am ccamel (https://keybase.io/ccamel) on keybase.
  • I have a public key ASCEogRDs38pK3VRKUSqmzccuEu--8K1pvPlN7vBoAeZSgo

To claim this, I am signing this object:

@ccamel
ccamel / sequence-diagram-1.plantuml
Created May 9, 2018 09:29
PlantUML - Sequence Diagram samples (with a nice rendering)
@startuml
' styles
skinparam handwritten true
skinparam monochrome false
skinparam packageStyle rect
skinparam defaultFontName FG Virgil
skinparam shadowing false
hide footbox