There are hundreds or even thousands of databases available today, such as Oracle, MySQL, MariaDB, SQLite, PostgreSQL, Redis, ClickHouse, MongoDB, S3, Ceph, etc. How do you select the architecture for your system? My short summary is as follows:
๐นRelational database. Almost anything could be solved by them.
๐นIn-memory store. Their speed and limited data size make them ideal for fast operations.
๐นTime-series database. Store and manage time-stamped data.
๐นGraph database. It is suitable for complex relationships between unstructured objects.
๐นDocument store. They are good for large immutable data.
๐นWide column store. They are usually used for big data, analytics, reporting, etc., which needs denormalized data.
