> For the complete documentation index, see [llms.txt](https://functional.gitbook.io/database_comparison_report/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://functional.gitbook.io/database_comparison_report/mysql/use-cases.md).

# Use cases

**Small web-based solutions.** A MySQL database system is the best option when you’re designing a small, web-based solution with a small volume of data. For example, when building a local eCommerce store, MySQL may come in handy.

<figure><img src="/files/x3rkmvb54oEQtaNCU4gH" alt=""><figcaption></figcaption></figure>

**OLAP/OLTP systems.** This is one of the best use cases for a MySQL database, as OLAP/OLTP don’t require complex queries and large volumes of data. Also, consider applying MySQL for the same reason if you’re building a business intelligence tool.