3 useful Angular 2 developer tools | Angular 2

Nowadays JavaScript is the most widely used technology for building Web and Mobile based applications. Angular JS is the core reason behind the popularity of JavaScript. It’s time for Angular 2, framework for both Mobile and Web applications. If your are not tried Angular 2 yet, please visit the official site https://angular.io/  for more details. In […]

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 »

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 »

How to render multiple pie charts in a single div? | Zingchart

Zingchart is a popular javascript charting library.It has support for  all kind of charts like pie chart, bar charts, area charts and many more. For more information you can visit the below given link: www.zingchart.com In this blog we will see how we can render a pie chart using zinchart library? And what to do […]

Full Story »

PostgreSQL 9 High Availability Cookbook [Review]

The PostgreSQL 9 High Availability Cookbook written by Shaun M. Thomas, unlike any other PostgreSQL references which concentrate on Postgres programming, focus on the scalability and high availability of a PostgreSQL server. The various recipes available in this book from hardware selection through setting up database pools and cluster control reminds you of a complete […]

Full Story »

How to Install PostgreSQL 9.2 + PostGIS 2.0 in Ubuntu

Though PostgreSQL 9.3 has released, there are people who still uses PostgreSQL 9.2 in combination with PostGIS 2.0. It is fairly easy to install and set-up PostgreSQL 9.2 in Ubuntu. It can be done in no time using any package manager like aptitude or synaptic. But the PostGIS 2.0 version available in apt repository has […]

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

%d bloggers like this: