GoodNotes Architect Journal
🏠 Index 1. Single Server 2. Selecting DB 3. Relational & SQL 4. ACID Integrity 5. NoSQL Types 6. Scaling Guide 7. Load Balancing 8. SPOF & HA 9. API Design 10. Comm Protocols 11. TCP & UDP 12. REST Design 13. GraphQL Architecture 14. Authentication Protocols 15. JWT & OAuth 2 16. Authorization Models
System Design Chapter 2

Selecting the Right Database

Relational vs Non-Relational Architecture Trade-offs

★ Choose SQL for structured relationships & ACID; choose NoSQL for high throughput & flexible schemas.

Choosing between Relational (SQL) and Non-Relational (NoSQL) databases depends on data structure consistency and scalability needs.

📊 Relational Databases (RDBMS)

Uses structured tables with rows, columns, and pre-defined schemas enforced via SQL query capabilities.

MySQLPostgreSQLSQLiteOracle

Explore Relational & SQL Chapter ➔

⚡ Non-Relational Databases (NoSQL)

Flexible dynamic schemas engineered for high write throughput, massive horizontal elasticity, and low latency.

RedisMongoDBCassandraCosmosDB

Explore NoSQL Types Chapter ➔