An instance is the actual data present in a database at a specific moment — the current set of rows, sitting inside the schema's structure.
Why This Matters
- This chapter closes the Schema/Instance pair: schema is the unchanging shape, instance is the constantly-shifting content.
- Every single INSERT, UPDATE, and DELETE you'll ever run changes the instance, never the schema.
Core Concept
- A database's Instance is its actual data at a given point in time — every row, in every table, right now.
- The same schema can have infinitely many different valid instances — an empty database and that same database after a year of real usage share one schema but have two completely different instances.
Deep Dive
- Instance changes constantly and casually — every insert, update, and delete changes it — while schema changes deliberately and rarely.
- When people say a database "is empty" or "has grown to 10 million rows", they're describing its instance, not its schema — the schema could be identical in both cases.
Interview Questions
beginner
What's the difference between a schema and an instance?
A schema is the fixed structural design of a database — its tables, columns, and types. An instance is the actual data present at a specific moment — the current rows sitting inside that structure. The schema rarely changes; the instance changes constantly.
Chapter Summary
An instance is a database's actual data right now — the ever-changing content inside the schema's fixed shape. Together, schema and instance are the two halves of "what does this database look like".