Back

Database structure question

  • 0
  • Databases
  • Web
  • Cloud
larkx
18 Mar, 2024, 16:20

Hi all,

I've got a question on how I should structure my database and was hoping someone could help me out. Let me explain my situation: I've got a platform for creating flashcards. A flashcard set has a name, description, and of course the cards themselves, which have the data of term and definition.

I was wondering if I should have a separate collection that contains all the flashcard data themselves (each document would have term, definition & relation to the main document that holds the flashcard set data (name, description).

OR

Should each flashcard set be it's own document on one collection, where each document has the attributes of name, description & cards (as string type, in json format).

Any help is appreciated, thank you πŸ™‚

TL;DR
Developers seeking advice on database structuring for a platform that creates flashcards. Should they have a separate collection for flashcard data or include it all in one collection per flashcard set? Check this out for more info: <https://medium.com/geekculture/appwrite-frequently-asked-questions-374ce81513fe#60bd>
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