Jan 24 · 4 min read · When developers start learning databases, the first milestone is usually this: “I know how to write SELECT, INSERT, UPDATE, and DELETE.” That’s important — but it’s not enough. Because in real applications, most database issues don’t come from wron...
Join discussionDec 18, 2025 · 3 min read · Introduction Many systems collect data again and again: exam results logs events reports from other systems A very common problem appears sooner or later: New data accidentally overwrites old data. This usually isn’t a coding bug.It’s a desig...
Join discussion
Jun 27, 2025 · 6 min read · Materialized View Pattern (Software Architecture) The Materialized View Pattern in software architecture involves precomputing and storing query-specific views of data from one or more sources. It is often used in microservices or CQRS designs to opt...
Join discussion
Nov 4, 2024 · 4 min read · Dimensional modelling is considered as one of the most recognized and preferred techniques for presenting Analytical Data because it addresses two Main requirements: Delivers data that is understandable to Business people. Delivers faster query per...
Join discussionAug 21, 2024 · 3 min read · When selecting a database for your product, it's crucial to evaluate both technical and non-technical criteria. The right choice can significantly impact your system's performance, scalability, and maintainability. Here’s a comprehensive guide to hel...
Join discussionDec 4, 2023 · 2 min read · Not so long ago, Uber created their Database and they named it Schemaless DB. It is not every day that organizations choose to reinvent the wheel. This is an interesting trend in the industry. I found it fascinating and below are reasons why they opt...
Join discussionMay 11, 2023 · 7 min read · Introduction Are your SQL Server queries running slowly? Don't worry, you're not alone. Performance issues are a common problem that developers face when working with SQL Server. Fortunately, there are several quick and easy tips you can use to optim...
Join discussion