SQL Server34
General18
PostgreSQL17
MongoDB12
MySQL11
Oracle Database9
SQLite8
Redis7
Apache Hadoop5
Apache Cassandra3
Elasticsearch2
IBM Db22
Microsoft Access2
Apache CouchDB1
ClickHouse1
Cloud Firestore1
CockroachDB1
Couchbase1
DuckDB1
Google BigQuery1
InfluxDB1
Milvus1
Neo4j1
Qdrant1
ScyllaDB1
Snowflake1
Supabase1
TiDB1
TimescaleDB1Articles
page 2 / 13
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
RedisIntermediateRedis and Memcached compared by mechanism: threading, slab vs allocator memory, expiry and eviction, persistence, clustering, meta commands, operations and licensing, with a recommendation.
#caching#internals#nosql
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
RedisAdvancedEach Redis cache pattern with code, guarantees and failure modes, then the stale-set race, why delete beats update, versioned writes, outbox and CDC invalidation, and what to use for which data.
#caching#concurrency#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
RedisBeginnerWhat to cache, string vs hash, key naming, how TTLs and expiry work, maxmemory and every eviction policy, a working cache-aside example, and the commands to measure and secure a Redis cache.
#caching#configuration#nosql
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
Valkey is the BSD-licensed fork of Redis 7.2. What's compatible, what has diverged since, how to migrate with replication, and when staying on Redis makes more sense.
#caching#configuration#nosql
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
