Author

Code Mala Tang

Read source code together, write articles together, and enjoy spicy hot pot together.

451

Articles

Likes

1.4k

Views

Comments

Latest from Code Mala Tang

100 recent articles max

Code Mala Tang

Oct 26, 2025 · Databases

Why Parameterized Queries Supercharge SQL Performance (And Prevent Injection)

This article explains how using bound (parameterized) queries in SQL Server improves performance by enabling execution plan reuse, reducing compilation overhead and memory usage, while also preventing SQL injection, and discusses potential pitfalls like parameter sniffing and how to mitigate them with OPTION (RECOMPILE).

Parameterized QueriesPerformance optimizationSQL

0 likes · 6 min read

Why Parameterized Queries Supercharge SQL Performance (And Prevent Injection)

Code Mala Tang

Oct 26, 2025 · Backend Development

Auto‑Clean Python Dependencies with pipreqs and Pre‑Commit

Learn how to automatically remove unused Python packages from your virtual environment by generating an accurate requirements.txt with pipreqs and enforcing clean dependencies on every commit using a pre‑commit hook, improving build size, speed, and security.

dependency-cleanuppipreqspre-commit

0 likes · 5 min read

Auto‑Clean Python Dependencies with pipreqs and Pre‑Commit

Code Mala Tang

Oct 25, 2025 · Frontend Development

Translate React Hooks to Python: A Practical Guide for Python‑Savvy Developers

This tutorial shows Python developers how to understand and use React (and Next.js) hooks by mapping each hook to familiar Python concepts such as closures, nonlocal variables, context managers, memoization, and async tasks, complete with side‑by‑side code examples.

ReActhooksnextjs

0 likes · 12 min read

Translate React Hooks to Python: A Practical Guide for Python‑Savvy Developers

Code Mala Tang

Oct 24, 2025 · Big Data

Boost Python File Processing: 9 Essential Tools for Speed, Safety, and Scale

This guide introduces nine Python libraries—including smart_open, filelock, watchdog, zstandard, dataclasses-json, polars, fsspec, pandas, and tracemalloc—that together enable fast, memory‑efficient, and reliable handling of large files, remote storage, and concurrent workflows.

Large FilesPythonWatchdog

0 likes · 11 min read

Boost Python File Processing: 9 Essential Tools for Speed, Safety, and Scale

Code Mala Tang

Oct 20, 2025 · Fundamentals

Master Python Exception Handling: Safer, Cleaner Code with Helper Functions

Learn why broad try‑except blocks can hide critical errors and how to replace them with focused helper functions, narrow try blocks, context managers, and tools like contextlib.suppress, making Python code safer, more readable, and easier to maintain.

Pythonbest practicescode refactoring

0 likes · 5 min read

Master Python Exception Handling: Safer, Cleaner Code with Helper Functions

Code Mala Tang

Oct 19, 2025 · Fundamentals

Why Python’s += Operator Isn’t Just Sugar: Mutable vs Immutable Secrets

Python’s augmented assignment operators like += look simple, but their behavior varies dramatically between mutable and immutable objects, affecting performance and causing surprising bugs; this article explains the underlying data model, demonstrates with tuples, lists, and mixed structures, and reveals the hidden mechanics behind in‑place and object‑creation operations.

Data ModelImmutablePerformance

0 likes · 14 min read

Why Python’s += Operator Isn’t Just Sugar: Mutable vs Immutable Secrets

Code Mala Tang

Oct 16, 2025 · Fundamentals

Unlock Zero‑Copy Performance in Python with memoryview

This article explains how Python's memoryview object eliminates costly data copies when slicing large binary or numeric arrays, offering zero‑copy views, reinterpretation via .cast(), and multi‑dimensional slicing, with practical code examples and guidance on when to use it.

Buffer ProtocolPerformancePython

0 likes · 11 min read

Unlock Zero‑Copy Performance in Python with memoryview

Code Mala Tang

Oct 15, 2025 · Backend Development

Master Automatic Restarts for Node.js: From Nodemon to PM2 and Docker

Learn how to ensure your Node.js applications stay alive by configuring automatic restarts for both development and production environments, using tools like Nodemon, PM2, Docker restart policies, systemd, and advanced PM2 features such as clustering, log management, and crash handling.

DockerNode.jsProcess Management

0 likes · 14 min read

Master Automatic Restarts for Node.js: From Nodemon to PM2 and Docker

Code Mala Tang

Oct 15, 2025 · Fundamentals

Master Python List Comprehensions: From Basics to Advanced Tricks

This article explains Python list comprehensions, comparing traditional for‑loop constructions with concise one‑line expressions, covering basic syntax, filtering, conditional transformations, performance benefits, and an introduction to generator expressions, all illustrated with clear code examples and diagrams.

PerformancePythoncoding

0 likes · 13 min read

Master Python List Comprehensions: From Basics to Advanced Tricks

Code Mala Tang

Oct 14, 2025 · Fundamentals

Master Python 3.10's Structural Pattern Matching: From Basics to Advanced

This article introduces Python 3.10's powerful structural pattern matching, showing how the new match/case syntax replaces complex if/elif/else chains, supports pattern deconstruction, guards, type checks, and works with sequences, dictionaries, and objects to write clearer, safer, and more expressive code.

GuardsPattern MatchingPython

0 likes · 13 min read

Master Python 3.10's Structural Pattern Matching: From Basics to Advanced