Rajive Jain

Data Science

How to Choose between Different Database Types?

These are some Broad Categories of Database that one will encounter and will need to choose from: Data warehouse Data lake Transactional database Document database Key-value store Graph database Time-series database Vector database Multi-model database It is suggested that when starting a new application use PostgreSQL which will handle 90% of use cases. On maturity one can look for optimizations.