How can I best represent the following data in sqlite3?
I'm creating a database of songs, which each consist of an unpredictable number of chords. Each chord has a root (string, 1 or 2 characters) and a tonality (string, <20 characters).
It would make intuitive sense to me to have two classes: Chord containing two strings, and Song containing an arbitrary-length list of Chords. However, as far as I can tell, that's not how sqlite operates. Is there a better/canonical way of handling this type of data?
Aucun commentaire:
Enregistrer un commentaire