I have heard that when developing application which uses a database you should do database unit testing. What are the best practices in database unit testing? What are the primary concerns when doi...

This is the first time, my team has asked me to do some testing on Database which I have no clue how to approach. By testing on database I mean, I need to see how fast it can insert records into it...

I am working on a Flask app for APIs and created few Flask-SQLAlchemy models. I have written a function which takes a list of dictionaries and insert them into Postgres database model tables as row...

I have basically a testing scenario, where I Create database Fill it with some data Execute the business logic to be tested, which modifies the data. I don't own the business logic implementation ...

I really can't seem to find an accurate explanation on why you should use the same database in development as in production. I personally love using sqlite3 in development (it's light, easy to use,...

I've been doing a lot of sproc programming in MySQL lately. And I must say that I like it. A lot. However debugging these babies sucks. Anyone know of any tools that can put some happiness ...

I want to create unit tests that cover code that use relational database in Play framework 2.1.0. There are many possibilities for this and all cause problems: Testing on in-memory H2 database Pl...

Usually migration script is simple like adding new column or so and if applications if deployed then everything is ok. but sometimes there is some complex logic involved that should be tested. what...

Does anybody know of a framework (or methodology) to unit test stored procedures just using SQL and be able to produce a reasonable report as to what has passed and what has failed (something simil...

Is it possible to load multiple flat xml datasets on PHPUnit to load lots of fixtures? We are writing a rather complex application and the xml dataset is getting pretty big, so I would like to sli...

I've been using sqlite::memory: for unit tests: it is quick, and makes test clean-up automatic. But I'm concerned my tests could be missing bugs due to SQL server assumptions. (This particular code...

How would I use NUnit and a test database to verify my code? I would in theory use mocks (moq) but my code is more in maintenance shape and fix it mode and I don't have the to setup all the mocks. ...

Our database is poorly designed all the way around (we inherited it). I've reworked the schema to something useable and maintainable. Quite a few tables and columns have been dropped, many columns ...

When you are doing integration tests with either just your data access layer or the majority of the application stack. What is the best way prevent multiple tests from clashing with each other if t...