Database, Grails

SQL Wildcards..is Your Application Safe?

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...

by Sachin Gulati
Tag: SQL
18-May-2017

MongoDB, Technology

The Most Awaited Feature “SQL Joins” is Now Available in MongoDB 3.2

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...

by Pawan Goyal
Tag: SQL
17-Nov-2016

Database, Manual Testing

How to Perform Database Testing?

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 ...

by Sankalp Grover
Tag: SQL
25-Jul-2016

Database, Manual Testing

What Should We Test in Database?

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...

by Rachit Sethi
Tag: SQL
25-Jul-2016

Database, Manual Testing

Overview of Database Testing

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...

by Rachit Sethi
Tag: SQL
20-Jun-2016

Database, Grails

Batch update performance enhancements using SQL withBatch()

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...

by Roni C. Thomas
Tag: SQL
05-Jul-2011

Database, Grails

Grails domain class and DDL sql file using schema-export

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...

by Bhagwat Kumar
Tag: SQL
04-May-2011