Database

Testability of Database Applications

Reading Time: 2 minutes Testability Testability is a non-functional requirement important to the testing team members and the users who are involved in user acceptance testing. Testability is mainly depends on the degree on which software team works like SRS (software requirement specification) FRD (Functional Design document) Software system, etc. Support testing for the software application under test. Minimum number of test cases that covers the entire testing scope Continue Reading

Couchbase : How to access and change the document of size more than 2.5Kb.

Reading Time: < 1 minute We faced a situation were we have to firstly see the data and then change it accordingly in couchbase, but the GUI of couchbase doesn’t allows us to see the data of size more than 2.5kb and forget about changing, So there is a quick hack of how you can actually change the data without using the GUI and just by making a curl request: Continue Reading

Couchbase: Quering data bucket with Partial id.

Reading Time: 2 minutes Introduction: In this article I am going to explain how to get documents from data bucket, if you only have partial Id, in other words using LIKE operation of Sql in couchbase by using Views of Couchbase. For Example: I have these four documents in my bucket, and I want to get all the documents having starting “abc”, then it must retrieve all the three Continue Reading

Solution for Riak 500 Internal Server Error

Reading Time: < 1 minute I am new to Riak and learning it. Few days ago, I got 500 Internal Server Error exception while inserting data in a Riak bucket. It was weird because I was able to insert same data in different bucket. I tried to find out root cause, but didn’t get success. After beating my head whole day, I posted it on Roak forum and stackoverflow. I Continue Reading

Google Apps Script : Connectivity with Google Cloud SQL Database that lives in Google’s cloud

Reading Time: 2 minutes Google Cloud SQL is a MySQL database that lives in Google’s cloud. It has all the capabilities and functionality of MySQL. Google Cloud SQL is easy to use, doesn’t require any software installation or maintenance and is ideal for small to medium-sized applications. Google Cloud SQL allows you to create, configure, and use relational databases that live in Google’s cloud. It is a fully-managed service Continue Reading