2022 Developer Survey is open! Take survey.
10 votes

Can a proportionately scaled down testing environment find performance load issues?

No. The items you mention scale very differently and there are far too many factors and resources that will get used. For instance if I time requests on a local server using an application I'll find ...
user avatar
10 votes
Accepted

Can a proportionately scaled down testing environment find performance load issues?

Does this actually catch, before production, many of the "surprise" problems we might anticipate? Or is there a more fundamental flaw in the approach that will cause deleterious changes to pass ...
user avatar
7 votes

Controlling database state in Selenium UI Testing

As UI tests are slowish I think its important to be able to run them in parallel. In order to be able to run them in parallel, your data-management becomes even more complex, since if the tests use ...
user avatar
7 votes
Accepted

QA testing - Database privileges

It depends on how your process is set up. It makes sense to have read-only access to the Production environment for investigation. Does QA have own copy of the system for integration testing (...
user avatar
6 votes
Accepted

Is selenium webdriver capable of database testing?

Selenium itself is only a framework to drive web-browsers, but you can combine it with some code to check and or manipulate the database the application under test uses. If you use Selenium with a ...
user avatar
6 votes

Can existing tests and data effectively compare old and new systems?

Yes this is a useful strategy in converting from one system to another as a one time event (it might span a couple of iterations but the idea is very short term). You could effectively view this as ...
user avatar
5 votes

Is selenium webdriver capable of database testing?

Selenium Webdriver is a web test automation framework and primarily used for functional testing of front-end part of the application (that piece, that the user sees in his/her browser). Since this ...
user avatar
5 votes

Controlling database state in Selenium UI Testing

This is a really interesting question. I don't think we're entirely happy with our approach, and we discuss it regularly, but these are our constraints and what we've done so far (framework has been ...
user avatar
  • 5,085
4 votes

Controlling database state in Selenium UI Testing

It's hard to provide input on your specific processes, but here's how I generally deal with Selenium automation. Maybe it can help you out. One separate database which contains all the data for the ...
user avatar
  • 5,834
4 votes

Comparing Sqlite databases

I have always loved using Scooter Software - Beyond Compare (limited to 2 links) to visually compare between folder, files etc. Group of them or single. This should help with an easy to use Visual ...
user avatar
  • 141
4 votes

How to test CRUD operations in Database Testing?

CRUD stands for Create, Read, Update and Delete. (Retrieve may occasionally be substituted for Read.) Different users may have different CRUD cycles based upon the requirements of the system. A ...
user avatar
  • 4,520
4 votes

Can a proportionately scaled down testing environment find performance load issues?

Presumably the database is just a piece of your overall system, and your goal is to determine whether database changes break things or slow the system down. Using a downsized database is a reasonable ...
user avatar
  • 22.8k
4 votes
Accepted

Should I obtain data required for particular test case using appropriate endpoint or read it directly from the DB?

This depends on what type of testing you implement: If it is a component testing (or if your goal is to test the particular end-point) you should isolate your component from the possible impact of ...
user avatar
  • 11.4k
3 votes
Accepted

How to do more effective database testing?

Reposting from my blog notes Database Testing involves the following Activities for a OLTP System Verify Table Schema, Column names as per Design Document Verify Column Length and DataType Verify ...
user avatar
  • 2,726
3 votes

Is selenium webdriver capable of database testing?

Selenium WebDriver itself cannot be used to test databases, but the language you are using to code your WebDriver tests (eg. C# or Java, etc.) can.
user avatar
  • 183
3 votes

Proper pattern for setting up tests of basic database operations

Based on your response to my comment, you're not actually looking to test database operations but an application that employs the operations. That makes things a little simpler. If you have access to ...
user avatar
  • 30.7k
3 votes

Can a proportionately scaled down testing environment find performance load issues?

Test environment will NOT scale proportionally. But what you can do is: make test environment as similar to PROD as you possibly can (with possibly less servers, that's what we do: have about half ...
user avatar
3 votes

How to perform databse testing in selenium webdriver

Selenium is used for automating user-browser interaction with the HTML and Javascript on websites. It does not have any functionality to test databases other than indirectly through web applications ...
user avatar
3 votes
Accepted

Functional Difference between NUnit and MSTest in VS

Check out the answer to this question over at StackOverflow. (From the accepted answer) NUnit has few advantages over MS-Test Suite attribute - can aggregate tests and execute them separately (...
user avatar
  • 4,030
3 votes

What all do we need to test in the application is undergoing a Mongo upgrade?

With any kind of framework or database upgrade like this, after I'd covered system sanity and critical path regression, I would go through the release notes looking for any changes likely to impact my ...
user avatar
  • 30.7k
3 votes
Accepted

Using a different database engine for testing

I'm a little out of date using sqllite but data types and stored procedures come to mind as feature gaps between sqllite and something like PostgreSQL. Beyond features, configuration settings (ex: ...
user avatar
  • 1,189
3 votes
Accepted

How to create unit tests for Web app with a database

Database shared between tests is a common obstacle. One way ("orthodox") is to insist that unit test should NOT test database (just exercise the tested library), and mock the DB interface. Another ...
user avatar
3 votes
Accepted

Backend testing

Back-end and back-end testing per se is a complex mechanism. Basically anything that communicates with the server or database is back-end. Another definition can be anything under the hood is back-end....
user avatar
3 votes

Can existing tests and data effectively compare old and new systems?

Comparing the old system to the new system given identical inputs and expecting identical outputs is a legitimate test. There are problems, however: a) When the legacy system is retired, the Source ...
user avatar
2 votes

Should data validation be automated in a rapid development environment

(Full Disclosure.... I work for Pragmatic Works) Pragmatic Works' LegiTest allows for automated Data Validation to quickly verify your data is accurate, error-free, and up-to-date between any two ...
user avatar
  • 21
2 votes

Standard set of unit tests for data layer code

From application perspective you need to look at below states for DB to be validated with basic cases Clean up Scripts (Clearing Previous Run Data) Initial Data population (From a fresh install ...
user avatar
  • 2,726
2 votes

Robot Framework data-driven automation testing: Can data derived from a database be used as a data source for a test template?

Since this question was cross-posted to stackoverflow, I'll cross-post my answer: Unfortunately, the use of test templates more-or-less require that the data is hard-coded in the test case. However, ...
user avatar
2 votes
Accepted

How to test database as a manual tester?

Database can be tested various ways, If we are using SQL server then open the SQL query analyzer and write the queries to retrieve the data. Then verify whether the expected result is correct or not. ...
user avatar
  • 338
2 votes

Is it necessary to verify databases for functional automation testing?

I believe it is a very good idea read back from the database. The reason is that things sometimes (or often) are not quite as simple as they may look. In the example above: what happens if the phone ...
user avatar
2 votes
Accepted

Handle conflicts in parallel execution of jUnit testruns using the same database

No magic bullet. If you have a "multi-tenant" schema -- a schema that represents multiple, independent sets of data -- you may be able to run each concurrent test in a different data set. It is ...
user avatar
  • 22.8k

Only top scored, non community-wiki answers of a minimum length are eligible