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
- Amazon RDS — Amazon Relational Database Service, which runs relational database engines such as PostgreSQL and MySQL as a managed service.
- relational database — A database that stores data in tables and links rows in one table to rows in another through shared key values.
- SQL — The standard language for defining, querying and changing data in a relational database.
- database — A program that stores data in an organised way and answers questions about it, such as PostgreSQL.
- fake — A test double that is a small but working implementation of a dependency, such as an in-memory database standing in for a real one.
- integration test — A test that checks several real parts working together, such as the service talking to a real database.
Taught in
- Managed Relational Databases (RDS) — Cloud Infrastructure & Hyperscaler Architecture
- Testing With Real Databases — Automated Testing, TDD & Quality Engineering