Category
Sort By
SQL (structured query language) is the building block of data engineering, it plays a significant role in managing, manipulating, organizing, and retrieving data in relational databases. In data engineering, huge volumes of data with increasing complexity are processed on a daily basis, and to manage it, data engineers work on distributed...
We all have search functionality in our applications. It is one of the most core features you would find ranging from searching for users, products, companies, etc. But are you sure your search functionality is doing exactly what it is supposed to do? You might have written test cases for it as well. But still, there are things...
SQL Joins are used to combine documents/rows from 2 or more tables based upon common field present in them. MongoDB 3.2 launched the most awaited feature "Joins" which is supported in SQL database however was not present in the earlier version of MongoDB. This feature will change the way you design your database schema and application...
In the previous blogs, Overview of Database Testing and What should we test in a Database we got a fair idea about database testing concepts and types of database testing. Now with this blog, we are moving a step ahead to enhance our knowledge by defining the keys steps that will help in performing “Database Testing” DBMS vs RDBMS ...
In the previous blog on Overview of Database Testing, we had discussed the basic concepts like database, database testing, the need for database testing and how to perform database testing. In this blog, we will be diving deep into the world of database testing and throw some light on what we need to test in a database? Types of Database...
With a mushrooming number of internet users, the data creation, storage, and retrieval has reached new heights and so has the number of issues arising due to these activities. The major source of origin of these failures/defects lies in minimal attention paid towards database handling and testing. So what do we understand by Database and...
Hi guys, Recently as part of a project, I had to populate a SQLite database with large amounts of data pertaining to a number of classes requiring more than 5000 inserts and updates per class. I created a new SQLite database using Groovy's Sql class. The initial strategy involved creating prepared statements and executing individual...
While debugging a domain and its database schema I found an interesting grails command line Gant script: schema-export. One of the great Grails command line Gant script to generate SQL scripts(DDL) which is executed against your database to model your grails domain. You can control the environment and the output file to generate the...