About Vipin Raj

Vipin Raj is a web developer specialized in PostgreSQL Database and Data Modeling, the man behind technobytz and a tech enthusiast. Having 3+ years of experience in the IT industry, he is currently pursuing his masters in computer science and information security. He spend his free time writing blog posts with the intension of sharing his knowledge to the tech community.
Vipin Raj has written 31 articles so far, you can find them below.

How to Access Ubuntu PC Files From Your Android Phone

I recently purchased a Xiaomi Mi Pad tablet running Android KitKat. I had a large collection of movies in my laptop(I use Linux Mint). For some reason I found watching movies from Tablet more convenient than from Laptop. But the problem with watching movies from tablet is that every time when I want to watch […]

Full Story »

How to Install BSNL EVDO in Ubuntu / Mint in 3 Minutes

Configuring BSNL EVDO in Linux variants like Ubuntu, Mint etc is a nightmare for most of us, especially one who enjoyed the easiness of one-click installers available for Windows. But, if you follow the right method, you could understand that it is even easier in Ubuntu than in Windows. So, make sure that your system […]

Full Story »

LIMIT, OFFSET, ORDER BY and Pagination in PostgreSQL

LIMIT and OFFSET are particularly useful clauses in PostgreSQL. LIMIT, as it’s name suggests, limits the number of rows returned in a SELECT query. For instance, if the limit count is 4, maximum of four rows are returned, or less than 4, if the query itself yield less number of rows.   Consider the following […]

Full Story »

LIKE and ILIKE for Pattern Matching in PostgreSQL

LIKE and ILIKE are used for pattern matching in PostgreSQL. LIKE is the SQL standard while ILIKE is a useful extension made by PostgreSQL. To begin with, we will create a tiny table with few random string values. Two of the important selectors in pattern matching with LIKE/ILIKE are the percentage sign(%) and underscore(_). % sign […]

Full Story »

PostgreSQL GROUP BY and Aggregate Functions – Explained

In this post we will discuss about the usage of GROUP BY clause and Aggregate Functions in PostgreSQL. PostgreSQL is having a large number of useful aggregate functions. We will see a few of the most important functions, skipping the common ones like sum(), avg() etc. Consider the following table: Quick Navigation General forrm of GROUP BY GROUP BY […]

Full Story »

PostgreSQL SELECT Query Basics – Tutorial

In this post we will discuss about the usage of SELECT query in PostgreSQL. SELECT Query form the very basic of the Structured Query Language(SQL) standard. Over the years PostgreSQL has added a handful of advanced features to the SELECT Query. Though, SELECT in the purest form works perfectly in PostgreSQL. If you want to learn […]

Full Story »

Xiaomi Mi Pad 2 Specification, Features & Price in India

Xiaomi Mi Pad 2 is the successor of the much appraised tablet – Xiaomi Mi Pad. In this post we are answering all your queries regarding the new Mi Pad 2. What are the major differences from the older Mi Pad ? Well, Mi pad 2 features the new Intel Atom X5-Z8500 64 bit processor […]

Full Story »

How to Install Network Simulator (NS2) & nam in Ubuntu 14.04

NS or Network Simulator is a well known open source tool for simulating wired or wireless computer networks. Nam or Network animator is an animator tool for graphical representation of network traces and real world packet traces. NS and nam can be used together to create a simulated network and analyze it manually or graphically. […]

Full Story »

How to Install PostgreSQL 9.4 in Ubuntu / Linux Mint

This post aims at documenting the complete installation and basic configuration of PostgreSQL 9.4 on an Ubuntu or Linux Mint OS in layman’s terms. This is tested in Ubuntu 14.04.3 LTS and Linux Mint 17.2 Rafaela and should work on other releases also. How to install PostgreSQL 9.4 Server and PGAdmin3 on a clean Ubuntu […]

Full Story »

Install & Configure PgBouncer | Pooling in PostgreSQL #1

This is the first post among the series of posts which demonstrates various tools to set up database pooling in a PostgreSQL database server. In this post we will learn how to install, configure and connect to a database pool using the popular tool – PgBouncer. Table of Contents What is Database Pooling & Why […]

Full Story »
Page 1 of 41234»

Find someting


Stay Connected

Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 24 other subscribers