Below are the database types currently supported by MAVIS and their descriptions:
-
PostgreSQL (Supported since v1.10.0):
An open-source relational database system known for its advanced features, scalability, and data integrity. It supports complex data types, custom functions, and powerful indexing.
-
MySQL (Supported since v1.17.0):
A widely used open-source database system, ideal for efficiently storing, managing, and manipulating structured data across various applications and projects.
Note: Depending on the version, the default authentication method between the server and client varies. Please configure the appropriate method based on your environment:
-
mysql_native_password (for MySQL versions prior to 5.7)
-
caching_sha2_password (for MySQL 8.0 and above)
-
-
Microsoft SQL Server (Supported since v1.21.0):
A relational database management system (RDBMS) developed by Microsoft. It supports structured data and uses T-SQL as its query language.
👉 For detailed instructions and configuration, please refer to:
https://mavis.pentium.network/hc/zh-tw/articles/23038096613780