All Databases & APIs Guides
Amazon DynamoDB
Managed NoSQL database service. Use single-table design for related entities Quick reference guide with examples and best practices. Updated November 2025.
Apache Cassandra
Distributed NoSQL database. Design schema around query patterns, not normalization Quick reference guide with examples and best practices. Updated November 2025.
Apache Kafka
Distributed streaming platform. Kafka guarantees order within a partition only Quick reference guide with examples and best practices. Updated November 2025.
Apache Superset
Apache Superset cheat sheet covering charts, SQL Lab, dashboards, filters, and data exploration with open-source BI. Quick reference guide with examples and best practices. Updated November 2025.
API Gateway Routing
Configure routes, integrations, stage variables, and rate limits. Quick reference guide with examples and best practices. Updated November 2025.
API Rate Limiting
Throttling patterns to protect APIs from abuse Quick reference guide with examples and best practices. Updated November 2025.
ASP.NET Core
Cross-platform .NET framework. Use Entity Framework Core for database operations Quick reference guide with examples and best practices. Updated November 2025.
BigQuery SQL Cheats
Write efficient queries that honor partitions and clustering. Quick reference guide with examples and best practices. Updated November 2025.
Cassandra Time-Series
Model time-series partitions via composite keys and TTL. Quick reference guide with examples and best practices. Updated November 2025.
ClickHouse
ClickHouse queries, optimization, and data types for analytics Quick reference guide with examples and best practices. Updated November 2025.
CockroachDB
CockroachDB distributed SQL database Quick reference guide with examples and best practices. Updated November 2025.
CouchDB
NoSQL document database. CouchDB excels at offline-first applications Quick reference guide with examples and best practices. Updated November 2025.
Data Backup Strategy
Define RPO/RTO, snapshot cadence, and test restores Quick reference guide with examples and best practices. Updated November 2025.
Elastic Index Management
Use index templates, ILM policies, and rollover aliases to control growth. Quick reference guide with examples and best practices. Updated November 2025.
Firebase
Google's mobile and web development platform. Use Firebase emulator suite for local development Quick reference guide with examples and best practices. Updated November 2025.
GraphQL
GraphQL queries, mutations, and schema Quick reference guide with examples and best practices. Updated November 2025.
GraphQL Caching
Shared caches, TTL strategies, and avoiding stale data Quick reference guide with examples and best practices. Updated November 2025.
GraphQL Defer & Stream
Use @defer and @stream directives Quick reference guide with examples and best practices. Updated November 2025.
GraphQL Federation
Define schema ownership, share references, and resolve hints Quick reference guide with examples and best practices. Updated November 2025.
GraphQL Federation Patterns
Split schemas, assign ownership, and manage shared types. Quick reference guide with examples and best practices. Updated November 2025.
GraphQL Merging Strategies
Combine schemas from multiple services and delegate ownership. Quick reference guide with examples and best practices. Updated November 2025.
GraphQL Optimization
Key techniques for speeding GraphQL services Quick reference guide with examples and best practices. Updated November 2025.
GraphQL Schema Design
Craft types, resolvers, and version-resilient schemas Quick reference guide with examples and best practices. Updated November 2025.
GraphQL Subscriptions
Schema, resolvers, and security patterns for GraphQL subscriptions Quick reference guide with examples and best practices. Updated November 2025.
gRPC
High-performance RPC framework. gRPC is ideal for microservice communication Quick reference guide with examples and best practices. Updated November 2025.
InfluxDB
Time-series database platform. InfluxDB is optimized for time-series data workloads Quick reference guide with examples and best practices. Updated November 2025.
Insomnia
API client and design tool. Insomnia is a great alternative to Postman Quick reference guide with examples and best practices. Updated November 2025.
Kafka Connect JDBC Sink
Configure JDBC sink connector for writes into Postgres or MySQL. Quick reference guide with examples and best practices. Updated November 2025.
Kafka Consumer Placements
Align partitions with consumers, monitor lag, and prefer cooperative rebalance. Quick reference guide with examples and best practices. Updated November 2025.
Kafka Schema Registry
Register schemas, enforce compatibility, and version them per topic. Quick reference guide with examples and best practices. Updated November 2025.
Kafka Stream Processing
Balance topics, partitions, and state for streaming workloads. Quick reference guide with examples and best practices. Updated November 2025.
Kafka Streams
Streaming transformations with Kafka and KSQL Quick reference guide with examples and best practices. Updated November 2025.
MariaDB
MariaDB commands, features, and differences from MySQL Quick reference guide with examples and best practices. Updated November 2025.
Metabase
Metabase cheat sheet covering questions, dashboards, SQL editor, filters, alerts, and open-source business intelligence. Quick reference guide with examples and best practices. Updated November 2025.
MongoDB
MongoDB queries and operations Quick reference guide with examples and best practices. Updated November 2025.
MySQL
MySQL database commands Quick reference guide with examples and best practices. Updated November 2025.
MySQL GC Optimizations
Adjust `innodb_purge_threads` and buffer pools to keep GC manageable. Quick reference guide with examples and best practices. Updated November 2025.
MySQL Instant Add Column
Use `ALTER TABLE ... ADD COLUMN` with instant add on modern MySQL/Percona. Quick reference guide with examples and best practices. Updated November 2025.
MySQL Performance Tuning
Monitor buffer pool use, slow query logs, and connection limits. Quick reference guide with examples and best practices. Updated November 2025.
Neo4j
Graph database management system. Use graph algorithms for complex path analysis Quick reference guide with examples and best practices. Updated November 2025.
PlanetScale
PlanetScale serverless MySQL database platform Quick reference guide with examples and best practices. Updated November 2025.
Postgres Advanced Joins
Use lateral joins, recursive CTEs, and set operators Quick reference guide with examples and best practices. Updated November 2025.
Postgres Connection Pooling
Tune PgBouncer pool sizes, timeouts, and pool modes. Quick reference guide with examples and best practices. Updated November 2025.
Postgres Full-Text Search
Index textual columns, define dictionaries, and rank matches. Quick reference guide with examples and best practices. Updated November 2025.
Postgres Indexing
Index types, maintenance, and query tuning Quick reference guide with examples and best practices. Updated November 2025.
Postgres Performance
Indexes, VACUUM, and configuration hints Quick reference guide with examples and best practices. Updated November 2025.
Postgres Replication
Set up primary/replica, monitor lag, and fail over safely Quick reference guide with examples and best practices. Updated November 2025.
Postgres Replication Lag
Monitor `pg_stat_replication` for lag metrics and handle diverging replicas. Quick reference guide with examples and best practices. Updated November 2025.
Postgres Watchdog
Run sentinel queries and restart Postgres when heartbeats fail. Quick reference guide with examples and best practices. Updated November 2025.
PostgreSQL
PostgreSQL commands and queries Quick reference guide with examples and best practices. Updated November 2025.
Prisma ORM
Prisma database toolkit Quick reference guide with examples and best practices. Updated November 2025.
Productivity Time-Blocking Systems
Plan days with themed blocks, buffers, and rest periods. Quick reference guide with examples and best practices. Updated November 2025.
RabbitMQ
Message broker for distributed systems. Always acknowledge messages after processing Quick reference guide with examples and best practices. Updated November 2025.
Redis
Redis commands and data structures Quick reference guide with examples and best practices. Updated November 2025.
Redis Cluster Operations
Manage slot migrations, resharding, and replica promotions. Quick reference guide with examples and best practices. Updated November 2025.
Redis Failover Operations
Plan failover, promote replicas, and reconfigure clients. Quick reference guide with examples and best practices. Updated November 2025.
Redis Memory Optimization
Tune eviction policies, use expirations, and pick compact data types. Quick reference guide with examples and best practices. Updated November 2025.
Redis Persistence Modes
Combine RDB and AOF strategies to match your durability needs. Quick reference guide with examples and best practices. Updated November 2025.
REST API Design
RESTful API best practices Quick reference guide with examples and best practices. Updated November 2025.
SQL
Database queries, joins, and essential SQL commands Quick reference guide with examples and best practices. Updated November 2025.
SQL Index Choices
Choose indexes that match your query filters, sorts, and joins. Quick reference guide with examples and best practices. Updated November 2025.
SQLite Database
SQLite database guide with 50+ SQL commands, data types, queries, indexes, optimization, and CLI reference Quick reference guide with examples and best practices. Updated November 2025.
Supabase
Open-source Firebase alternative. Supabase is built on PostgreSQL with full SQL support Quick reference guide with examples and best practices. Updated November 2025.
Temporal Workflow Patterns
Use Temporal for event-driven workflows, retries, and cross-service coordination Quick reference guide with examples and best practices. Updated November 2025.
Time-Series Modeling in InfluxDB
Structure buckets and Flux queries for efficient time-series analysis. Quick reference guide with examples and best practices. Updated November 2025.
TimescaleDB
TimescaleDB time-series functions, hypertables, and optimization Quick reference guide with examples and best practices. Updated November 2025.
Vector DB Search Tuning
Tune distance metrics, embeddings, and filters for fast, relevant vector search Quick reference guide with examples and best practices. Updated November 2025.
Web Components API
Native Web Components API - custom elements, shadow DOM, and templates Quick reference guide with examples and best practices. Updated November 2025.