Indexes play a big part in SQL optimisation. Used properly, indexes can increase the efficiency of a SQL query by a factor of 10 or more. But is the index a panacea? If indexes can improve efficien...
Chang Wan
Cancel
Is the Index a Panacea?
Understanding Databases
Contents Introduction to Databases A Brief History of Databases What is the Difference Between DB, DBS and DBMS? What are the major DBMSs? SQL vs No...
Clean Code: Emergency
Emergent design offers a practical approach to achieving clean code, focusing on simplicity, clarity, and maintainability. By adhering to the four simple rules, developers can navigate the complexi...
Clean Code: Systems
In essence, building clean systems is about crafting a harmonious ecosystem where code not only meets current requirements but is also poised gracefully to evolve with future demands. As we imbue o...
Clean Code: Classes
Contents Class Organization Classes Should Be Small! Class Size The Single Responsibility Principle Cohesion How to Deal With Change? Organi...
OOP vs. POP vs. FOP vs. AOP
Contents Object-Oriented Programming (OOP) Procedural-Oriented Programming (POP) Functional-Oriented Programming (FOP) Aspect-Oriented Programming (AOP) Which One is Better? ...
Null in Java: A Bad Invention.
In the programming field, there are a lot of wrong inventions. Null References is one of them. Java introduced this invention in the initial version, which led many developers to develop the bad ha...
Garbage Collection (GC) in JVM
Garbage Collection is a vital component of the JVM, ensuring efficient memory management and optimizing application performance. Understanding the nuances of JVM memory structure and garbage collec...
Common Commands in JDK
Java Development Kit (JDK) offers commands that are essential for Java development, each serving a specific purpose. Understanding these commands and their parameters is crucial for any Java develo...
What is TDD (Test-Driven Development)?
Test-Driven Development is a powerful methodology that, when implemented correctly, can lead to more reliable, clean, and maintainable code. While it does come with challenges, particularly around ...
