Appwrite's Database and Collections

[@Ruboka]

how would i use an external database? and can i use features of mariadb like encryption and appwrite will still work with the database?

[@Appwrite]

For using an external database instead of the Appwrite built-in Cloud database, you can self-host Appwrite. You can learn more on our docs for self-hosting: appwrite.io/docs/advanced/self-hosting

[@Praxss]

@@Appwrite can you link video tutorial about self-hosting Appwrite and linking external DBs

[@TheAremoh]

How do make relationships between the user and a collection. Say I want to have a relationship between user and wallet. I can do this with my defined collections but can't seem to do it with the built in Auth user to my collection

[@michaelknight8965]

Can i define database schemas and mgirations from inside my codebase? And is the appwrite SDK supposed to be the ORM in this case or are third-parties like Drizzle/Prisma supported?

[@Appwrite]

You'd want to define your database schema from the console and not in the code base. Appwrite's SDK provides you with a database API to communicate with your DB, although you can also do so with API endpoints. - Dennis Ivy

[@ir5had]

what database does Appwrite uses ?

[@Appwrite]

Appwrite uses a NoSQL interface built on top of MariaDB. However, we are adding support for a variety of databases, including PostgreSQL and MongoDB @@hackingboxes

[@ecofriend93]

How do I add map/objects?

[@MayankMishra-oy5xe]

Can I self host appwrite and use mongodb as an external database with it?

[@Appwrite]

Soon you’ll be able to. We’re working on Integrating a Mongo db and Postgres option for the database :) - Dennis Ivy

[@MayankMishra-oy5xe]

Thanks but can you give me any rough idea when it will be added as I have to make a big project so that I can make some decisions. Any estimation will do like year end or next year mid...@@Appwrite

[@klyist]

waiting for more videos.

[@Appwrite]

A lot more coming!