> Portal Navigation:
> 
> - Append `.md` to any URL under `https://dev.wix.com/docs/` to get its markdown version.
> - Pages are either content pages (article or reference text) or menu pages (a list of links to child pages).
> - To get a menu page, truncate any URL to a parent path and append `.md` (e.g. `https://dev.wix.com/docs/sdk.md`, `https://dev.wix.com/docs/sdk/core-modules.md`).
> - Top-level index of all portals: https://dev.wix.com/docs/llms.txt
> - Full concatenated docs: https://dev.wix.com/docs/llms-full.txt

## Resource: About Wix Data Management Solutions

## Article: About Wix Data Management Solutions

## Article Link: https://dev.wix.com/docs/develop-websites/articles/databases/about-wix-data-management-solutions.md

## Article Content:

# About Wix Data Management Solutions

Wix offers a variety of data management solutions to accommodate common user needs. This includes support for internal databases hosted directly on Wix as well as for external databases hosted outside the Wix ecosystem.

This article explains the internal database capabilities Wix provides, and the available options for working with external databases.

## Supported IDEs
You can work with Wix's data management solutions in the following IDEs:

- The [editor](https://dev.wix.com/docs/develop-websites/articles/workspace-tools/velo-workspace/workspaces/wix-studio-working-with-the-code-panel.md) (Wix Studio and Wix Editor).
- The [Wix IDE](https://dev.wix.com/docs/develop-websites/articles/workspace-tools/velo-workspace/wix-ide/wix-studio-about-the-wix-ide.md) (Wix Studio).
- Your [local IDE](https://dev.wix.com/docs/develop-websites/articles/workspace-tools/developer-tools/git-integration-wix-cli-for-sites/about-git-integration-wix-cli-for-sites.md) (Wix Studio and Wix Editor).

## The Wix Content Management System

Wix's built-in data management solution is the [Wix Content Management System (CMS)](https://support.wix.com/en/article/cms-content-management-system-an-overview). CMS data collections are document-oriented databases, optimized to store and retrieve websites’ content. They are globally replicated and have native support for PII encryption and GDPR. They run on secure, shared infrastructure, and are fully managed by Wix.

CMS data collections can be managed via the [Wix Data APIs](https://dev.wix.com/docs/sdk/backend-modules/data/introduction.md), and used (with or without [datasets](https://dev.wix.com/docs/velo/velo-only-apis/$w/dataset/introduction.md)) to populate Wix UI elements like [repeaters](https://dev.wix.com/docs/develop-websites/articles/databases/wix-data/displaying-data/display-database-collection-content-in-a-repeater.md) and [tables](https://support.wix.com/en/article/cms-formerly-content-manager-displaying-collection-content-in-a-table).

For more information about using Wix Data to work with the CMS on a Wix site, see [Working with Wix Data](https://dev.wix.com/docs/develop-websites/articles/databases/wix-data/data-api/working-with-wix-data.md).

## Support for external databases

While CMS collections cover a wide range of use cases for content-driven websites and applications, some projects may have specific requirements that can't be addressed by the integrated database solution.

To address such cases, Wix allows users to connect an external database to Wix sites using an external database adaptor. Once the connection is set up, users can interact with these databases and use them to populate site elements as though they were Wix CMS collections.

For more information about connecting to external databases, see [Integrating External Databases with Your Wix Site](https://dev.wix.com/docs/develop-websites/articles/databases/external-databases/overview/integrating-external-databases-with-your-wix-site.md).

## Choose the right database engine for your site workload

If you haven't already chosen a database engine, there's a lot of material on the internet about database comparisons and benchmarks that can help you decide.

We suggest taking the following into account:

- Use the Wix-integrated [CMS](https://support.wix.com/en/article/cms-content-management-system-an-overview) collections for:
  - CRUD operations for 1 to 10k items or up to 100k items, depending on the size of the data
  - Query operations of 1 to 10k items while using indexes.
- Use relational databases for:
  - User facing operational workloads, including aggregates and data consistency validations. They scale according to the actual data and capacity planning for specific workloads
- Use analytical databases for:
  - Reporting or analytical workloads when the dataset is mainly used for reporting or aggregates and, the dataset size exceeds the capacity of the relational database instance
  - Dedicated analytical databases include Google BigQuery or Snowflake.

> **Note:** Wix created out-of-the-box container image adaptors for a number of databases that can run on AWS, Azure, and Google Cloud Platform. Using these out of the box adaptors can make integration with the supported databases simpler. See which databases are [supported with an out-of-the-box adaptor](https://dev.wix.com/docs/develop-websites/articles/databases/external-databases/overview/integrating-external-databases-with-your-wix-site.md#deploy-an-out-of-the-box-external-database-adaptor).

## See also

- [CMS (Content Management System): An Overview](https://support.wix.com/en/article/cms-content-management-system-an-overview)
- [Working with Wix Data](https://dev.wix.com/docs/develop-websites/articles/databases/wix-data/data-api/working-with-wix-data.md)