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 4 / 13
ClickHouseIntermediateTOO_MANY_PARTS means too many small inserts, not too much data. Batch your writes, turn on async inserts, and stop over-partitioning your MergeTree tables.
#configuration#performance#troubleshooting
SQL ServerAdvancedA table-by-table workflow for tuning existing SQL Server indexes: find unused and overlapping indexes, merge them, and replace blanket rebuilds with statistics updates.
#db-administration#indexing#maintenance
RedisIntermediateWrites fail and reads still work. Understand Redis eviction policies, find what's filling memory, and pick the right fix depending on whether Redis is a cache or a datastore.
#caching#configuration#nosql
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
PostgreSQLIntermediateSide-by-side SQL for the differences web developers hit daily: quoting, case sensitivity, identity columns, RETURNING, upserts, booleans, JSON, GROUP BY, full-text search, migrations and time zones.
#data-types#migrations#orm
PostgreSQLIntermediateA session doing nothing can stop VACUUM from cleaning every table and stall your next migration. Find them, kill them safely and prevent them with the right timeouts.
#maintenance#mvcc#transactions
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
PostgreSQLIntermediateThe old UUID performance problem came from UUIDv4's randomness, not UUIDs themselves. How UUIDv7 changes the trade-off, what the extra 8 bytes still cost and when to pick each.
#data-types#indexing#schema-design
PostgreSQLAdvancedExplains by mechanism where InnoDB or PostgreSQL does less work for lookups, updates, joins, connections and replication, then shows how to benchmark your own workload with pgbench and sysbench.
#internals#mvcc#performance
MySQLIntermediatePage 1 takes 5 ms and page 5,000 takes 4 seconds. OFFSET reads and throws away every skipped row. Switch to keyset (cursor) pagination for constant-time pages.
#indexing#pagination#performance
PostgreSQLIntermediateA reference comparison of PostgreSQL and MySQL: storage and MVCC, isolation defaults, DDL, data types, indexes, replication, licensing and tooling, with a decision summary.
#indexing#internals#replication
