Logo Jim Chng
Jim Chng

  • About
  • Projects
  • Blog
    • Blog Menu Description
    • Archives

    • Series

      List of series.

    • Categories

      List of categories.

    • Tags

      List of tags.


/

  • Github RSS

  • Language
    • English

  • Font Size
  • Palette
  • Mode
  1. Home
  2. Categories
  3. Engineering

Taming Hierarchical Data: Mastering SQL Recursive CTEs for Advanced Tag Management

featuresqlblog.png
May 10, 202516 min read Databases Engineering SQL Databases Engineering SQLDatabase DesignHierarchical DataRecursive CTEsSQL

Discover how self-referencing tables and declarative SQL can replace repetitive application logic, reduce database round-trips, and deliver powerful features like subtree content filtering and dynamic breadcrumb navigation.

Read More

Refining TypeScript's Opaque Types for Enhanced Type Safety

feature-typescript-opaque-types.png
February 1, 20258 min read Engineering TypeScript Development Engineering TypeScriptAdvanced TypesSecurityType SafetyTypeScript

Learn how to improve TypeScript's opaque type pattern for better protection when working with encrypted strings and sensitive data.

Read More

Supercharging Python Automation With Nox: Beyond Basic Usage

featured-nox-blog-post.png
January 15, 20257 min read Engineering Python Development Engineering PythonAutomationDevOpsNoxPythonTesting

Learn how to extend Nox with custom decorators and classes to create a more flexible, powerful automation system for your Python projects.

Read More

Compile-Time Hex String Validation in Rust Using Const Evaluation

feature-rust-compile-time-hex-str-validate.png
January 12, 20258 min read Engineering Rust Development Engineering RustConst EvaluationMetaprogrammingRustType Safety

Learn how to leverage Rust's const evaluation features to validate hex strings at compile time, ensuring type safety and zero runtime overhead.

Read More

All Decorators - Systematically Decorating Python Class Methods

featured.webp
January 9, 202513 min read Engineering Python Development Engineering PythonDecoratorsMetaprogrammingPython

A deep dive into systematically decorating all methods of a Python class, exploring challenges and solutions using the Descriptor protocol.

Read More

Template Metaprogramming: A Tale of Two Languages (C++ and Rust)

feature-cpp-rust-median.png
March 16, 202417 min read Engineering Programming C++ Programming RustC++MetaprogrammingRustTemplatesType Systems

Exploring the fascinating world of template metaprogramming in both C++ and Rust through a practical example of calculating medians with type-dependent returns.

Read More

Crafting Pydantic-Compatible Custom Python Datatypes in Rust With PyO3

feature.webp
February 28, 20236 min read Engineering Rust Development Engineering RustPydanticPythonRust

Rust-implemented custom python datatype that is also pydantic-compatible.

Read More

SOSECRETS-RS Crate

January 1, 14 min read Engineering Rust Development Engineering RustPydanticPythonRust

Rust’s Secrets Management crate with

  1. type level and compile-time guarantees and
  2. each references corresponding to each secrets can only be exposed or revealed under a lexical scope with an invariant lifetime.
Read More
Profile
Jim Chng
Jim Chng
Software Engineer. Python | Rust | TypeScript | C++ | Go.
Earth
AboutContact
Taxonomies
Engineering 7 Development 6 Rust 4 Python 2 C++ 1 Databases 1 Programming 1 SQL 1 TypeScript 1
Engineering 8 Rust 3 Python 2 Databases 1 Programming 1 SQL 1 TypeScript 1
Rust 7 Python 5 Metaprogramming 3 ManuallyDrop 2 Pydantic 2 Type Safety 2 Advanced Types 1 Artificial Intelligence 1 Automation 1 C++ 1 ALL 29
2025 5 2024 3 2023 2
Posts
  • featuresqlblog.png
    Taming Hierarchical Data: Mastering SQL Recursive CTEs for Advanced Tag Management
    May 10, 2025
  • feature-typescript-opaque-types.png
    Refining TypeScript's Opaque Types for Enhanced Type Safety
    February 1, 2025
  • featured-nox-blog-post.png
    Supercharging Python Automation With Nox: Beyond Basic Usage
    January 15, 2025
  • feature-rust-compile-time-hex-str-validate.png
    Compile-Time Hex String Validation in Rust Using Const Evaluation
    January 12, 2025
  • featured.webp
    All Decorators - Systematically Decorating Python Class Methods
    January 9, 2025
  • featuresqlblog.png
    Taming Hierarchical Data: Mastering SQL Recursive CTEs for Advanced Tag Management
    May 10, 2025
  • feature-typescript-opaque-types.png
    Refining TypeScript's Opaque Types for Enhanced Type Safety
    February 1, 2025
  • featured-nox-blog-post.png
    Supercharging Python Automation With Nox: Beyond Basic Usage
    January 15, 2025
  • feature-rust-compile-time-hex-str-validate.png
    Compile-Time Hex String Validation in Rust Using Const Evaluation
    January 12, 2025
  • featured.webp
    All Decorators - Systematically Decorating Python Class Methods
    January 9, 2025

Featured Posts

Featured Posts
  • Taming Hierarchical Data: Mastering SQL Recursive CTEs for Advanced Tag Management
  • Refining TypeScript's Opaque Types for Enhanced Type Safety
  • Supercharging Python Automation With Nox: Beyond Basic Usage
  • Compile-Time Hex String Validation in Rust Using Const Evaluation
  • All Decorators - Systematically Decorating Python Class Methods

Recent Posts

Recent Posts
  • Taming Hierarchical Data: Mastering SQL Recursive CTEs for Advanced Tag Management
  • Refining TypeScript's Opaque Types for Enhanced Type Safety
  • Supercharging Python Automation With Nox: Beyond Basic Usage
  • Compile-Time Hex String Validation in Rust Using Const Evaluation
  • All Decorators - Systematically Decorating Python Class Methods
Actions
Twitter Facebook

Go back Reload Copy URL

Move into the Future

Software Engineer | Python 🐍, Rust 🦀, TypeScript, Mojo, Go

Copyright © 2016-2025 Jim Chng. All Rights Reserved.
Build with ❤️ from the Hugo and the HBS theme.