Learn Web3 in 100 Days - Day 9: SQL

By xuanling11 | Crypto Learning | 14 Apr 2022


Let’s explore deeper into SQL.

 

Table of Contents

What is SQL

Web3 Database

Data

Web2 vs. Web3

Front-end + Spectrum = Web3

Web3 Database

In Conclusion

 

 

 

What is SQL

SQL or Structured Query Language is a programming language to manage relational databases and perform operations with data. Similar to excel spreadsheets, SQL is a way to manipulate databases through programming or execution commands.

 

SQL is fairly simple. Users just need to input a command and request the machine to output data from the database.

 

The simple line of code you need to know is:

 

SELECT * FROM Customers

 

It translates to human language as selecting all (* means) data from (FROM) the column name Customers (Customers).

 

You can learn the rest here.

 

Web3 Database

Here is where things set apart from Web2 and Web3 significantly. You may constantly hear someone referring like these:

  • Web1: read
  • Web2: read, write
  • Web3: read, write, own

 

So why do people refer to those? The key is who controls data.

 

Data 

ae53837f9eb6141b7ecde7fb5cb600afb05b6905046302faa316a3ed7b3804af.png

Image Credit: https://techjourneyman.com/blog/web3-explained/

 

In the programming world, data is the blood of the program. Without data, a program acts like a zombie.

 

In Web2, corporations are built to possess large amounts of data and store it in their possession.

 

More specifically, users are providing all kinds of data corporations can exploit which include your privacy. You have no control over the data that is being used. Whether it is to create an algorithm to analyze your behavior or many unknown projects corporations can do.

 

Users leave the dust without any information about where their data is being used and the result of such data contribution is voluntary or involuntary. That is a price to pay when using their products and services. Whether you like it or not.

262d67ac0d3c7afe638cdea3f20f69168829c2e690c8cd826f3a8f99300d01a5.png

Image Credit: https://techjourneyman.com/blog/web3-explained/

 

Web2 vs. Web3

d6d86b447e78f182f4ad143fd739f3b6afc1e798332285b394f3af43323ef9a3.png

Image Credit: https://techjourneyman.com/blog/web3-explained/

 

From Web2, when you visit a website, you load everything that is owned by one company. In Web3, you visit a website where User Interface and Data Access are located in separate locations and only you can access that data through a specific way to verify you as only a person that can access your own data.

 

Front-end + Spectrum = Web3

82050694a72c636522c86744c50153030b520e9ebdf1e7b9eb3904409d8a384e.jpg

Image Credit: https://edgeandnode.com/blog/defining-the-web3-stack

 

Front-end is the program to provide how websites structure and interact with internet servers. Back-end provides programs that offer access to exclusive databases from the corporations and provide results that may or may not show to users. For example, in Meta (Facebook), the like number count is generated through a back-end program. In Web3, no one controls data and there is no database but a blockchain that publishes data in public. You do not program to access exclusive databases, rather you are using a protocol and interacting with it. Web3 Dev Nader refers to the Web3 stack. You will have a variety of tools to choose to build your Web3 depending on the types of blockchain you choose from and based on how decentralized, scalable, and secure you want your project to become.

 

Web3 Database

When it comes to databases, it becomes centralized and even claimed to be decentralized. Distributed databases are closed to decentralization without possession of data. There will be a whole another discussion on databases. However, many projects are working to approach a decentralized database as possible while offering database security of a database.

 

In Conclusion

Now you have learned SQL and Web3. You can continue learning coding from different perspectives!

 

Keep learning.


Photo by Jan Antonin Kolar on Unsplash
Note: the post was shared on multiple platforms here.

You can refer my previous article lists here and here
------------------------
2022 Prediction
2022 Prediction #1: L1 Scalability
2022 Prediction #2: L2 Bridges
2022 Prediction #3: Zero-Knowledge Proofs or ZKPs
2022 Prediction #4: Regulated Defi On-Chain KYC
2022 Prediction #5: Institutional Crypto Adoption
2022 Prediction #6: Defi Insurance
2022 Prediction #7: NFTs-Based Communities - DAO 1.5
2022 Prediction #8: Metaverse and NFTs
2022 Prediction #9: Web2 Companies’ FOMO
2022 Prediction #10: Time for DAO 2.0
------------------------
DAO The Way
DAO The Way Part 1
DAO The Way Part 2
DAO The Way Part 3
DAO The Way Part 4
DAO The Way Part 5
DAO The Way Part 6
DAO The Way Part 7
DAO The Way Part 8
DAO The Way Part 9
DAO The Way Part 10
DAO The Way Part 11
DAO The Way Part 12
------------------------
Learn How To Defi
Learn How To Defi Part 1
Learn How To Defi Part 2
Learn How To Defi Part 3
Learn How To Defi Part 4
Learn How To Defi Part 5
------------------------
Crypto Comics
Crypto Comics
Crypto Comics - PoW
Crypto Comics - Who is Satoshi
Crypto Comics - What is Token
Crypto Comics - What is DeFi
Crypto Comics - What is Wallet
Crypto Comics - What is HODL
Crypto Comics - What is Coinbase
Crypto Comics - What is PoS
Crypto Comics - What is DAO
Crypto Comics - What is A Block
Crypto Comics - What is NFT
Crypto Comics - What is Fork
Crypto Comics - What is Web3
Crypto Comics - What is DeFi-2
Crypto Comics - What is Yearn Finance
Crypto Comics - What is Degen
Crypto Comics - What is Aping
Crypto Comics - What is Cold Wallet
Crypto Comics - What is Hot Wallet
Crypto Comics - What is Airdrop
Crypto Comics - What is DYOR
Crypto Comics - What is 65537
Crypto Comics - What is RC4
Crypto Comics - What is WAGMI
Crypto Comics - What is Bagholder
Crypto Comics - What is Decentralization
Crypto Comics - What is Wallet Address
Crypto Comics - What is Plagiarism in Web3
Crypto Comics - What is Bart Pattern
Crypto Comics - What is Encryption
Crypto Comics - What is Consensus
Crypto Comics - What is Protocol
Crypto Comics - What is Stablecoin
Crypto Comics - What is ApeCoin
Crypto Comics - What is FOMO
Crypto Comics - What is Tokenomics
Crypto Comics - What is APR
Crypto Comics - What is to The Moon
------------------------
Learn Web3 in 100 Days
Learn Web3 in 100 Days - #1 What is the Internet and How Relevant to Web3
Learn Web3 in 100 Days - Day 2: What are the Browsers and Servers
Learn Web3 in 100 Days - Day 3: What are HTTP Status Code
Learn Web3 in 100 Days - Day 4: HTML and CSS and JS
Learn Web3 in 100 Days - Day 5: What is programming
Learn Web3 in 100 Days - Day 6: Markup, Elements, Tags, and Hyperlinks
Learn Web3 in 100 Days - Day 7: Style Your Web
Learn Web3 in 100 Days - Day 8: JS
------------------------
Modern Economic Nonsense
Modern Economic Nonsense - Inflation and Incentives
Modern Economical Nonsense - The Astrologist's Way
-------------------------------------------------------------------------------------
Disclosure: The article was written by a delusional author who is possibly a nut job without any questions whatsoever about expertise in the subject matters. You should not believe any words this author wrote or you may experience similar symptoms or even possibly become a nut job.

How do you rate this article?


30

1

xuanling11
xuanling11

A delusional author who is possibly a nut job without any questions whatsoever about expertise in the subject matters to write with a freestyle.


Crypto Learning
Crypto Learning

All article was written by a delusional author who is possibly a nut job without any questions whatsoever about expertise in the subject matters.

Send a $0.01 microtip in crypto to the author, and earn yourself as you read!

20% to author / 80% to me.
We pay the tips from our rewards pool.