Web hosting plans

In this blog post I am going to walk through the web hosting plans I have personally used, their pros and cons and also compare different hosting options that are available in the market.

Welcome back to my another blog post. Today I am going to share my experience hosting my websites. We will explore different options available in the market, their pros and cons and which option to pick and at what stage. I will also talk about my mistakes and lessons learned over the years. I hope this will act as a reference for someone out there thinking of hosting their first website. So, let's get started.

The beginning

I started making websites back in 2012, when I was a college student. Since 2014, I have been hosting my websites. Earlier I used to make static websites using just HTML, CSS and JavaScript along with jQuery.

By 2013, I was making dynamic websites using PHP and MySQL database and in 2014 I created my first website dyclassroom.com, an educational website. Over the years, I have deployed simple static websites, custom dynamic websites, websites using CodeIgniter framework, WordPress websites and blogs, websites built using React, Next.js, monoliths and microservices etc.

Read more

PostgreSQL - Data Types

In this tutorial we will learn about of the commonly used data types in PostgreSQL.

About Data Types

Data types tells us about the type of data that is stored in a column.

Following are some of the commonly used data types in PostgreSQL.

• Numeric Type
• Boolean Type
• UUID Type
• XML Type
• JSON Type
• Monetary Type
• Character Type
• Binary Type
• Date/Time Type

Numeric Type

Numeric types helps us to store numbers. The following table lists the different numeric types.

• Integer
• Numeric and Decimal
• Floating point
• Serial

Integer

These data types are used to store integer values like -2, 0, 10 etc.

Data Type	Size (byte)	Min value	Max value
smallint	2	-32768	+32767
integer	4	-2147483648	+2147483647
bigint	8	-9223372036854775808	+9223372036854775807

Numeric and Decimal

Numeric and Decimal are of variable size as the precision is user specified.

Data Type	Size (byte)	Range
numeric	variable	up to 131072 digits before the decimal point; up to 16383 digits after the decimal point
decimal	variable	up to 131072 digits before the decimal point; up to 16383 digits after the decimal point

Read more...

PostgreSQL - Getting Started

This is an introduction to PostgreSQL database.

What is PostgreSQL?

PostgreSQL is a RDBMS or Relational Database Management System. It is one of the popular and most advanced open source relational database and was developed at Berkeley Computer Science Department (University of California).

Versions of PostgreSQL

PostgreSQL can be installed on Windows, Mac and Linux personal computers and can also be installed on servers like Google Cloud, AWS (Amazon Web Services) etc.

Connecting to the database using psql

After installing the PostgreSQL database on your computer you can connect to it using psql command from your terminal.

Read more...

How to install Postgres.app to use PostgreSQL database on Mac

In this tutorial we will learn to install Postgres.app to use PostgreSQL database on Mac.

What is Postgres.app?

Postgres.app is a full-featured PostgreSQL installation packaged as a standard Mac app. -- https://postgresapp.com

Download

Visit postgresapp.com and download the software on your Mac.

Run the installer and move the Postgres.app into the Applications directory.

Default settings

Postgres.app will install on your Mac with the following default settings.

Host	localhost
Port	5432
User	your system user name
Database	same as user
Password	none
Connection URL	postgresql://localhost

Read more...

ES6 - Template Literals (Template strings)

Watch the video tutorial: ES6 Template Literals (Template strings) #02

In this ES6 JavaScript tutorial we will learn about Template Literals (Template strings).

What are Template Literals?

Template literals are string literals that allows us to embed expressions, multi-line strings and string interpolation.

Template literals are enclosed using backtick ` ` instead of single quotes and double quotes.

Let's print the string Hello World using single and double quotes.

console.log('Hello World');
console.log("Hello World");

Now, let's print the same string using template literal.

console.log(`Hello World`);

Read more...

ES6 - var let const

Check out the tutorial video: ES6 var let const #01

In this ES6 JavaScript tutorial we will learn to create variables using var, let and const.

The var keyword

Alright, let's begin by creating a variable using the var keyword.

Let's say we want to create a variable x and assign it a value 10. So, we will write the following line.

var x = 10;

Now, if we want to print the value of x we can console log it by writing the following line.

var x = 10;
console.log(x);

And we get the output 10.

Few important points we must note while using the var keyword to declare variables.

We can redefine the same variable x again and we will not get any error.

So, we can write something like the following.

var x = 10;
console.log(x); // 10
var x = 20;
console.log(x); // 20

Read more...

How to install PostgreSQL on Mac using Homebrew

Click the link: "How to install PostgreSQL on Mac using Homebrew"

In this tutorial we will learn to install PostgreSQL database on Mac using Homebrew.

Prerequisite

It is assumed that you have Homebrew installed on your Mac.

If you don't have Homebrew installed on your Mac then open Terminal and run the following command.

$ /usr/bin/ruby -e "$(curl -fsSL https://raw.githubusercontent.com/Homebrew/install/master/install)"

Alright, time to install PostgreSQL on Mac.

Install PostgreSQL using Homebrew

In Terminal run the following command to install PostgreSQL on Mac using Homebrew.

$ brew install postgres

Start PostgreSQL

To start PostgreSQL run the following command in the Terminal.

$ brew services start postgres

Stop PostgreSQL

To stop PostgreSQL run the following command in the Terminal.

$ brew services stop postgres

Restart PostgreSQL

To restart PostgreSQL run the following command in the Terminal.

$ brew services restart postgres

Read more...