martpie / museeks

🎵 A simple, clean and cross-platform music player
https://museeks.io
MIT License
1.71k stars 200 forks source link

SQLite #795

Closed martpie closed 3 weeks ago

martpie commented 3 weeks ago

Fixes #793

via the awesome ormlite.

martpie commented 3 weeks ago

Got a working version, 4000 tracks load in 50ms. Insertion and deletions don't need transactions (inserting all 4000 tracks sequentially is almost instant).

Looking good so far :) Some weird edgecases though with ormlite, stuff not well exposed, but so far so good.

martpie commented 3 weeks ago

Erratum: inserting 4000 tracks take 2 seconds, which is good enough. Deleting and vacuuming takes 5 sevconds clearing the records one by one, so I just used one statement to delete everything, which is instant, but less type safe