Mathias Paulenko
Software Engineer & Founder of StackPractices
Mathias Paulenko
Software Engineer
Software engineer with 12+ years of experience building production systems across Python, JavaScript, React, and DevOps. I have contributed to enterprise projects spanning CI/CD pipelines, API design, cloud infrastructure, and full-stack development.
StackPractices is my personal project, born from a simple belief: great documentation should be copy-paste ready. Every recipe, pattern, and guide on this site is designed to save you time and help you ship faster.
Published Works (1032)
Read and Write Excel Files with Python
How to read, write, and format Excel spreadsheets using openpyxl and pandas in Python.
Generate QR Codes with Python
Create QR codes for URLs, text, and contact cards using the qrcode library in Python.
Backup Rotation Script in Bash
Automated backup with retention policies using bash and find.
Monitor Disk Usage with Bash
Alert when disk space crosses thresholds with bash scripts
Log Rotation and Compression in Bash
Rotate and compress application logs automatically with bash scripts
Run Shell Commands in Parallel with Bash
Execute multiple shell commands concurrently using xargs, GNU parallel, and background jobs.
Batch Resize Images with Python
How to bulk resize and optimize images using Pillow and Python for web delivery.
Configure iptables Firewall Rules with Bash
Set up basic firewall rules with iptables and bash scripts
Find and Remove Duplicate Rows in SQL
Detect duplicate records in SQL tables using GROUP BY and HAVING, then remove them safely while...
Set Up Full-Text Search Indexes
Configure full-text search indexes in PostgreSQL to query large text columns with ranking,...
Analyze and Optimize SQL Indexes with EXPLAIN
Identify missing, unused, and inefficient indexes by reading execution plans and measuring query...
Zero-Downtime Column Rename Migration
Rename columns or change data types without locking tables by using views, triggers, and backfill...
Partition Large Tables by Date or Range
Split huge SQL tables into smaller partitions by date, range, or list to improve query performance...
Traverse Hierarchical Data with Recursive CTEs
Query tree-like or graph-like structures in SQL using recursive common table expressions to walk...
Rank Rows and Calculate Running Totals with Window Functions
Use SQL window functions to rank rows, compute running totals, and compare values within partitions...
AWS CLI Automation with Bash
Automate AWS resource provisioning, tagging, and cleanup using Bash scripts wrapped around the AWS...
Backup Rotation Script
Automate file backups with retention policies using a Bash script that rotates daily, weekly, and...
Configure Firewall Rules with iptables
Set up basic firewall rules using iptables in Bash to filter traffic, block ports, and protect...
Log Rotation and Compression
Rotate and compress application logs with Bash to prevent disk exhaustion and simplify log...
Monitor Disk Usage
Alert when disk space crosses thresholds using a Bash script that checks mount points and notifies...
Parallel Job Execution with Bash
Run shell commands and scripts in parallel safely using xargs, parallel, or background jobs with...
SSH Key Management
Generate, rotate, and distribute SSH keys securely with Bash scripts for team and server access.