Topic
Neo4jBeginnerMERGE creates the whole pattern if any part is missing, and it can't stop concurrent duplicates without a constraint. How to merge correctly and clean up existing duplicates.
#concurrency#data-modeling#troubleshooting
ScyllaDBIntermediateA query without the partition key means a full cluster scan. When ALLOW FILTERING is fine, and how query-first tables, materialized views and global indexes fix the rest.
#data-modeling#indexing#nosql
Cloud FirestoreBeginnerFirestore only supports equality, ranges and array-contains. Prefix queries, keyword arrays, a synced search engine and vector search each fit a different need.
#data-modeling#indexing#nosql
MongoDBBeginnerTwelve common MongoDB relationships, from user addresses to org charts, each with an embed, reference or hybrid verdict, the document shape and the reason.
#data-modeling#nosql#schema-design
MongoDBAdvancedA complete schema for a multi-tenant project tracker: collections, types, ESR indexes checked with explain(), validation, migrations, write concerns and sharding readiness.
#data-modeling#indexing#nosql
Throttled at 30% usage? Throughput is split across physical partitions, so one hot partition key throttles alone. Diagnose it, then fix keys, RU costs and scaling.
#data-modeling#performance#troubleshooting
MongoDBAdvancedSeven ordered questions that decide embed, reference or a hybrid, the mechanical cost of each choice, and a help desk schema worked through end to end.
#data-modeling#nosql#schema-design
MongoDBIntermediateA catalogue of twelve MongoDB modeling patterns, each with a document shape, the query or update that uses it, and what it costs.
#data-modeling#nosql#schema-design
MongoDBIntermediateHow to design a MongoDB schema from the workload, the hard limits that constrain it, and seven anti-patterns with a way to detect and fix each.
#data-modeling#nosql#performance
Scan with a FilterExpression still reads and bills every item. Use GSIs, sparse indexes and composite sort keys instead, and know when to send queries elsewhere.
#data-modeling#indexing#nosql
PostgreSQLBeginnerHow to choose between PostgreSQL, MySQL, SQLite and MongoDB for a web app, where Redis and a search engine fit, a decision table by app type, and when the PostgreSQL default is wrong.
#data-modeling#scalability#schema-design
