Menu

SQL queries to perform CURD operations

Standard Query Language is frequently referred to as SQL queries are the statement to create, update and delete the records from the database table in SQL and NoSQL database.

Let's understand the different types of queries that we use to perform operations in the database table. 


SELECT * FROM "user"
WHERE enabled = 'false'


SELECT * FROM "user"
WHERE email IN ('yumfawa48@gmail.com','rashid.jorvee@gmail.com')


UPDATE "user"
SET enabled='true'
WHERE id='sql-tutorial'

What is Fascism?

Fascism is a term that referred to an environment created by people with fascist thought.

Who is fascist

Fascist is one who thinks he/she only have the right to live and use all the natural resources which is available on the earth and the universe, rest of the people who don't fit in their criteria or group has no right to live and have food.

Fascist society

A fascist society is a society where discrimination on the basis of color, race, faith, and sex takes place with the support of law enforcement agencies or government and with little contribution of the judiciary. 



How hostname get resolved?

When we browse any website we use the hostname or domain name to access that website. Have you ever wonder how that hostname is getting mapped in the server and point to right application server to deliver the content to your browser? In this article we will study and understand how the hostname getting resolved on the server.

An application that is installed in our server can be accessed via browser, using IP address and port number or hostname. When you installed at that there is no hostname, you have only IP address to access, just for example in our local machine we use 127.0.0.0 

Resolving Hostname

 If we want to use a hostname instead of an IP address to connect to a remote device, the device that we are using to make the connection should be able to translate the hostname to an IP address. There are two ways to resolving a hostname to IP address. The first is creating host table on each router, and second is to build a Domain Name System(DNS) server.

1. Using Host Table

A host table provides name resolution, it does that only on the specific router that it was built upon. We use below command to build a host table on a router.

ip host <host_name> <port_number> <ip_address>

Note: default port number is 23.

2. Using Domain Name System(DNS)

If we are working with multiple devices, then we need not to create host table in each devices, instead of that we use DNS server to resolve the hostname.   


Hence, DNS server makes the things easy and easy to maintain the entries in compare to host table.