sub-languages of sql

Different sub-languages of SQL.


When we talk about databases. One of the biggest types that exists is SQL. SQL or Structured Query Language is used where you have to keep data that is relational in nature. Mysql, Postgres, DB2 are the different software that implements it. SQL comprises of many sub-languages that provide different capabilities to SQL. The capabilities

What exactly are APIS and how to build one?

What are APIS and how to build API?


If you are working in software or IT industries, this is one of the word that you may hear alot. Many of you are well aware of what exactly are apis and how to build one. For those who are not aware, In this article i will try to tell you the basics of apis.

Web Socket implementation using Socket.io

Web Socket implementation using Socket.io


We learn about web sockets and how they solve the problems caused by pooling. You can read it here if you missed it. In this article we are going to talk about the implementation of web sockets. Web Sockets and how they solve the problem caused by pooling. For the article I am assuming that

Continuous Integration for your open Source project.


You must have heard of travis or jenkins if not you can read about them if you click on their name. Now you want continuous integration or lets leave this word. Lets say you want to run some command whenever you are committing something on github. Say you want to run test case, code quality

What are AMP or accelerated mobile pages

WordPress plugin to make your website AMP compatible.


First, AMP stands for amplified web pages. In recent year everyone is trying to increase the reach of data to bigger audience that to using less data. These efforts leads to technologies like PWD and AMP. These technologies make use of components like service worker and optimized javascript to make it less data costly and

What are PWA or progressive web apps?

What are PWA or progressive web apps?


Progressive web apps can appear to the user like traditional applications or (native) mobile applications. This new application type attempts to combine features offered by most modern browsers with the benefits of mobile experience. It is available only for chrome for now. Now lets see What are PWA or progressive web apps? PWA or progressive web apps

What are AMP or accelerated mobile pages

What are AMP or accelerated mobile pages?


AMP or accelerated mobile pages are pages which don’t contain normal Javascript and are really fast. Also google search engine caches these pages and recognise them as AMP and serve them on mobile devices. It also helps in getting better rank in search engines. Lets see in depth what are AMP or accelerated mobile pages. What