Testing
Software testing is the process of analyzing program components, programs, and systems with the intention of finding errors in them, and to determine or check their technical limits and requirements.
The database is a specific system that requires special approaches for testing. This is because the behavior of database software components (views, stored procedures, or functions) may depend not only on their code, but also on the data. In many cases, functions are not immutable. This means that executing them again with the same parameters can produce different results.
That is why we should use specific techniques to test database modules. PostgreSQL provides some features that can help developers and testers in doing this.
In software ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access