Articles

Camera Controls

EN

The RTS camera supports nine ways to move or restore the view. The same control definitions feed the in-battle legend and field manual, while automated tests cover the underlying geometry and input rules. This page explains the complete control model and ends with the manual regression pass needed f...

Rockfall

EN

Defenders holding high ground can roll boulders onto troops climbing towards them. This is how the Allobroges struck Hannibal's army on the climb into the Alps, and the Alps episode of The Barcid Road is built on it...

Database Caching

EN

A cache keeps a reusable copy of data or a computed result. Reading the copy can avoid repeating a more expensive operation. The difficulty is knowing whether that copy is still appropriate for the request...

Double Booking Problem

EN

The double-booking problem is a common issue in database systems, particularly in applications like booking platforms, reservation systems, and inventory management. It occurs when multiple transactions simultaneously attempt to reserve or modify the same resource, leading to conflicts and inconsist...

Choosing Database

EN

Choosing the right database can significantly influence your project’s reliability, performance, cost, and ability to scale. A good database choice is not only about picking a popular engine; it is about matching the database to your data shape, query patterns, consistency needs, latency requirement...

Consistent Hashing

EN

Imagine you're organizing books in a vast library with shelves arranged in a circle. Each book’s position is chosen by the first letter of its title, looping back to the beginning after Z. When you install a new shelf or remove one, you’d prefer not to reshuffle every book—only a small, predictable ...

Capacity Planning

EN

Capacity planning is the strategic process of determining the necessary resources required to meet current and future demands of an application or system. It involves analyzing workloads, forecasting growth, and ensuring that the infrastructure can handle anticipated loads while maintaining optimal ...

Backup and Recovery Strategies

EN

A backup is useful only if it can restore the required data within the required time. Choose backup types and schedules against recovery point and recovery time objectives, then test restoration. Production impact matters, but a fast backup that cannot be recovered does not meet the goal...

Crash Recovery in Databases

EN

Crash recovery is an important component of database systems that ensures data consistency and durability despite unexpected events like power outages, hardware failures, or software crashes. By design, databases must be capable of returning to a reliable state after a failure occurs. This is largel...

Database Security

EN

Database security encompasses a comprehensive set of measures designed to protect database management systems against threats that could compromise their confidentiality, integrity, and availability. As databases often store sensitive and critical information, safeguarding them is important for prot...

Database Migration

EN

Database migration is the process of transferring data, schema, and database objects from one database environment to another. This complex undertaking is crucial when organizations aim to upgrade technology, shift infrastructures, enhance performance, or reduce costs. A successful database migratio...

Glossary

EN

Use this page as a reference when a term interrupts your reading. You do not need to memorize it before starting SQL. The groups follow the learning path: data, queries, transactions, storage, distributed systems, and analytics...

Ambient Wildlife

EN

Ambient wildlife makes battlefields feel inhabited rather than staged. Sheep occupy pasture, wolves work the edges of settlement and cover, and bird flocks move through the sky or burst away from nearby threats...

Clustered Indexes Heap Tables and Row Locality

EN

A table's primary key does not imply one universal physical layout...

Composite Indexes and Column Order

EN

A composite index contains more than one key column...

Btree Internals and Page Splits

EN

B-tree-family indexes are the default general-purpose index in many relational databases because they support ordered search efficiently...

How Tables and Indexes Are Stored on Disk

EN

The SQL table is a logical view of data. The engine must represent its rows, indexes, and recovery information as bytes. Understanding that representation helps explain why returning a few rows can require many reads, why indexes cost space, and why committed data can survive a crash...

Index Maintenance Bloat and Online Operations

EN

Indexes have a lifecycle...

Covering Partial and Expression Indexes

EN

A basic index answers...

Specialized Index Structures

EN

B-tree is the default general-purpose index for many relational workloads, but not every predicate is naturally ordered...

Database Pages

EN

SQL presents a table as rows and columns. Storage works with chunks of bytes. In many database engines, a page is a fixed-size unit used to organize data and transfer it between storage and memory. A table or index usually spans many pages...

Architecture

EN

Standard of Iron is organized around one rule: gameplay state belongs to the simulation, while application code, UI, rendering, tools, persistence, and AI consume or transform that state through explicit boundaries...

Pagination and Large Result Sets

EN

A query is not finished when the database finds matching rows. The system still has to order them, transfer them, allocate client memory, deserialize them, and render/process them...

Execution Plans Statistics and Cardinality

EN

A database optimizer estimates costs from table metadata, statistics, predicates, indexes, join algorithms, and its cost model. It does not execute every possible plan and pick the fastest one...

Connection Pooling Batching and N Plus One

EN

Database performance is not only query execution time...

Write Performance Vacuum and Bloat

EN

Read performance is only half of database performance...

Accessing Database in Code

EN

Application code sits between users and the database. A request can be slow even when the SQL engine executes its statements quickly...

Benchmarking Load Testing and Capacity

EN

A performance claim without a workload definition is incomplete...

Materialized Views

EN

A materialized view stores the result of a query so readers can reuse work that has already been performed...

Database Hardening and Patch Management

EN

Hardening reduces the number of ways a database can be attacked or accidentally misused...

Auditing Compliance and Data Governance

EN

A secure database should answer...

Incident Response and Disaster Recovery Drills

EN

A security or reliability incident is the wrong time to discover that...

Encryption Secrets and Key Management

EN

Database security depends on protecting data in several different states...

Document Modeling

EN

A document database stores records as documents rather than normalized rows spread across many tables. The main modeling question is not "can this be JSON?" but...

Operating Nosql and Polyglot Persistence

EN

NoSQL systems are often introduced through data models, but production success depends just as much on operations. A database choice adds responsibilities for deployment, backups, monitoring, security, capacity, failure recovery, schema evolution, and synchronization with other systems...