Jan 25 · 4 min read · Most people hear Subquery, OuterRef, and immediately think: This is some database wizard stuff. I’m out. But in reality, it’s just Django helping you ask smarter questions to your database. Let’s walk through a real-world example you’ll actually us...
Join discussion
Jan 16 · 4 min read · In the previous post, we explored how querying works in JCR, the different query languages available in AEM, and what actually happens when a query is executed under the hood. Now it’s time to zoom in on the most commonly used — and most misunderstoo...
Join discussionJan 16 · 4 min read · In the previous post, we built a strong foundation by understanding what JCR is, why it exists, and how AEM uses Apache Jackrabbit Oak as its underlying content repository. We explored nodes, properties, node types, CRX, and CRXDE — the building bloc...
Join discussionJan 13 · 3 min read · If querying tells us what data we want from the repository, indexing decides whether AEM survives the request or collapses under it. Now comes a critical question: How does AEM efficiently search through millions of nodes without slowing to a crawl?...
Join discussionJan 4 · 18 min read · While revising SQL, I realized that I keep making the same notes again and again. So I decided to document everything in one place for quick reference. As I was writing, I thought—why not share it as an article? It might help others who are learning ...
Join discussion
Jan 1 · 5 min read · If you come from an imperative programming background, such as JavaScript, Python, or C++, SQL can feel counterintuitive. You define a variable, and one line later, the compiler tells you it doesn't exist. This isn't a syntax error on your part; it i...
Join discussion
Dec 26, 2025 · 3 min read · EF Core treats all SQL commands (Selects and modifications via SaveChanges) under the same logging category: Database.Command. As long as we have LogLevel.Information and LogTo enabled, they will appear in the console. Here is an example that explici...
Join discussionDec 22, 2025 · 5 min read · 1. Fundamentals of Execution In EF Core, you build queries using LINQ (Language Integrated Query). Deferred Execution: Methods like Where, OrderBy, and Select return an IQueryable<T>. They do not hit the database. They simply build the SQL statement...
Join discussionDec 20, 2025 · 15 min read · In the rapid software development lifecycle of today, the management and integration of different cloud services, APIs, and data sources can easily become a complicated and time-consuming task. Developers are required to handle various tools, SDKs, a...
TTech commented
Dec 17, 2025 · 2 min read · GraphQL is powerful… but messy formatting is a universal developer enemy. One minute you have neatly aligned fields,next thing you know someone pastes a huge unformatted query that looks like: {user(id:"1"){name email posts{title comments{body author...
Join discussion