Recent Posts
Python Tutorial / Package a Python Program and Verify Installation
Create a src-layout package and pyproject.toml, build a wheel, install it cleanly and verify imports and module execution outside the source checkout.
Python Tutorial / Choose Threads, Processes or asyncio
Compare thread, process and asyncio execution models, understand entry-point and event-loop rules and choose concurrency based on workload and measured costs.
Python Tutorial / Understand Decorators and Context Managers
Wrap functions with preserved metadata and results, implement cleanup with contextmanager and verify behavior when a block or wrapped call fails.
Python Tutorial / Connect to MariaDB and Manage Transactions
Prepare a least-privilege local MariaDB account, bind values through PyMySQL and manage commit, rollback, credentials and connection cleanup.
Python Tutorial / Build a Flask JSON API Server and Validate Input
Build local Flask GET/POST routes, validate JSON and status codes and verify them with a test client while identifying persistence and deployment limits.
Python Tutorial / Extract Data from HTML with Beautiful Soup
Parse controlled HTML with Beautiful Soup, select elements and validate required text, attributes and counts while detecting markup changes.
Python Tutorial / Visualize Results with Matplotlib
Build a labeled Matplotlib bar chart, use a headless file backend and inspect units, baselines, labels and output-version behavior.
Python Tutorial / Clean and Analyze Tabular Data with pandas
Read tabular data as controlled strings, validate numeric values with pandas masks, aggregate categories and reconcile rejected counts and saved totals.
Python Tutorial / Final Project: Build an SQLite Expense Manager
Complete an SQLite-backed expense CLI with initialization, validated add/list/summary commands, transactions and checks for rejected input and persistent results.
Python Tutorial / Project: Collect API Data Without Duplicate Storage
Fetch and validate an entire JSON batch, upsert by stable IDs and verify repeated collection, updates and failure preservation in SQLite.