𝟮𝟲. 𝗗𝗮𝘁𝗮𝗯𝗮𝘀𝗲𝘀
Dr. Angela explains databases in her new BootCamp.
You need databases for persistent storage. Variables in memory disappear when an application stops. Databases keep your data safe and available. They help you store, find, and manage large amounts of information.
There are two main types of databases.
SQL Databases These are relational databases. They use tables and fixed schemas.
- Structured data
- Fixed schemas
- Relationships between tables
- Strong consistency
- Uses SQL for queries
- Examples: PostgreSQL, MySQL, Oracle, SQLite
NoSQL Databases These focus on flexibility and scale.
- Flexible schemas
- Horizontal scalability
- Good for large or changing data
- Multiple data models like document or key-value
- Examples: MongoDB, Redis, Amazon DynamoDB
Choose the right tool for your data needs.