ByteByteGo - Knowledge Categories

[wuyichen24]

Database

Series

• Understanding Database Types Done
• Factors to Consider in Database Selection Done
• Key Steps in the Database Selection Process Done

Selection

• How do you decide which type of database to use?
• iQIYI database selection trees
• How to pick the right database?
• How to choose the right database
• Choose the right database for metric collecting system
• Which database shall I use?

Category

• Cheat sheet of different databases in cloud services
• A handy Cheatsheet for SQL and NoSQL databases
• Distributed SQL

Data structure

• 8 Key Data Structures That Power Modern Databases
• 8 Data Structures That Power Your Databases. Which one should we pick?
• B-Tree vs. LSM-Tree
• The Secret Sauce Behind NoSQL: LSM Tree
• 8 Data Structures That Power Your Databases.

Indexing

• Database Indexing Strategies Done
• Database Indexing Strategies - Part 2 Done

Single database introduction

• Vector databases are so hot right now, but what is a Vector DB?
• What is Serverless DB
• Why is PostgreSQL voted as the most loved database by Stackoverflow 2022 Developer Survey?
• Why do we use column-based DB? Does column-based DB provide better performance?
• Amazon DynamoDB
• Message Queue and NoSQL with 10x Performance Boost

SQL

• SQL Query Execution Order
• How is a SQL statement executed in the database?
• What is the best way to learn SQL?
• Visualizing a SQL query

Other

• What are database isolation levels
• How Discord Stores TRILLIONS of Messages
• How does GraphQL work in the real world?
• Netflix Tech Stack - Databases
• What is GraphQL? Is it a replacement for the REST API?
• Vertical partitioning vs horizontal partitioning

---

Data Engineering

• What are the differences between a data warehouse and a data lake
• Data is used everywhere, but do you know all the commonly used data terms?
• Batch v.s. Stream Processing Done
• ELK Stack
• Which cloud provider should be used when building a big data solution?

---

Load Balancer, API Gateway

• Top 6 Load Balancing Algorithms Every Developer Should Know
• What are the common load-balancing algorithms?
• What are the differences between a load balancer and an API gateway?
• What does API gateway do? (Video) Done
• What is a proxy? Why is Nginx called a reverse proxy?
• Why is Nginx called a “reverse” proxy?
• What does API gateway do?

---

DNS

• How does DNS work?

---

CDN

• A beginner’s guide to Content Delivery Network (CDN)
• What Is A CDN? How Does It Work?
• CDN
• How does CDN work?

---

Cache

• Cache Systems Every Developer Should Know
• A Crash Course in Caching - Part 1 Done
• A Crash Course in Caching - Part 2 Done
• A Crash Course in Caching - Final Part Done
• A Crash Course in Redis
• Top 5 Uses of Redis
• Why is Redis so fast?
• Why is Redis so fast? (video)
• How can Redis be used?
• Where do we cache data?
• Redis vs Memcached
• Cache miss attack
• Top caching strategies
• Why is redis so fast?

---

Message queue

• Why Do We Need a Message Queue? Done
• How to Choose a Message Queue? Kafka vs. RabbitMQ Done
• Why do we need message brokers? Done
• Why is Kafka fast? (YouTube videos) Done
• Why is Kafka fast? (post) Done
• Change data capture (CDC) Done
• At most once, at least once, exactly once Done

---

Security

• What is SSO, or Single Sign-On?
• What is SSO (Single Sign-On)?
• Password, Session, Cookie, Token, JWT, SSO, OAuth - Authentication Explained - Part 1
• Password, Session, Cookie, Token, JWT, SSO, OAuth - Authentication Explained - Part 2
• Token, Cookie, Session
• Oauth 2.0 Explained With Simple Terms
• Explaining JSON Web Token (JWT) to a 10 year old Kid
• How does Google Authenticator (or other types of 2-factor authenticators) work?
• What is a DDoS (Distributed Denial-of-Service) Attack?
• Is HTTPs safe?
• How to store passwords safely in the database? (YouTube video)
• How to store passwords safely in the database and how to validate a password?
• How to design a secure web API access for your website?

---

Network

HTTP & HTTPS

• The Foundation of REST API: HTTP
• Important Things About HTTP Headers You May Not Know!
• Which HTTP status codes are most common?
• HTTP error handling
• How does HTTPS work?
• How HTTPS works
• How does HTTPS work?
• HTTP/1 → HTTP/2 → HTTP/3
• HTTP 1.0 -> HTTP 1.1 -> HTTP 2.0 -> HTTP 3.0 (QUIC) Done
• HTTP 1.0 -> HTTP 1.1 -> HTTP 2.0 -> HTTP 3.0 (QUIC). Done

TCP and UDP

• Everything You Always Wanted to Know About TCP But Too Afraid to Ask Done
• TCP vs. UDP: 7 Differences You Should Know Done
• What protocol does online gaming use to transmit data? TCP or UDP? Done
• TCP or UDP for Zoom? Done

API architecture styles (RESTful, SOAP, RPC, webhook, websocket, long&short pulling)

• Top 6 most popular API architecture styles (Video) Done
• What are the API architectural styles? Done
• How many API architecture styles do you know? Done
• API architectural styles Done
• Network Protocols behind Server Push, Online Gaming, and Emails (WebSocket, RPC)
• What is a webhook (webhook vs polling)
• How to choose between RPC and RESTful?
• Short/long polling, SSE, WebSocket
• RPC vs. gRPC Done
• How does gRPC work? Done
• SOAP vs REST vs GraphQL vs RPC Done

OSI Model

• What is OSI Model
• Network Protocols Run the Internet
• How is data sent over the network? Why do we need so many layers in the OSI model?

Other

• What is Web 3.0?
• JSON visualization tool

---

API

• The 2022 API Platform Landscape: Trends and Challenges by Postman
• How does REST API work? Done
• What Is REST API? Done
• Why is RESTful API so popular? Done
• Mastering the Art of API Design
• Code First v.s. API First - A change of software development philosophy
• Design Effective and Secure REST APIs
• Top 7 Ways to 10x Your API Performance
• URL, URI, URN - Do you know the differences
• Do you know all the components of a URL?
• How to improve API performance
• How do we design effective and safe APIs?

---

Architecure

• Software Architecture Styles
• What distinguishes MVC, MVP, MVVM, MVVM-C, and VIPER architecture patterns from each other?
• Top 10 Architecture Characteristics / Non-Functional Requirements with Cheatsheet
• 9 best practices for developing microservices
• Is microservice architecture the silver bullet?
• Netflix's Overall Architecture
• Top 7 Most-Used Distributed System Patterns
• McDonald’s event-driven architecture
• What tech stack is commonly used for microservices?
• Microservice Architecture
• What does a typical microservice architecture look like?
• Orchestration and choreography

---

CICD

• CI/CD Pipeline Explained in Simple Terms
• What is CI/CD? How does it help us ship faster? Is it worth the hassle?
• What tools does your team use to ship code to production and ensure code quality?
• Top 5 Most-Used Deployment Strategies
• What is the process for deploying changes to production?
• Netflix Tech Stack - Part 1 (CI/CD Pipeline)
• CI/CD Pipeline
• How do companies typically ship code to production?

---

Algorithms

• Consistent Hashing
• Load balancer algorithm
• Algorithms you should know before taking System Design Interviews

---

Virtualization & Containerization

• Docker
• Kubernates
• What are the differences between bare metal, virtual machines, and containers?
• What are the differences between Virtualization (VMware) and Containerization (Docker)?

---

Others

• Common Failure Causes
• Capacity Planning
• [Do you believe that Google, Meta, Uber, and Airbnb put almost all of their code in one repository?](Do you believe that Google, Meta, Uber, and Airbnb put almost all of their code in one repository?)
• What is the difference between Process and Thread? (Video) Done
• Data migration with Avro
• Super high-performance NoSQL and MQ
• Latency Numbers Every Programmer Should Know for the 2020s
• Which latency numbers should you know?
• Resiliency Patterns
• Retry patterns
• Back-Of-The-Envelope Estimation / Capacity Planning
• Five ways to generate distributed unique ID
• Consistent Hashing
• How are notifications pushed to our phones or PCs?
• Internationalization
• Optimistic locking
• Metric monitoring