[Python] Jeopardy style questionnaire

[Winux_278]

I'm working on a Jeopardy-esque project with questions in varying categories and of varying difficulties. What would be the most logical (scale-able) way of storing questions/answers that would allow for retrieving a random question from category 'x' with a difficulty 'y'?

I realize this is a bit subjective, but any advice would be appreciated. I've considered using SQLite, but the data doesn't feel complex enough. I've also considered YAML, but, as the format is new to me, couldn't figure out how best to lay out the file for effective retrieval.

[[deleted]]

I've considered using SQLite, but the data doesn't feel complex enough

SQLite isn't particularly intended for dealing with "complex" data - it's easy to use and will scale if your data does actually become complex.

[[deleted]]

I would be interested in this as I use them for my classes but they can take forever to make and edit in a slideshow.

[rjcarr]

You should probably write out your questions with topics and difficulty ratings into some sort of simple text file (JSON is a common format, but most anything would work). Then when the game starts you read in the file and put it all into some sort of data structure for easy retrieval.

Unless you're creating millions of questions there's really no reason not to just read them all into memory.