Technical Articles

Practical articles, in-depth tutorials, and architectural insights on software engineering, AI, and systems.

All categories Arquitetura Automação Backend Carreira DevOps Eletrônica Engenharia Frontend Hardware IA Negócios Produtividade Redes

How to convert bash history to CSV in Linux

Learn how to transform your Linux terminal command log into a structured CSV spreadsheet using native tools like awk and sed.

Read article

DevOps•4 min

How to convert CSV to JSON in Linux via terminal

Learn how to transform tabular spreadsheets into structured JSON objects using native utilities and quick command-line tools in Linux.

Read article

Produtividade•4 min

How to convert uppercase to lowercase in Excel with formulas

Learn how to use the LOWER function in Excel to instantly standardize large volumes of text in spreadsheets without retyping everything.

Read article

AutomaçãoProdutividade•3 min

How to organize PDF files on Linux using the terminal with pdftk

Learn how to automate PDF document management on Linux using pdftk. Fast commands for merging, splitting, and rotating files without graphical interfaces.

DevOpsProdutividade•2 min

How to generate performance charts in terminal with Gnuplot

Learn how to transform text logs into visual charts directly in the terminal using Gnuplot. A vital skill for engineers analyzing telemetry data on the fly.

DevOpsProdutividade•2 min

Error logs on Linux? How to filter journald with jq

Tired of reading massive log files? Learn to extract critical events from journald and turn them into JSON for fast and accurate troubleshooting.

DevOpsProdutividade•5 min

How to convert JSON files to CSV in Linux via terminal

Learn how to quickly transform structured JSON data files into CSV tables on Linux using native command line tools like jq.

ProdutividadeDevOps•4 min

How to generate PDF from Markdown on Linux via terminal

Learn how to transform plain text Markdown documents into formatted PDF files quickly and automatically using native Linux command line tools.

DevOpsProdutividade•6 min

How to extract image metadata on Linux via terminal

Learn how to quickly inspect, modify, and remove EXIF data from images in bulk on Linux using the powerful ExifTool command-line utility.

Produtividade•5 min

How to organize PDF files on Linux using the terminal qpdf

Learn how to merge, slice, and compress PDF documents directly from the Linux terminal using the fast qpdf utility with efficient commands.

Produtividade•4 min

How to manipulate PDF files on Linux using the terminal with pdftk

Learn how to quickly merge, split, and manipulate PDF documents on Linux using efficient command-line tools like pdftk.

AutomaçãoProdutividade•6 min

How to organize keyboard shortcuts and macros with AutoHotkey

Learn how to automate repetitive tasks and create smart keyboard shortcuts on Windows using lightweight AutoHotkey scripts.

AutomaçãoProdutividade•4 min

Messy spreadsheet? How to convert to clean CSV with Python

Learn how to build a utility script in Python using the pandas library to quickly sanitize misaligned tabular data in office workflows.