84adam

# lnd-postgres-kv-decoder.py

from decouple import config
import psycopg2
import psycopg2.extras
import pandas as pd
import time

tables = ['channeldb_kv', 'decayedlogdb_kv', 'macaroondb_kv',
          'towerclientdb_kv', 'towerserverdb_kv', 'walletdb_kv']

84adam

### PostgreSQL: format multiple columns into string for each row using a semicolon as separator between fields

```
SELECT 
FORMAT('%s; %s; %s; %s',
col_one, col_two, col_three, col_four)
AS entries
FROM table_name;
```

84adam

[Unit]
Description=I2P Router written in C++
Documentation=man:i2pd(1) https://i2pd.readthedocs.io/en/latest/
After=network.target
ConditionFileIsExecutable=/usr/sbin/i2pd

[Service]
User=i2pd
Group=i2pd
RuntimeDirectory=i2pd

84adam

# bitcoin-inflation.py
# based on: https://github.com/ndsvw/Bitcoin-Supply-Calculator/blob/master/btcsupply.py

def btc_supply_at_block(b):
    max_supply = 20999999.9769
    if b >= 33 * 210000:
        return max_supply, 1.0
    else:
        reward = 50e8
        supply = 0

84adam

### Python Clean Code Tips & Tools

Check the quality of your code inside your CI pipeline.

- flake8 - style guide enforcer
- black - code formatting
- isort - optimize imports
- bandit - check for security vulnerabilities
- safety - check for security vulnerabilities of dependencies

84adam

// a simple Go-based website
// based on: https://www.digitalocean.com/community/tutorials/how-to-make-an-http-server-in-go
// with 100 bytes of CSS from: https://gist.github.com/JoeyBurzynski/617fb6201335779f8424ad9528b72c41

package main

import (
    "errors"
    "fmt"
    "io"

84adam

#!/bin/bash
MOUNTPOINT="/mnt/ext"
DISK="/dev/sda1"

echo ""
echo "-------------------------------------------------------------------------------- DISK SPACE USED/REMAINING"
df -m | head -n 1 ; df -m | grep "$DISK"
df -H | head -n 1 ; df -H | grep "$DISK"
echo "-------------------------------------------------------------------------------- DISK I/O"
echo ""

84adam

[Application Options]
feeurl=https://nodes.lightning.computer/fees/v1/btc-fee-estimates.json

[Bitcoin]
bitcoin.active=1
bitcoin.mainnet=1
bitcoin.node=neutrino

[neutrino]

84adam

import pandas as pd

# MAKE UP SOME DATA
data = {'id': [1, 2, 3, 4, 5],
        'First Name': ['Mary', 'Harry', 'Larry', 'Fairy', 'Dairy',],
        'Birth Year': [1930,1940,1950,1960,1970],
        'Favorite Color': ['Blue', 'Red', 'Green', 'Pink', 'Orange']}

# CREATE A DATAFRAME
df = pd.DataFrame.from_dict(data)

84adam

import requests
import io
import pandas as pd

# SEE: https://fred.stlouisfed.org/series/T5YIFR/#0

url = """https://fred.stlouisfed.org/graph/fredgraph.csv?bgcolor=%23e1e9f0&chart_type=line&drp=0&fo=open%20sans&graph_bgcolor=%23ffffff&height=450&mode=fred&recession_bars=on&txtcolor=%23444444&ts=12&tts=12&width=1168&nt=0&thu=0&trc=0&show_legend=yes&show_axis_titles=yes&show_tooltip=yes&id=T5YIFR&scale=left&cosd=2003-01-02&line_color=%234572a7&link_values=false&line_style=solid&mark_type=none&mw=3&lw=2&ost=-99999&oet=99999&mma=0&fml=a&fq=Daily&fam=avg&fgst=lin&fgsnd=2020-02-01&line_index=1&transformation=lin&nd=2003-01-02
"""

s = requests.get(url).content