What is it
When selecting a DB, and principally when at side of the ACID/BASE principles, some of the points below are the most important when decide one or another, specially in interviews:
- Format of data types (Consistent x Dynamic)
- Level of relationships between data (Lots x Little)
- Availability X Consistency X Partitioning (CAP theorem)
- Reads/Writes reason though one another (Write: NoSQL prefferend)
When we talk about relational databases, most of the options are:
- Oracle SQL
- Postgres SQL
- MyQSL
When we need a noSQL database, we are generally needing some of those:
- Analytcs -> Colunar Databases (EX: Cassandra)
- Cache -> KV Databases (EX: Redis)
- Graph database -> Neo4j
- Search database - Inverted Index DB (EX: Opensearch)
- AI memory system - Vector DB - (EX: QDrant)