Side by side
NBi vs pgtestdb
Both stand on database testing tools. Which one you can start free with, which one lets you read the code, and what each costs once you pay.
Free plan Windows
Pick NBi if you need a free, open-source way to define BI checks in XML and run them through NUnit on Windows. Look elsewhere if your environment requires NUnit 3.x or you need a commercial licence.
Visit NBi Free plan Self-hosted
Choose pgtestdb if your Go tests need isolated PostgreSQL databases, especially when you want parallel execution and integration with common migration tools. It requires a running Postgres server with database and role creation permissions, so teams without that infrastructure should look elsewhere.
Visit pgtestdbThe facts
| NBi | pgtestdb | |
|---|---|---|
| Free plan | Yes | Yes |
| Open source | Not published | Not published |
| Runs on | Windows | Self-hosted |
| Lowest paid plan | Free or on request | Free or on request |
| Plans published | 1 | 1 |
| Maker | Not published | Not published |
| Website | nbi.io | github.com |
| On database testing tools | #15 of 28 | #19 of 28 |
NBi: what it does well
- Open-source framework available free of charge plan.
- XML test specifications do not require C# authoring.
- Targets databases, cubes, ETLs, and reports.
- GenBI and genbiL can automate large test-suite creation.
- Automation documentation covers Azure DevOps and AppVeyor.
What to know first
- Windows platform listed.
- Requires .NET Framework 4.5 or higher and NUnit 2.x.
- The maker says no commercial licence is available.
pgtestdb: what it does well
- Creates a separate migrated database for each test.
- Clones a template database, with creation described as taking about 10 milliseconds.
- Supports parallel tests with separate databases.
- Includes adapters for eight migration tools and supports custom migrators.
- Keeps failed-test databases and logs a connection string for inspection.
What to know first
- Requires users to provide a running Postgres server.
- The server user needs permission to create databases and roles.
- The default test role cannot create extensions by default.
- Highly parallel suites can exceed the server’s connection limit.