nosql Archives - ITNotes

Mastering MongoDB Indexing: ESR Rule and Query Profiling with explain()

October 10, 2026

Slow MongoDB queries usually trace back to misplaced compound index keys and expensive in-memory sorts. Learn how to profile query execution plans with explain() and apply the Equality, Sort, Range (ESR) rule to cut query latency from seconds to milliseconds.

Database

MongoDB Aggregation Pipeline: Process, Group, and Transform Complex Data

October 8, 2026

After six months running MongoDB's aggregation pipeline across two production deployments, here's an honest comparison of approaches, real performance numbers, and practical code examples covering grouping, array unwinding, joins, and time-based reporting — from basic stages to full Python integration.

Database

Getting Started with Neo4j and Cypher: Modeling and Querying Complex Relationships

October 6, 2026

Tired of slow multi-table SQL joins? Learn how to run Neo4j with Docker, model complex graphs, and write Cypher queries for fast relationship traversals.

Database

Ditch the Database Sprawl: Why ArangoDB is My Go-To for Multi-Model Apps

August 24, 2026

Tired of managing separate databases for documents and graphs? Discover how ArangoDB's multi-model approach and AQL query language can simplify your tech stack and improve performance.

Database

Beyond Schema Migrations: Mastering MySQL Document Store with X DevAPI

July 12, 2026

Transform MySQL into a powerful NoSQL database. Learn how to use the X DevAPI to manage JSON collections, perform schema-less CRUD, and join NoSQL data with SQL tables.

Database

Apache HBase: Wide-Column NoSQL Database for Sparse Data at Billion-Record Scale

June 17, 2026

Apache HBase is a wide-column NoSQL database built on Hadoop HDFS, purpose-built for storing and querying billions of sparse records with high write throughput. This guide covers the HBase data model, practical setup in Java and Python, how to design row keys that avoid hotspots, and a clear comparison against Cassandra and Cloud Bigtable to help you choose the right tool for your scale.

Database

Deploy FerretDB on Docker: MongoDB-Compatible Open Source Database Built on PostgreSQL

June 5, 2026

FerretDB is an open-source proxy that lets you use MongoDB drivers and tooling while storing data in PostgreSQL — Apache 2.0 licensed, no SSPL. This guide covers deploying FerretDB with Docker Compose, connecting via mongosh and PyMongo, and knowing when it's the right fit for your stack.

Database

Why SurrealDB is the Only Database You Need for Your Next Project

May 30, 2026

Tired of syncing SQL and NoSQL? Learn how SurrealDB combines document, graph, and relational models into one ultra-fast database with built-in auth and real-time queries.

Database

Beyond the Scaling Wall: Why I Switched to ScyllaDB for High-Velocity Data

May 12, 2026

Ditch the JVM pauses. Learn how ScyllaDB uses a C++ shard-per-core architecture to deliver microsecond latency for 2M+ ops/sec applications. Covers setup, CQL modeling, and performance traps.

Database

Stop Treating DynamoDB Like SQL: A Practical Guide to Single-Table Design

May 6, 2026

Is your DynamoDB schema actually a SQL database in disguise? Learn how to use single-table design to consolidate data, reduce network latency, and optimize your serverless application for scale.