Databases & APIs Cheat Sheets

Amazon DynamoDB | CheatSheets Hub

Managed NoSQL database service. Use single-table design for related entities

dynamodb, aws, nosql, database, serverless

Apache Cassandra | CheatSheets Hub

Distributed NoSQL database. Design schema around query patterns, not normalization

cassandra, nosql, database, distributed

Apache Kafka | CheatSheets Hub

Distributed streaming platform. Kafka guarantees order within a partition only

kafka, streaming, messaging, event-driven

Apache Superset

Apache Superset cheat sheet covering charts, SQL Lab, dashboards, filters, and data exploration with open-source BI.

API Gateway Routing

Configure routes, integrations, stage variables, and rate limits.

api gateway, routing, proxy, throttle

API Rate Limiting

Throttling patterns to protect APIs from abuse

api, rate limiting, throttling, quota, token bucket

ASP.NET Core | CheatSheets Hub

Cross-platform .NET framework. Use Entity Framework Core for database operations

asp.net, dotnet, c#, web api

BigQuery SQL Cheats

Write efficient queries that honor partitions and clustering.

bigquery, sql, partitioning

Cassandra Time-Series

Model time-series partitions via composite keys and TTL.

cassandra, time series

ClickHouse

ClickHouse queries, optimization, and data types for analytics

clickhouse, olap, analytics, database, queries

CockroachDB

CockroachDB distributed SQL database

cockroachdb, distributed sql, postgresql, database, cloud native

CouchDB | CheatSheets Hub

NoSQL document database. CouchDB excels at offline-first applications

couchdb, nosql, document database, apache

Data Backup Strategy

Define RPO/RTO, snapshot cadence, and test restores

backups, rpo, rto, snapshot, retention

Elastic Index Management

Use index templates, ILM policies, and rollover aliases to control growth.

elasticsearch, ilm, index

Firebase | CheatSheets Hub

Google's mobile and web development platform. Use Firebase emulator suite for local development

firebase, google, backend, baas

GraphQL

GraphQL queries, mutations, and schema

graphql, api, queries, mutations

GraphQL Caching

Shared caches, TTL strategies, and avoiding stale data

graphql, caching, dataloader, ttl, invalidation

GraphQL Defer & Stream

Use @defer and @stream directives

graphql, defer, stream

GraphQL Federation

Define schema ownership, share references, and resolve hints

graphql, federation, apollo, subgraph

GraphQL Federation Patterns

Split schemas, assign ownership, and manage shared types.

graphql, federation, apollo

GraphQL Merging Strategies

Combine schemas from multiple services and delegate ownership.

graphql, schema, stitching, ownership

GraphQL Optimization

Key techniques for speeding GraphQL services

graphql, optimization, persisted queries, dataloader

GraphQL Schema Design

Craft types, resolvers, and version-resilient schemas

graphql, schema, types, resolvers, apollo

GraphQL Subscriptions

Schema, resolvers, and security patterns for GraphQL subscriptions

graphql, subscriptions, realtime, websocket, streaming

gRPC | CheatSheets Hub

High-performance RPC framework. gRPC is ideal for microservice communication

grpc, rpc, protocol buffers, microservices

InfluxDB | CheatSheets Hub

Time-series database platform. InfluxDB is optimized for time-series data workloads

influxdb, time-series, database, monitoring

Insomnia | CheatSheets Hub

API client and design tool. Insomnia is a great alternative to Postman

insomnia, api, rest, graphql, testing

Kafka Connect JDBC Sink

Configure JDBC sink connector for writes into Postgres or MySQL.

kafka connect, jdbc

Kafka Consumer Placements

Align partitions with consumers, monitor lag, and prefer cooperative rebalance.

kafka, consumer, partitions

Kafka Schema Registry

Register schemas, enforce compatibility, and version them per topic.

kafka, schema registry

Kafka Stream Processing

Balance topics, partitions, and state for streaming workloads.

kafka, stream processing, connectors

Kafka Streams

Streaming transformations with Kafka and KSQL

kafka, streams, ksql, topology, processors

Kafka TLS Setup

Secure brokers and clients with TLS certificates and JAAS auth.

kafka, tls

MariaDB

MariaDB commands, features, and differences from MySQL

mariadb, mysql, database, sql, queries

Metabase

Metabase cheat sheet covering questions, dashboards, SQL editor, filters, alerts, and open-source business intelligence.

MongoDB

MongoDB queries and operations

mongodb, nosql, database, queries

MySQL

MySQL database commands

mysql, database, sql, mariadb

MySQL GC Optimizations

Adjust `innodb_purge_threads` and buffer pools to keep GC manageable.

mysql, innodb, purge

MySQL Instant Add Column

Use `ALTER TABLE ... ADD COLUMN` with instant add on modern MySQL/Percona.

mysql, instant add column

MySQL Performance Tuning

Monitor buffer pool use, slow query logs, and connection limits.

mysql, performance, innodb, tuning

Neo4j | CheatSheets Hub

Graph database management system. Use graph algorithms for complex path analysis

neo4j, graph database, cypher, nosql

PlanetScale

PlanetScale serverless MySQL database platform

planetscale, mysql, database, serverless, vitess

Postgres Advanced Joins

Use lateral joins, recursive CTEs, and set operators

postgres, joins, lateral, cte, recursive

Postgres Connection Pooling

Tune PgBouncer pool sizes, timeouts, and pool modes.

postgres, pgbouncer, pooling

Postgres Full-Text Search

Index textual columns, define dictionaries, and rank matches.

postgres, full text, tsvector, search

Postgres Indexing

Index types, maintenance, and query tuning

postgres, indexes, optimization

Postgres Performance

Indexes, VACUUM, and configuration hints

postgres, performance, indexes, vacuum, tuning

Postgres Replication

Set up primary/replica, monitor lag, and fail over safely

postgres, replication, streaming

Postgres Replication Lag

Monitor `pg_stat_replication` for lag metrics and handle diverging replicas.

postgres, replication, lag

Postgres Watchdog

Run sentinel queries and restart Postgres when heartbeats fail.

postgres, watchdog

PostgreSQL

PostgreSQL commands and queries

postgresql, postgres, sql, database

Prisma ORM

Prisma database toolkit

prisma, orm, database, typescript, nodejs

Productivity Time-Blocking Systems

Plan days with themed blocks, buffers, and rest periods.

time blocking, productivity, focus

RabbitMQ | CheatSheets Hub

Message broker for distributed systems. Always acknowledge messages after processing

rabbitmq, message queue, amqp, messaging

Redis

Redis commands and data structures

redis, cache, nosql, key-value

Redis Cluster Operations

Manage slot migrations, resharding, and replica promotions.

redis, cluster, slots

Redis Failover Operations

Plan failover, promote replicas, and reconfigure clients.

redis, failover

Redis Memory Optimization

Tune eviction policies, use expirations, and pick compact data types.

redis, memory, optimization, eviction

Redis Persistence Modes

Combine RDB and AOF strategies to match your durability needs.

redis, persistence

REST API Design

RESTful API best practices

rest api, http, web services, api design

SQL

Database queries, joins, and essential SQL commands

sql, database, queries, mysql, postgresql

SQL Index Choices

Choose indexes that match your query filters, sorts, and joins.

sql, index, performance, b-tree

SQLite Database

SQLite database guide with 50+ SQL commands, data types, queries, indexes, optimization, and CLI reference

sqlite, sql, database, queries, cli, mobile database, embedded database, sql commands

Supabase | CheatSheets Hub

Open-source Firebase alternative. Supabase is built on PostgreSQL with full SQL support

supabase, postgres, backend, baas

Temporal Workflow Patterns

Use Temporal for event-driven workflows, retries, and cross-service coordination

temporal, workflow, activities, signals, patterns

Time-Series Modeling in InfluxDB

Structure buckets and Flux queries for efficient time-series analysis.

influxdb, flux, time series

TimescaleDB

TimescaleDB time-series functions, hypertables, and optimization

timescaledb, postgresql, time-series, database, hypertables

Vector DB Search Tuning

Tune distance metrics, embeddings, and filters for fast, relevant vector search

vector search, milvus, pinecone, weaviate, tuning

Web Components API

Native Web Components API - custom elements, shadow DOM, and templates

web components, custom elements, shadow dom, templates, slots

🗄️ Databases & APIs