0xBolt

• boltcraft: helping others to automate things rag, automations
• homelab: 30+ services, last add: zigbee2mqtt remote reboot via python http server
• 3 posts on medium about postgres internals (upsert wal bloat, btrfs cow pr environments, fillfactor/hot/visibility)
• testing local qwen2.5-coder 7b on rtx 3060 ti for refactoring

• 2026 → nowboltcraft.ai →web + ai automation for smb
• 2025 → 20260xely - yapstarter → aimhigherfull backend rewrite + solana program (volume-based rewards), be↔fe integration
• 2025 → nowmexc market making botcly/irc pairs, 0% maker fee, s/v scoring
• 2025protokols14 bullmq queues, pgvector rag, pg_branch on btrfs - zero-cost pr db clones, -60% latency, -250gb/day wal
• 2024 → nowsolana wallet tracker>1000 wallets, helius webhooks, gmgn api
• 2021 → 2025pfizer - data architectkpi metrics engine + snowflake data platform, rbac/rls, dbt data catalog, -70% data processing time

• 2026-04postgres fillfactor, hot updates, visibility mapmedium
• 2026-03btrfs copy-on-write for postgres pr preview environmentsmedium
• 2026-03upsert wal bloat: the silent query killermedium

all posts → medium.com/@boltpl

tooling

neovim·tmux·claude code·ubuntu

db

snowflake (deep)·postgres (deep)·timescaledb·pgvector·clickhouse·mysql/mariadb

backend

node/ts·python

data

polars·dbt·airflow·kafka·fivetran

infra

docker·wireguard·cloudflare·self-hosted supabase

ai

anthropic api·openai api·ollama (qwen, llama local)

hardware

homeserver i7-7820x/128gb·macbook air m4·ssh over wireguard

telegram

@boltpl

github

github.com/mgrom

x

@0xb0lt

medium

medium.com/@boltpl

mail

[email protected]

warsaw, pl·jdg·eu/us timezone friendly