Dot can work with any SQL database, e.g.:
- Amazon Aurora: A MySQL and PostgreSQL compatible relational database engine known for its speed, availability, and cost-effectiveness compared to standard MySQL and PostgreSQL databases.
- Amazon Relational Database Service (RDS): AWS's RDS supports several database engines including MySQL and PostgreSQL, and provides a platform for OLAP and other data processing tasks.
- Apache Druid: An open-source database designed for high-performance real-time analytics. It's column-oriented and can aggregate large amounts of data. While Druid does support SQL, its architecture is more suited for OLAP-style queries and it's not a traditional relational database.
- Azure SQL Database: A fully managed platform as a service (PaaS) database engine that takes care of most of the database management functions such as upgrading, patching, backups, and monitoring.
- ClickHouse: An open-source, column-oriented database management system (DBMS) optimized for online analytical processing (OLAP) and real-time analytics.
- DB2: A family of database management system products from IBM that serve a range of different operating system platforms.
- Informix: A product family within IBM's Information Management division that is centered on several relational database management system (RDBMS) offerings.
- MariaDB: An open-source relational database management system that's a fork of MySQL. It's developed and maintained by the original developers of MySQL.
- MySQL: An open-source relational database management system (RDBMS) owned by Oracle. It's widely used for web applications and is a component of the LAMP web application software stack.
- Oracle Database: A multi-model database management system produced and marketed by Oracle Corporation. It's widely used in enterprise environments.
- PrestoDB / Trino: An open-source distributed SQL query engine for running interactive analytic queries against various data sources of all sizes. It's designed to query large data sets that reside in distributed storage. Although you can use SQL to query data, Presto isn't a traditional database but more of a tool to perform analytics on large scale data.
- Rockset: Designed for real-time analytics, Rockset claims to have an overall speedup over ClickHouse in certain configurations.
- SQLite: An in-process library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine.
- StarRocks: Previously known as Palo, StarRocks is considered by some users as a faster analytical database compared to ClickHouse.
- Sybase: A relational model database server product that was developed by Sybase Corporation, which is now owned by SAP.
- Teradata: A fully scalable relational database management system produced by Teradata Corp. It's widely used for large data warehousing applications.
- Vertica: A column-oriented relational database designed to handle large volumes of data and provide high-performance query functionality.
- Any database we should add?
Dot can also integrate with your existing BI tool to learn how important metrics are defined and to guide users to the right dashboard.
➡️ Let us know if you need to support for one these (e.g. PowerBI, Tableau, Qlik, Metabase)