Programming Notes

General Terms: DataBase: A container in which we can store data in an organized manner. SQL: SQL is a language which we use to talk to Database. DBMS: A software which can understand SQL or Database language and can manage database. Server: A physical device where data is stored. Although it is not the only task of the server, but it is one of its tasks among running actual website code, accept http requests etc. Analogy: So, database is just collection of files in an organized manner i.e the data organized in any format (tables, key values etc) is named as database. It is similar to the concept, if we organize our data in some format which we decide to follow, then we would call it our database. At the end of the day, it is just data that is being stored on some storage device and in an organized manner. That's what happens in case of server, data is stored in an organized manner in specialized storage device of the server. Schemas: a category or logical container, it is like a vi...

  Why We Need ISPs Without ISPs, every business would need a unique wire to every single customer in the world. And every customer would need a unique wire to every business. This is a mess, and it's physically impossible. ISPs solve this. They act as the middleman. You only need one wire to your ISP, and they handle the rest. How It All Works Everyone Connects to an ISP: Clients (like us) connect to an ISP. Businesses (like websites and servers) also connect to an ISP. The ISP gives an IP address to each connected router or device. This is its unique address on the internet. A Request is Made: When a request for a website comes from you, your ISP's router sees the destination IP address of that website. The Delivery Job: Same ISP: If the website's IP address is on the same ISP's network, the ISP just sends the data directly to the server. Different ISP: If the website's IP address is on another ISP's network, your ISP sends the request to that other ISP. I...