Topic
ElasticsearchIntermediateDynamic mapping made your field text, so term queries miss, and mappings can't be changed in place. Use keyword fields, then reindex behind an alias with zero downtime.
#indexing#schema-design#troubleshooting
TiDBAdvancedSequential keys send every insert to one Region on one TiKV node. Spot the hotspot, then fix it with AUTO_RANDOM, SHARD_ROW_ID_BITS and pre-split Regions.
#performance#scalability#schema-design
InfluxDBIntermediateEvery distinct tag value creates new series. Unbounded tags such as IDs and URLs cause slow writes, query timeouts and OOMs. Measure cardinality and fix the schema.
#performance#schema-design#troubleshooting
Google BigQueryBeginnerOn-demand BigQuery bills the bytes a query reads, and LIMIT doesn't reduce them. Use partitioning, clustering, dry runs and byte caps to control cost.
#cost-optimization#performance#schema-design
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
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
PostgreSQLBeginnerA founder's guide to choosing PostgreSQL or MySQL: team experience, managed hosting, scaling paths, extensions, licensing, switching cost, and a clear "pick PostgreSQL unless" rule.
#db-administration#scalability#schema-design
PostgreSQLBeginnertimestamptz doesn't store a time zone, and timestamp silently drops the offset you pass in. What each type really stores, where timestamp causes bugs and the one case where it's right.
#data-types#schema-design
