Junior — Middle
Can you list different types of databases you have encountered?
sobes.tech AI
Answer from AI
I have mainly encountered the following categories of databases:
- Relational databases (SQL): MySQL, PostgreSQL, SQLite, Microsoft SQL Server. Used for structured data with clear schemas.
- Document-oriented databases (NoSQL): MongoDB, CouchDB. Store data in JSON-like document formats, flexible in structure.
- Key-value: Redis, Memcached. Fast access to data by key, often used for caching.
- Columnar databases: Apache Cassandra, HBase. Optimized for analytics and large volumes of data.
- Graph databases: Neo4j, JanusGraph. For storing and processing graph structures, such as social networks.
In Node.js, I most often worked with MongoDB and PostgreSQL, using the respective drivers and ORM.