@MrCollison: The craziest thing about building a game engine is I've learned a concept that scared me the most: Columnar Stores It's…
Summary
The author shares a personal breakthrough in understanding columnar stores while building a game engine, relating it to Trizen's ECS and ClickHouseDB.
View Cached Full Text
Cached at: 05/17/26, 08:23 PM
The craziest thing about building a game engine is I’ve learned a concept that scared me the most: Columnar Stores
It’s database design magic that I have tried but NEVER understood. And I spent a long time researching it pre-AI.
Trizen’s ECS is built on top of this and it makes total sense to me now
And now I finally understand how @ClickHouseDB works - it seemed like magic that you can do SQL in a column database
But Trizen uses an archetype to bundle / pop and swap entities together than look the same
So fun
Similar Articles
@BraceSproul: Engine is one of the most complex production agent systems I've seen built. Definitely give this a read to see how we b…
Brace Sproul shares a post about Engine, a complex production agent system, encouraging others to read about how it was built.
@NicolasZu: Another WTF moment. Using Codex as a fully custom game engine With the newly discovered and *insane* img2threejs skill …
Nicolas Zullo demonstrates a workflow using Codex and img2threejs to generate 3D game assets from text prompts, automatically integrating them into a game engine.
So, you want to make a game engine (2023)
A blog post discussing the reasons and considerations for building a custom game engine, sparked by Unity's pricing controversy.
What You Gain by Building Your Own Game Engine
The article discusses the benefits and learning outcomes from developing a custom game engine from scratch.
From Pixels to States: Rethinking Interactive World Models as Game Engines
This paper rethinks interactive world models as game engines by examining four key dimensions—action control, state dynamics, state-observation persistence, and real-time generation—and introduces a scalable data engine for Black Myth: Wukong with over 90 hours of gameplay data to advance state-aware game world modeling.