Hi everyone, so I am working on designing a music player using Qt and VLC as a backend. To give you an idea, I am taking a lot of inspiration from MediaMonkey. I have the library potion set up using SQL just fine, but I am not sure how to handle the playlist. The problem is a playlist should have a specific order and SQL has no inherent order.

I am not sure if keeping a field in each record to maintain that order makes sense, or if I should design an ordered data structure (or if one already exists). Does anyone have any advice on a "standard" solution for this problem? I have tried looking at Amarok source code, but have a hard time following it because it has become such a large and abstracted projected.

Thanks!