I’m working on a new word-puzzle app, and I’m wondering if there’s a better way to organize the puzzles that will make up the app than what I’m doing now, which is having thousands of JSON files.
Our previous apps are grid-based word searches, so each puzzle file contained, among other things a 2D array representing the letter grid. It was critical for the puzzles to be human-readable, so having each level be its own JSON file made sense. The new app’s puzzle files will be significantly simpler- a table with three or four values, and human readability is not nearly as important.
Given that there will be ultimately 10,000 puzzles in the app, is there an advantage to setting the whole thing up as a database instead of individual files?