Back

Multiple databases for one project

  • 0
  • Databases
  • Functions
  • General
Denzel
12 Apr, 2024, 09:07

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 ?

TL;DR
Utilizing multiple databases for a project like a multi-vendor food delivery system can enhance organization and readability. By categorizing data into separate databases based on functionality (e.g., vendors, orders, chats), developers can better manage internal logic. This structure can potentially improve system efficiency and maintainability.
darShan
12 Apr, 2024, 09:21

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 -

  1. Database - Vendors └── Collections - Some logic based different collections or a single one to group vendors.
  2. Database - Misc [locations, etc.] └── Collections - same as above []
  3. 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.

Denzel
12 Apr, 2024, 09:49

So it does not change the speed of the system

Reply

Reply to this thread by joining our Discord

Reply on Discord

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