Index

Inheritance with Metatables

Understand how Lua uses metatables and the __index metamethod to implement inheritance chains between tables.

B-Tree Indexes Explained

Learn how PostgreSQL's default B-tree index works internally and why it is the right choice for equality and range queries.

Index Maintenance and Bloat

Understand why indexes accumulate dead space over time, how to detect bloat, and the tools PostgreSQL provides to reclaim it safely.

Partial and Expression Indexes

Use partial indexes to index only a relevant subset of rows and expression indexes to index computed values, keeping indexes smaller and more targeted.

Creating an Index

Learn how Elasticsearch indices are created, configured with shards and replicas, and named for reliable, scalable search.

Index Lifecycle Management

How Elasticsearch's ILM feature automates moving indices through hot, warm, cold, and delete phases as data ages.

Compound Indexes

Understand how MongoDB compound indexes combine multiple fields, the ESR rule for ordering keys, and how they support sorting and covered queries.

Index Signatures in TypeScript

Understand how index signatures let interfaces and types describe objects with dynamic, not-fully-known-in-advance property keys.

Series Basics

Learn the anatomy of a pandas Series — its values, index, and name — and how label-based alignment, vectorized operations, and dtype inference make it more tha…

Setting and Resetting the Index

Understand how to promote columns to a DataFrame's index with set_index and revert them back with reset_index, and why the index matters for alignment.

count and for_each

Compare Terraform's two meta-arguments for creating multiple copies of a resource or module, and understand why for_each is usually the safer choice.

LlamaIndex Cheat Sheet

Ingest, index, and query your own data for LLM apps using LlamaIndex's data connectors, indices, retrievers, and query engines.