Thursday, March 28, 2019

Generating a JSON Array Using Oracle SQL/PLSQL

How to build a JSON Array from the results of a SQL Query in Oracle ?

Thursday, January 10, 2019

Detached HEAD in GIT and how to fix it .

What is a 'Detached HEAD' state ?

When you do a "git checkout" you determine which revision of your project you want to work on . GIT then places all the files in that revision in your working folder . We usually do a git checkout on a branch name . However, you can also checkout on a commit id . This is when the detached HEAD state comes into picture .

Monday, November 5, 2018

Plotting functions in R

Exploratory data visualization is the main strength of R. R is more flexible and efficient compared to other data visualization tools and programming languages like D3. In this post we will see the different graphical facilities available in R.

Tuesday, October 30, 2018

R - Vector Arithmetic

So far in our earlier posts we have seen how to create vectors and various operations on vectors like sorting. In this post we will learn to do arithmetic operations on vectors and see how these are helpful for data analysis.

Friday, October 26, 2018

R - Sorting Vectors

For Data Analysis we will often have to order or sort data in increasing and decreasing orders . In this post let's see how to use sorting functions on our CO2 emission dataset.

Wednesday, October 24, 2018

R - Working with Vectors


Complex datasets are usually broken down into components that are vectors. For example, in a dataframe such as the CO2 emissions seen in the earlier post , each column is a vector.  

Tuesday, October 23, 2018

R - Data Types , Data Frames and Vectors


Variables in R can be different types and we need to distinguish numbers from character strings and tables from simple lists of numbers .To distinguish numbers from characters we always use quotes("") for characters.  The function class() helps us determine the type of an object .
 > a <- 2
>class(a)

Thursday, October 18, 2018

Integrating with a payment gateway In angularjs



How to integrate with payment gateways when using angularjs?

When building angular web applications you will at some point want to integrate with certain payment gateways or some 3rd party external urls . Mostly these external urls accept certain post parameters which needs be passed from the calling application .

Tuesday, October 16, 2018

R programming - Introduction and Basics


Introduction
This is my first post on R programming. In this series of posts , we will cover the building blocks of R I.e different data types used , Vectors ,Operations on these vectors like Vector Arithmetic, Sorting , indexing , plots , programming basics of R i.e using the conditional operators , for loops , functions etc. I will not be covering installation since there are various existing detailed sources available . 

Thursday, October 11, 2018

Working with Git Submodules


A submodule is a repository embedded inside another repository. The submodule has its own history; the repository it is embedded in is called a superproject. Submodules can be used for at least two different use cases:

Wednesday, October 10, 2018

Git Basics - Clone ,Init , Add , Commit , Reset ,Rm ,Status


Git is a version-control system for tracking changes in computer files and coordinating work on those files among multiple people. It is primarily used for source-code management in software development, but it can be used to keep track of changes in any set of files.

Monday, October 8, 2018

Creating custom directives in AngularJS


What are custom directives in AngularJS and how to use them ?

Wednesday, July 18, 2018

Installation and Project Setup - Angular 6


This is my first post on Angular 6 . In this post, we will install all the required tools and then  see how to create a sample Angular 6 project using npm and Angular CLI .

Monday, June 25, 2018

Encoding and Decoding in Web Development


In this post , we will see how to handle encoding and decoding of data in javascript . Recently , I worked on a project where I had to read paragraphs of data stored in a database column which can be of type VARCHAR2 or CLOB .  This data needs to be transmitted as JSON and then after some processing , should be displayed on a web page . This data had some special  characters like à  stored in the database .When i rendered this content in a browser  surprisingly I saw some weird characters  instead of the character à . Debugging this issue seemed like a nightmare before understanding the encoding and decoding concepts . So let’s understand these concepts first and then see a solution to such problems .