Longer-form writing on software engineering, databases, and lessons learned while building.
Mastering uv by Astral(founder: Charlie Marsh). An ultra fast alternative to pip and conda for modern Python development.
An in-depth overview of JSON Web Token (JWT), explaining Access and Refresh tokens, token sliding mechanisms, and strategies to implement secure CSRF protection.
A deep dive into Python virtual environments, using pip for web applications and conda for machine learning and data science workflows.
A comprehensive guide to Git, covering version control fundamentals, branching strategies, merging workflows, and best practices for collaborative software development.
This post describes the basics of database normalization, including normal forms 1NF, 2NF, 3NF, BCNF, 4NF, and 5NF
A beginner-friendly guide to Docker, covering containerization basics, Docker architecture, Dockerfiles, images, containers, volumes, networks, and Docker Hub.
A deep dive into SQL JOINs, covering INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL OUTER JOIN and SELF JOIN with examples and best practices for database querying.
A deep dive into Representational State Transfer APIs, covering REST architecture principles, HTTP methods, stateless design & best practices for building scalable web services.
Overview of various database like RDBMS (MySQL, PostgreSQL, MsSQL, Oracle), NoSQL (MongoDB, Cassandra), OODBMS (objectDB, db4o) & DB GUIs like DBeaver, MySQL Workbench, phpMyAdmin, pgAdmin, and MongoDB Compass.
Advanced SQL concepts including Subqueries, Common Table Expressions (CTEs), and Window Functions such as LAG, LEAD, RANK, ROW_NUMBER, and SUM OVER with detailed examples.
No results found. Try a different search term.
