When should I choose PostgreSQL over MongoDB?

Choose PostgreSQL for relational data with strict ACID requirements and structured schemas. Opt for MongoDB when your schema evolves rapidly or you are dealing with hierarchical JSON-like data structures.

Does this skill help with high-scale database planning?

Yes, it provides specific 'scale ceilings' and horizontal scaling strategies, including sharding, read replicas, and managed scaling options like DynamoDB.

What is Polyglot Persistence?

It is the practice of using different databases for different tasks within one system (e.g., Postgres for transactions, Redis for caching, and Elasticsearch for search). This skill provides guidance on when to introduce this complexity.

Can I use this for specialized data like time-series or search?

Absolutely. The skill includes specific frameworks for choosing between TimescaleDB, ClickHouse, and Elasticsearch based on your ingestion volume and query needs.

Database Selection & Architecture

Name: Database Selection & Architecture
Author: chavangorakh1999

bychavangorakh1999

0•

Database Management

Guides developers through choosing the optimal database architecture based on access patterns, scalability needs, and consistency requirements.

This skill acts as an expert system design consultant, providing a structured framework for selecting the right data storage technology for any given service. It evaluates tradeoffs between RDBMS, document stores, wide-column databases, and specialized time-series engines like PostgreSQL, MongoDB, Redis, and DynamoDB. By analyzing dominant access patterns, consistency needs, and team expertise, it helps developers avoid architectural technical debt and implement scalable, natural data models from the start.

Key Features

01Managed service recommendations for AWS, GCP, and independent providers

02Performance benchmarks and scale ceiling indicators for popular DBs

03Decision frameworks for consistency and availability requirements

040 GitHub stars

05Comparative analysis of SQL vs. NoSQL tradeoffs

06Guidance on polyglot persistence and multi-database architectures

Use Cases

01Designing high-performance caching or search layers for existing apps

02Selecting the primary data store for a new microservice

03Evaluating whether to migrate from a relational to a document database

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add chavangorakh1999/sde-skills database-selection

For use in Claude.ai and ChatGPT

Key Features

01Managed service recommendations for AWS, GCP, and independent providers

02Performance benchmarks and scale ceiling indicators for popular DBs

03Decision frameworks for consistency and availability requirements

040 GitHub stars

05Comparative analysis of SQL vs. NoSQL tradeoffs

06Guidance on polyglot persistence and multi-database architectures

Use Cases

01Designing high-performance caching or search layers for existing apps

02Selecting the primary data store for a new microservice

03Evaluating whether to migrate from a relational to a document database

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add chavangorakh1999/sde-skills database-selection

For use in Claude.ai and ChatGPT