Engineering Journal

A collection of practical engineering notes, case studies, architectural decisions, performance investigations, and lessons learned while building software systems.

The goal is simple:

Document real engineering problems, decisions, trade-offs, and lessons in a way that other engineers can learn from.

---

📚 Engineering Articles

Backend & API

• Why Entity Framework Queries Become Slow in Complex Reporting Systems?

• When Should You Use Raw SQL Alongside Entity Framework?

• REST API Design: Practical Decisions That Matter

Databases

• When Should You Use Redis Cache in Enterprise Applications?

• How Do You Troubleshoot High Database CPU Usage in Production?

Architecture

• How Do You Implement Data-Level Authorization in Enterprise SaaS Applications?

AI & Machine Learning

• Building a RAG Knowledge Assistant from the Ground Up: Architecture, Decisions, and Lessons Learned

• Before the LLM: Can a Machine Learn With Just a Few Numbers?

---

🚧 More Articles Coming

The Engineering Journal will continue to grow across areas such as:

• Backend Engineering
• REST APIs
• Databases
• System Integration
• Software Architecture
• Cloud & AWS
• AI Engineering
• Large Language Models
• Performance Engineering

---

🎯 Engineering Philosophy

• Build maintainable software
• Design before coding
• Understand the problem before choosing the technology
• Measure before optimizing
• Keep solutions simple
• Learn from production problems
• Never stop learning

---

🤝 Connect

• LinkedIn: https://www.linkedin.com/in/anparmar/