database engine

The database software itself, such as PostgreSQL, MySQL or SQLite, which decides the features, SQL dialect and extensions available.

In more detail

The engine fixes what the database can do and how it behaves: its SQL dialect, constraint checks, isolation and extensions. Moving between engines is a migration, not a setting change.

Examples

On Amazon RDS the engine is the first choice, and not every extension is supported on a managed service.
In this course: SQL dialect, constraint checks, migrations and isolation behaviour belong to the engine, so tests of those need the real one. Keep business rules in faster unit tests.

Related terms

Taught in

References