Author

Satori Komeiji's Programming Classroom

Python and Rust developer; I write about any topics you're interested in. Follow me! (#^.^#)

Articles

Likes

Views

Comments

Latest from Satori Komeiji's Programming Classroom

33 recent articles

Satori Komeiji's Programming Classroom

Jul 24, 2024 · Fundamentals

How Python Creates and Destroys Lists—and What the Free List Looks Like

This article explains CPython’s list creation via PyList_New, details memory allocation, the role of the free‑list cache, the deallocation process in list_dealloc, and the trashcan mechanism that prevents recursion overflow, illustrating each step with code snippets and concrete examples.

CPythonfree listlist

0 likes · 12 min read

How Python Creates and Destroys Lists—and What the Free List Looks Like

Satori Komeiji's Programming Classroom

Jul 12, 2024 · Fundamentals

How I Fixed a Tuple Free‑List Bug in CPython 3.12

The article explains CPython's object memory caching, details the structure of the tuple free‑list, reproduces a bug where length‑20 tuples aren't reused, shows the debugging steps, and presents a one‑line source change that corrects the issue in Python 3.12/3.13.

CPythonPythonbug-fix

0 likes · 7 min read

How I Fixed a Tuple Free‑List Bug in CPython 3.12

Satori Komeiji's Programming Classroom

Jul 9, 2024 · Backend Development

Mastering pypika: Build SQL Queries in Python Without Manual String Concatenation

This guide walks through installing pypika and demonstrates how to construct SELECT, WHERE, GROUP BY, JOIN, subqueries, set operations, INSERT, UPDATE, and database‑specific adaptations using Python code, showcasing concrete examples and the full query‑building workflow.

PythonSQLbackend

0 likes · 24 min read

Mastering pypika: Build SQL Queries in Python Without Manual String Concatenation