In this third and final installment on using SQLite from C++, I want to begin exploring some of the internals of this amazing little database engine. SQLite does things quite differently than most ...

Database normalization is the cornerstone of database theory. Once a database is normalized, relationships between the data in multiple tables must be established. A hefty part of designing a ...

Surrogate means a stand-in, a substitute. Surrogate keys take the place of a natural key as the primary key within a database table. Ideally, surrogate keys stand in the shadows and are used in ...