MySQL: Large VARCHAR vs. TEXT?

on

If we look at for the first time, then it seems like TEXT and VARCHAR can store the same information. But, there are fundamental differences between the two. The way TEXT fields and VARCHAR fields...

Read More

Top 10 query language for JSON

on

JSONiq JSONiq is a query language that is outlined for the widely known JSON data model. The most important conceptions of jSONiq were derived from the hard learnt lesson for over 30 years of relational...

Read More
on in Software

The tutorial discussed below provides with all the necessary skills that are required to work with a software project. In this tutorial we shall learn about undoing the last Git commit. At any stage you may arrive with a query in mind of undoing something. This is a human tendency which makes up the mind...

[ Click to Continue ]
on in NoSQL

SQL is the abbreviation to Structured Query Language. It is a language widely used to create and manage DataBase Management Systems or DBMS. The use of SQL is a sequel to the relational model databases emerged in the 70’s. SQL databases are essentially relational model databases and they have a relationship between the data. The...

[ Click to Continue ]
on in Java

As a newbie programmer with java web world you will be facing this dilemma identifying difference between JSP and Servlet that experience programmer talk about or you read it in books, so let’s get started I’m going briefly over what servlet and JSP gives you individually and their pros and cons. Java Server Pages JSP...

[ Click to Continue ]
on in Hadoop

Pig is nothing but “High-level data flow scripting language” what I mean by high-level is that PIG will take care of all those low level programming that you need to write when using MapReduce to run your jobs in Hadoop Cluster as in MapReduce you need to write a lots of Java code to talk...

[ Click to Continue ]
on in MongoDB

Before going in detail about types of indexes in MongoDB let’s talk a little about what indexes does in your database and how it help you to speed up your database search queries. When we create index on table field what actually does is create meta data on that field of a table and point...

[ Click to Continue ]