Database design - atangster/food-waste-game GitHub Wiki

Firebase

  • Firestore (a flexible, scalable database for mobile, web, and server development): Ideal for complex hierarchical data structures with robust querying capabilities. We can model our data around collections (e.g ingredients, dishes, users) and documents (individual records). Firestore's real-time capabilities also make it suitable for features like live leaderboards or multiplayer interactions
  • Firebase Realtime Database (a cloud-hosted database that supports real-time data syncing): Best for high-intensity, real-time applications where you need to sync data between users efficiently. It's simpler and sometimes faster for real-time updates but less flexible in querying compared to Firestore.