Introduction The Olivere’s Elastic package library is a very popular third-party driver for Elasticsearch. This tutorial will explain how to install the Olivere Driver in Golang on a server’s $GOPATH and how to use it to connect to Elasticsearch. The Oliver driver supports multiple versions of Elasticsearch and this tutorial will also cover how to … Continued
Introduction to creating MongoDB queries and filters in Golang If you’re working with MongoDB and Golang, it’s important to know how to create and format MongoDB filter queries so that they can be passed into method calls. Fortunately, this process is fairly simple and straightforward. In this article, we’ll show you how to create BSON … Continued
Introduction In this article we wil show you how to join three tables in PostgreSQL. In previous articles we have seen the introduction of the JOINs in PostgreSQL. The purpose of JOIN was to merge two tables column wise rather the merging the rows like the union operator. In many scenarios we need to merge … Continued
Introduction In this article we will discuss about the self-join principle of PostgreSQL, but first we have to see what a Join is and how it is used in database systems. After we explain the JOIN basics we’ll show you how to do the self-join in PostgreSQL. JOIN In database management systems we often have … Continued
Introduction Are you looking to hone your SQL chops? We have started a new series called The PostgreSQL Challenge that will put your PostgreSQL skills to the test! We’ll give you a task to accomplish with a SQL query and you’ll see if you can come up with the correct SQL query. There’s always multiple … Continued
Casting data types in Postgresql Data conversion is common in all programing paradigms especially when handling transactions in the databases. Like in other databases postgresql database provides for CAST operations which enable conversion of one data type into another. There are various cast operations in postgresql for converting string to integers, casting to Boolean, casting … Continued
Introduction IT pros have been comparing PostgreSQL and MySQL for over a decade, and with good reason. While MySQL has been a force to be reckoned with for some time, PostgreSQL is seen as the better administrative tool for a number of reasons. While MySQL remains popular mainly due to it being included with all … Continued
What is SQL Cross Join? How to use Cross Join? In the last few articles, we discussed a lot about joins in SQL. Today, we are going to talk about “cross join”, another type of join in SQL. What is CARTESIAN JOIN or CROSS JOIN in SQL? With a Cross Join, you will see all possible conditions … Continued
Introduction In this article we’ll take a look at the CONFIG GET’s companion, CONFIG SET. We’ll look at the command’s basic syntax and give you a reference for all the configuration settings that are available. Without further ado, let’s jump in. What does the CONFIG SET command do? The CONFIG SET command lets you set … Continued
Introduction In this article we’ll take a look at the CONFIG GET command. We’ll take a look at some of the command’s options and we’ll run the command on our local Redis instance so you can see what type of results to expect. What does the CONFIG GET command do? The CONFIG GET command lets … Continued
