luca/db

[luca020400]

• Twelve: Add room
• Twelve: Playlist database

[luca020400]

Note to self, need to zap indices on primary key tuple as that's done by default.

The item_id index is required in the crossref because the index is created on (playlist_id, item_d) which forces full table scans in case we search by item_id (like in associativity check)

[luca020400]

I wonder if it makes sense to have a more comprehensive insert cross ref method that also adds the item in case?

Imo we should just start looking at how to implement media mirroring to avoid (most) of this mess?

[luca020400]

Try a manual gradle debug build, you'll see some issues regarding transactions and suspend funcs, we should solve them