Tag: Performance
-
There is nothing Random inside a computer
Have you ever wondered how your music app shuffles thousands of songs, or how a video game generates a brand new world every time you hit “New Game”? It feels like digital magic. We call it “random,” but in the world of silicon and circuits, true randomness is actually quite hard to find. In fact,…
-
Have you been told “Use plain SQL, its faster than ORM” ?
You might have heard this advice before, Just use SQL; no need for ORMs. At first glance, that sounds elegant. SQL is expressive, close to the metal, and avoids the “magic” of an ORM. But as systems grow, accidental complexity sneaks in, the kind that comes not from business logic, but from all the supporting…
-
Understanding Common Table Expressions (CTE) in SQL — Simplifying Complex Queries
In SQL, we often deal with queries that involve multiple subqueries, aggregations, or recursive lookups. When these start to get long and unreadable, that’s where CTE (Common Table Expressions) come in. Let’s break it down from the basics, What is a CTE? A Common Table Expression (CTE) is a temporary named result set that exists…
-
The Pros and Cons of LocalStorage in Modern Web Development
The Web Storage API allows browsers to store data as key-value pairs, offering more secure and efficient alternatives to cookies. Local Storage retains data beyond sessions, while Session Storage loses it after a page refresh. Security concerns include sensitive data exposure. Developers must encode and encrypt data accordingly.