Jhonatan Pinheiro
Loading page...
Jhonatan Pinheiro
Loading page...
Jhonatan Pinheiro
Loading page...
I write about data, backend, databases and the craft of building software.
Filter by topic
Tokens and real cost, chunking that doesn't cut the answer in half, pgvector and HNSW, hybrid search with RRF, reranking, incremental sync, function calling, evals with recall@k, prompt injection and RLS. The full roadmap for whoever builds the infrastructure.
Ordinal theory, the inscription envelope field by field, commit and reveal, the runestone byte by byte, etching commitments, edicts, cenotaphs and the costly mistakes.
How blockchain actually works, what real-world asset tokenization delivers (and what it doesn't), and how Bitcoin got NFTs and fungible tokens with Ordinals and Runes.
Setup, commits, branches, merge and rebase, remotes, the undo chapter (reset, revert, reflog), bisect and blame: 100 commands with examples.
The difference between Git and GitHub, the branch and Pull Request flow, issues, Actions, releases, security and using the platform as a portfolio.
Navigation, files, permissions, users, processes, packages, disk, network, archiving and search: 200 commands with copy-ready examples.
Pipes and redirection, sed and awk, shell scripts, systemd, cron, SSH, networking, disks and logs: 200 items with practical examples.
Performance and eBPF, kernel and sysctl, namespaces and cgroups, firewall, storage, networking, strace and perf debugging, boot and recovery: 200 production commands.
Containers, images, multi-stage Dockerfiles, volumes, networks, Compose and what changes in production: 150 commands with copy-ready examples.
SELECT, filters, sorting, text, numbers, dates, aggregations and table creation: 200 commands with copy-ready examples.
JOINs, subqueries, CTEs, views, indexes, transactions, JSON and in-database programming: 200 items with practical examples.
Execution plans, advanced indexes, concurrency, partitioning, replication, backup, security and diagnostics: 200 commands for production databases.
SQL or NoSQL? The five NoSQL families, ACID vs BASE, the CAP theorem, the same system modeled both ways, and when each one is the right call.
The five most-used relational databases side by side: table creation, pagination, upsert, administration and backup — the same task solved in each one.
The 20 SQL commands you use every day — from SELECT to aggregations, with ready-to-copy examples.
JOINs, subqueries, VIEWs, transactions and more: 20 techniques that take you beyond basic SELECT.
Window functions, CTEs, performance, concurrency, security and administration: 40 topics for serious data work.
A new space to share experiences in data, backend and software engineering.