They’ll be an excellent set of questions and typically we won’t get time for them to be answered. However, we’ll add any questions we didn’t get to on this thread for Mirza to answer. Plus I’ll share links to all the things shared.
And feel free to continue the conversation, this thread is an excellent place to do that. Share resources and follow up with success stories from your learnings!
I’d do some research on the tool, first off to see how easy it is to get started with the tool:
How good is the official documentation
Does the tool have an active community of users
How long the tool has been around
Ask for opinions from your team members - this can also provide you with useful insight
Try to find people how used the tool already and talk to them
Analyse your needs (and the needs of your project) to see if the tool meets those needs
Does it integrate well with existing tools - if this is required
Trial and error - you learn the most about a tool by trying it on in action. Use it to try to solve a real-time problem you are having at work
In companies I’ve worked in so far the DB testing was done by the DB Admins and/or the DevOps teams.
However, I was always curious about that kind of testing and I’ve done research in the past - just in case someone in the future asks me to preform testing on a database.
The xUnit family of testing frameworks has extensions for doing database testing - for example JUnit has the DbUnit extension which can be used for testing relations databases using Java. Microsoft (SQL Server) and Oracle (Oracle SQL Developer) also have DB testing functionality built into their tools.