Database Selection SQL Vs Nosql

Guidance and best practices for database selection (sql vs nosql). Use when this capability is needed.

tomevault-io cedd99f 2 files · 1.6 KB Updated

File contents

Database Selection (SQL vs NoSQL)

SQL (Relational)

  • Examples: PostgreSQL, MySQL.
  • Use Case: Structured data, complex relationships, transactions (ACID), reporting.
  • Schema: Rigid, requires migrations.

NoSQL (Non-Relational)

  • Examples: MongoDB (Document), Redis (Key-Value), Cassandra (Wide-Column).
  • Use Case: Unstructured data, high write throughput, horizontal scaling, flexible schema.
  • Schema: Flexible/Schema-less.

Selection

  • Choose SQL by default for most business applications.
  • Choose NoSQL for specific needs like caching (Redis), massive logs, or rapidly changing data structures.

Source: jyjeanne/ai-setup-forge — distributed by TomeVault.

tomevault-io/skills-registry/tree/main/jyjeanne--ai-setup-forge--database-selection-sql-vs-nosql commit cedd99fbe9

Frequently asked questions

npx skillmds@latest add tomevault-io/database-selection-sql-vs-nosql