Skip to content
Latest:
  • Day 10: Context Windows — The Key Architectural Constraint
  • Day 9: LLM Inference Fundamentals — Temperature, Top-P, and Sampling
  • Day 8: Running LLMs Locally with Ollama & LM Studio
  • Day 7 — Setting Up Your AI Engineering Environment
  • Day 6 — Open-Source AI Ecosystem in 2026
LEARNCSDESIGN

  • Home
    • All Posts
  • AWS
    • Configuration
      • YAML
    • CloudFront
  • Microservices
    • Security
    • Cross-Cutting Concerns
    • Service Discovery
    • Observability
    • External API
    • Communication
      • Protobuf
      • RabbitMQ
    • Data
    • Deployment
    • Decomposition
  • Design Patterns
    • Creational Design Patterns
    • Structural Design Patterns
    • Behavioral Design Patterns
  • Code
    • Python
    • JSON
    • Web3
    • Git
    • Maven
    • UML
    • Go
    • Java
    • Elasticsearch
    • Docker
  • SQL
    • MySQL
  • REST
  • System Design
  • AI

MySQL

MySQLPopular PostsSQL
Neeraj Kushwaha

Best practices for storing passwords securely in a database

This is the 4th post in a series on MySQL performance. A hacker can also read passwords if you can. Adobe

Read More
MySQLSQL
Neeraj Kushwaha

Understanding MySQL Joins

This is the 3rd post in a series on MySQL performance. An SQL query walks into a bar and sees

Read More
MySQLSQL
Neeraj Kushwaha

Optimizing MySQL performance by using EXPLAIN — Query Execution Plan

This is the 2nd post in a series on MySQL performance. The previous post discussed the types of indexes and

Read More
MySQLSQL
Neeraj Kushwaha

Optimizing MySQL performance through indexing

This is the 1st post in a series on MySQL performance. An index that makes the query fast is the

Read More

Recent Posts

  • Day 10: Context Windows — The Key Architectural Constraint
  • Day 9: LLM Inference Fundamentals — Temperature, Top-P, and Sampling
  • Day 8: Running LLMs Locally with Ollama & LM Studio
  • Day 7 — Setting Up Your AI Engineering Environment
  • Day 6 — Open-Source AI Ecosystem in 2026
  • Day 5 — The Frontier Model Landscape: GPT, Claude, Gemini, and Beyond
  • Day 4 — Tokens, Embeddings & Semantic Space
  • Day 3 — The Transformer Architecture Deep Dive
  • Day 2 — How Large Language Models Actually Work?

“Walking on water and developing software from a specification are easy if both are frozen”

Copyright © 2026 LEARNCSDESIGN. All rights reserved.
Theme: ColorMag by ThemeGrill. Powered by WordPress.