Curated resources for database professionals, architects, and developers covering relational database design, query optimization, migration tooling, cloud database services, and modern data infrastructure patterns.
Official Documentation & References
PostgreSQL Official Documentation — The definitive reference for PostgreSQL, maintained by the PostgreSQL Global Development Group. Covers SQL syntax, administration, configuration, replication, logical decoding, row-level security, and all built-in extensions. The EXPLAIN and EXPLAIN ANALYZE documentation is essential for query optimization work.
MySQL Reference Manual — Official MySQL documentation covering all versions from 5.7 through 8.4 LTS. Comprehensive reference for InnoDB storage engine internals, replication setup, performance schema, and index optimization for high-traffic OLTP systems.
MongoDB Documentation — Official MongoDB documentation covering document data modeling, aggregation pipeline, Atlas cloud operations, sharding, and change streams. The schema design patterns section helps developers avoid common NoSQL anti-patterns.
Redis Documentation — Redis is widely used as a caching layer and message broker alongside relational databases. The Redis documentation covers data structures, persistence options (AOF/RDB), cluster configuration, and Pub/Sub patterns for cache invalidation strategies.
Learning & Query Optimization
Use The Index, Luke! — The authoritative free resource on database indexing by Markus Winand, covering B-tree indexes, composite indexes, partial indexes, covering indexes, and SQL execution plans. Available free online — essential reading for any developer writing SQL queries against large datasets.
Dalibo PostgreSQL EXPLAIN Visualizer — Paste your PostgreSQL EXPLAIN ANALYZE output to get a visual execution plan diagram with node-level timing analysis, making complex query plans far easier to interpret. Free and invaluable for identifying bottlenecks in multi-table JOINs and subqueries.
Database Normalization (Wikipedia) — Clear, comprehensive coverage of normalization forms (1NF through BCNF) with worked examples. Understanding normalization theory is fundamental to designing schemas that remain maintainable and avoid update anomalies as business requirements evolve over time.
DB Fiddle — Browser-based SQL sandbox supporting PostgreSQL, MySQL, SQLite, and SQL Server. Create shareable database environments for testing migration differences, demonstrating schema issues, or collaborating on query optimization questions without requiring a local setup.
Migration & Infrastructure Tools
Flyway Documentation — Flyway manages versioned SQL migration scripts executed sequentially with checksum validation. Integrates with Maven, Gradle, Spring Boot, and Docker for automated schema deployment pipelines. The standard choice for Java-based application database version control.
Liquibase Documentation — Supports XML, YAML, JSON, and SQL changesets with rollback capabilities and diff-based change detection. Particularly strong in enterprise environments with complex deployment approval workflows and multi-database support requirements.
Debezium (Change Data Capture) — Debezium streams database changes from MySQL, PostgreSQL, MongoDB, and SQL Server to Apache Kafka in real time using CDC. Used for event-driven architectures, data replication to analytics systems, and near-zero-downtime database migrations.
pgloader — Open-source migration tool for loading data into PostgreSQL from MySQL, SQLite, MS SQL Server, CSV, and other sources. Handles schema conversion, type mapping, and error reporting automatically — the standard tool for MySQL-to-PostgreSQL migrations.
On-Site Resources
Database Migration Guide — Step-by-step methodology for planning and executing database migrations with minimal downtime, including risk assessment, testing frameworks, and cutover runbooks.
Database Indexing Guide — Comprehensive guide to B-tree, Hash, GIN, GiST, BRIN, and partial indexes across PostgreSQL and MySQL with query pattern examples.
NoSQL vs SQL Guide — Decision framework for choosing between relational and document databases based on access patterns, consistency needs, and operational constraints.
Database FAQ — Answers to the most common database design, performance, and migration questions from developers and database administrators.
Suggest a Resource
Know of a valuable database resource we should include? Contact us with your suggestion.