For the DB gurus: Is it wise to model a playlist in a SQLite database as a linked list? I don’t want to have to mutate all entries when, for example, I just want to change the order of items.
But I also feel that recursively fetching the items to follow the list could impact performance for playlists with a lot of items.
#sqlite #softwaredevelopment #softwareengineering