AI Wisdom
Learning Track

Databases

PostgreSQL, Redis, Cosmos DB, pgvector, Pinecone — relational, cache, NoSQL and vector storage with production-grade patterns.

13+
Topics
8
Published
100%
Free
Browse articles ↓

13 articlesin Databases

Databases
UsersApp serverVector index

Vector Database Selection for Production RAG

Cosmos DB, AI Search, Qdrant, Pinecone — benchmarks, cost, and operational complexity for production vector search.

Updated 9 min
Read →
Databases
Order servicePartitioned tableThis monthLast monthOldest monthPartition manager

Partitioning and Sharding: Range, Hash, List, and Hot Partitions

AdvancedPRO

Vertical vs horizontal vs sharding, range/hash/list strategies, Postgres declarative partitioning + pg_partman, drop-old-partitions instead of DELETE, Cosmos hierarchical partition keys, verifying pruning with EXPLAIN.

Updated 14 min
Read →
Databases
CustomerStore appcustomersordersorder_itemsRead model

Normalization: 1NF to 3NF, Denormalize Reads, Snapshot Truths

Intermediate

1NF/2NF/3NF/BCNF in plain English, when to denormalize via materialized views or CQRS read models, snapshots vs duplication, REFRESH MATERIALIZED VIEW CONCURRENTLY, propagating changes via CDC.

Updated 12 min
Read →
Databases
CustomersStore appConstraintscustomersordersorders_historyMigration

Schema Design: Keys, Relationships, Tenancy, and Audit

Intermediate

Surrogate (UUIDv7/bigint) vs natural keys, foreign keys + CHECK constraints, audit columns + history triggers, soft delete with partial indexes, multi-tenancy patterns + Postgres RLS, junction tables for N:N.

Updated 15 min
Read →
Databases
Support agentsSearch appWeaviateKeyword scoreVector scoreLabelled queries

Weaviate 1.27+: Multi-Tenancy, Dynamic Indexes, and Generative Search

AdvancedPRO

Weaviate 1.27/1.28 multi-tenancy, dynamic indexes (flat → HNSW), text2vec/generative modules, gRPC v4 clients, hybrid alpha, generative-openai for RAG-in-one-call, tenant offboarding.

Updated 14 min
Read →
Databases
CustomersHelp-centre appYour databaseServerless indexTenant A namespaceTenant B namespaceReranker

Pinecone Serverless: Namespaces, Hybrid Search, and Reranking

Intermediate

Pinecone serverless GA (2024), namespaces for multitenancy, sparse-dense hybrid, .NET PineconeClient, batch upserts, metadata filtering, built-in rerankers (BGE/Cohere), tenant offboarding via DeleteAll.

Updated 13 min
Read →
Databases
ShoppersStore APIPostgresEmbedding columnHNSW indexFull-text searchDedicated vector DB

pgvector 0.8/0.9: HNSW, halfvec, and RAG on Postgres

AdvancedPRO

pgvector 0.8 (Oct 2024) iterative scans + halfvec, 0.9 sparse vectors, HNSW vs IVFFlat, EF Core + Pgvector.EntityFrameworkCore, halfvec/bit quantization, hybrid search with tsvector, maintenance_work_mem for builds.

Updated 14 min
Read →
Databases
CustomersStore APIPartition APartition BPartition CChange feedRead view

Azure Cosmos DB: Partition Keys, RUs, and the Five Consistencies

AdvancedPRO

Cosmos DB SQL API, 5 consistency levels, partition-key design (10GB cap, hot-partition avoidance), RU/s autoscale vs serverless, CosmosClient v3 Direct mode + DefaultAzureCredential, point reads (1 RU), change feed, hierarchical partition keys, vector search GA.

Updated 15 min
Read →
Databases
ShoppersCatalogue APIproductsreviewsSchema validatorCompound index

MongoDB 8.x: Embed vs Reference, ESR Indexes, and the Aggregation Pipeline

Intermediate

MongoDB 8.0 (Oct 2024) / 8.2, queryable encryption GA, Cosmos DB for MongoDB vCore + DocumentDB, MongoDB.Driver 3.x LINQ, embed-vs-reference rule, ESR compound indexes, partial/TTL indexes, aggregation pipeline, atomic positional updates.

Updated 13 min
Read →
Databases
ShoppersStore appRedisDatabaseCartsTop sellers

Redis 8 / Valkey in 2026: HybridCache, Streams, and Distributed Locks

Intermediate

Redis 8 tri-licensing (AGPLv3, SSPLv1, or RSALv2) + the Valkey LF fork, Azure Cache Enterprise, HybridCache (L1+L2 + stampede protection), atomic rate limiting, SET NX EX + Lua compare-and-delete locks, Streams + consumer groups, sorted-set leaderboards, and TTL jitter.

Updated 14 min
Read →
Databases
Buyer ABuyer BCheckoutRow lockStock rowordersOutbox

Transactions and Isolation: ANSI Levels, MVCC, and SERIALIZABLE

AdvancedPRO

Four ANSI levels, MVCC vs 2PL, EF Core BeginTransactionAsync, [Timestamp] rowversion optimistic concurrency, FOR UPDATE SKIP LOCKED, write-skew, retry on 40001/40P01 with exponential backoff, transactional outbox over 2PC.

Updated 14 min
Read →
Databases
AnalystReport codeOne set-based queryDatabaseIndex on the sortQuery plan

SQL Patterns: Joins, Window Functions, MERGE, and Killing N+1

Intermediate

N+1 to JOIN/LATERAL, EXISTS vs IN vs JOIN, ROW_NUMBER/RANK/SUM OVER, ANSI MERGE in PG 15+, ON CONFLICT upsert, Dapper parameterization, EXPLAIN read guide, NULL semantics + OR-defeats-index pitfalls.

Updated 16 min
Read →
Databases
CustomersStore APIorders tableQuery planMatching indexAutovacuumPgBouncer

PostgreSQL 18/19 in 2026: MVCC, Indexes, and EF Core

Intermediate

PostgreSQL 18 asynchronous I/O and PostgreSQL 19 changes, MVCC + xmin/xmax, btree/GIN/GiST/BRIN, JSONB jsonb_path_ops, partial/functional indexes, EF Core + Npgsql, EXPLAIN (ANALYZE, BUFFERS), VACUUM and PgBouncer pitfalls.

Updated 17 min
Read →