SQL Connector

Hey, Database documentation mentions something like:

Appwrite will support both SQL and NoSQL database adapters like MariaDB, MySQL, or MongoDB. When working with an SQL adapter, Appwrite will treat your collections as tables and documents as rows on native SQL tables.

Is it already supported? Is there more info available on this topic? Is there a way to access appwrite DB with some SQL tool too for joined queries report etc?

No we only officially support mariadb at the moment.

Accessing the DB like any other mariadb docker container. There are also other <#1072905050399191082> posts on how to access the database

Thanks for getting back on a weekend. I will check around. I just had an impression that appwrite has it's own proprietary db and there's a way to access as mariadb, but now I get it as it might actually run by extending the regular mariadb. Thanks for pointing the direction.

We're using the standard mariadb (https://github.com/appwrite/appwrite/blob/84c06a8eceee1dadc2b2adcdb7a6c60d56eba494/app/views/install/compose.phtml#L606). All of our logic is at the application layer connecting to a standard mariadb database