We are creating a multi vendor food delivery system and we want to create 3 databases. One database will have vendors profile, category, food and fav user food collections , database 2 will have cart item , discount, order and location collections and database 3: will have chat room, chat message support collections.
Is it efficient to do it this way or it does not matter ?
It really depends on how you can manage the internal logic and understand it.
Different Database is also fine as it gives more understanding and readability. Example -
- Database - Vendors └── Collections - Some logic based different collections or a single one to group vendors.
- Database - Misc [locations, etc.] └── Collections - same as above []
- Database - Chats └── Collections - different chat documents per chat room.
Another Database Logic - Database - Delivery App └── Collections - └── Vendors -> List all vendors └── Misc -> Add Coupons, Menus, etc
Database - Chats └── Collections - └── Chat-[VENDOR_ID-USER_ID] └── Chat Documents.
So it does not change the speed of the system
Recommended threads
- Type Mismatch in AppwriteException
There is a discrepancy in the TypeScript type definitions for AppwriteException. The response property is defined as a string in the type definitions, but in pr...
- What Query's are valid for GetDocument?
Documentation shows that Queries are valid here, but doesn't explain which queries are valid. At first I presumed this to be a bug, but before creating a githu...
- Unauthorized Charge After Appwrite Pro F...
I was using Appwrite Pro credits worth $100, which were valid until November. During this period, I was exploring Appwrite's services. However, I recently notic...