VOOZH about

URL: https://dev.to/avery_/26-databases-c25

⇱ 26. Databases - DEV Community


BootCamp by Dr.Angela

1. Databases Explained: SQL vs NoSQL

  • Why Do We Need Databases?
    • Databases provide persistent data storage.
    • Unlike variables in memory, data stored in a database remains available even after the application stops running.
    • Databases allow applications to store, retrieve, update, and manage large amounts of information efficiently.
  • Types of Databases
    • SQL(Structured Query Language) Databases : typically relational databases, where data is organized into tables with predefined schemas.
    • Structured data, Fixed schema, Relationships between tables, Strong consistency, Uses SQL for querying
    • ex) PostgreSQL, MySQL, Oracle Database, SQLite, ...
    • NoSQL Databases : designed for flexibility and scalability.
    • Flexible schema, Horizontal scalability, Suitable for large-scale or rapidly changing data, Multiple data models (document, key-value, graph, etc.)
    • ex) MongoDB, Redis, Amazon DynamoDB