Skip to content
Start project
Back

SQL Connector

  • 0
  • Databases
View on Discord
alarmatwork
29 Apr, 2023, 13:00

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?

TL;DR
The user wants to know if Appwrite supports SQL databases and if there is a way to access the Appwrite database with an SQL tool. The response is that Appwrite currently only officially supports MariaDB. There are other posts available on how to access the database, but it is not clear if Appwrite supports SQL databases fully. No solution or further information is provided.
Drake
29 Apr, 2023, 15:02

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

alarmatwork
29 Apr, 2023, 15:52

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.

Drake
29 Apr, 2023, 16:02

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

Reply

Reply to this thread by joining our Discord

Reply on Discord

Recommended threads

Need support?

Join our Discord

Get community support by joining our Discord server.

Join Discord

Get premium support

Join Appwrite Pro and get email support from our team.

Learn more