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
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?
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
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
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
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
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
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?
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
how would i use an external database? and can i use features of mariadb like encryption and appwrite will still work with the database?
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
@@Appwrite can you link video tutorial about self-hosting Appwrite and linking external DBs
How do I add map/objects?
what database does Appwrite uses ?
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
Can I self host appwrite and use mongodb as an external database with it?
Soon you’ll be able to. We’re working on Integrating a Mongo db and Postgres option for the database :) - Dennis Ivy
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
waiting for more videos.
A lot more coming!