Database

presto server using JDBC

Connecting To Presto server using JDBC

Reading Time: 2 minutes Hi Guys, In this blog we’ll be discussing about how to make a connection to presto server using JDBC, but before we get started let’s discuss what Presto is. What is Presto ? So, Presto is an open source distributed SQL query engine for running interactive analytic queries against different data sources. The sizes may ranges from gigabytes to petabytes. It runs on a cluster Continue Reading

Introduction to database migrations using Flyway

Reading Time: 3 minutes Let us first understand why are database migrations necessary? Assume that we have a project called Shiny and it’s primary deliverable is a piece of software called Shiny Soft that connects to a database called Shiny DB. We not only have to deal with one copy of our environment, but with several. So the simplest view of our problem will translate to:

Hive-Metastore : A Basic Introduction

Reading Time: 3 minutes As we know database is the most important and powerful part for any organisation. It is the collection of Schema, Tables, Relationships, Queries and Views. It is an organized collection of data. But can you ever think about these question – How does database manage all the tables? How does database manage all the relationship? How do we perform all operations so easy? Is there Continue Reading

Neo4j with Scala : User Defined Procedure and APOC

Reading Time: 5 minutes In the last blog Getting Started Neo4j with Scala : An Introduction which got the overwhelming response from Neo4j and Dzone. We discussed about how to use Neo4j with Scala. For recap Blog and the Code. Now we are going to take one step ahead . As we know that in the Relational Database, Procedure provide advantages of better performance, scalability, productivity, ease of use Continue Reading

Getting Started Neo4j with Scala : An Introduction

Reading Time: 3 minutes Earlier we used Relational Database for storing the data but there we store data in predefined table and than we define foreign key for references between tables or rows. We are using this in present time also. Now when we talk about the graph database, we stored data in the nodes. Graph database provides us flexibility to arrange data in easy way. When we transform Continue Reading

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

Knoldus Pune Careers - Hiring Freshers

Get a head start on your career at Knoldus. Join us!