pikaraoke icon indicating copy to clipboard operation
pikaraoke copied to clipboard

Feature Request: Use database for song information storage

Open iMelsom opened this issue 4 years ago • 4 comments

Right now only song title and artist is variables available, but by adding an database we could also have extended data:

  • artist
  • co-artist (s)
  • album
  • song title
  • atlernate song titles
  • Personal tags

iMelsom avatar Feb 12 '21 14:02 iMelsom

Using a DB might also help address the large libraries issues. I know that's how most karaoke programs tend to operate. But it seems like it might be a pretty big overhaul to switch to this.

jramboz avatar Feb 12 '21 17:02 jramboz

Setting up and using a db doesn't seem like a big issue here. SQLlite or MySql would work. The problem is parsing the data, especially from the sources we have. Mp3's with CDG have the metadata possible, but youtube source files do not, that is not even including the titles of the videos being wrong, excess wording, misspellings, etc.

dpitcock avatar May 28 '21 13:05 dpitcock

Using a database could be very handy to order the song list alphabetically not only on the first letter (I mean depending if you used TITLE - ARTIST or ARTIST - TITLE). You could just store the title, artist, path,.. this way you can choose on what you want to order. The only problem here is that you have to still use the same sequence of naming the files

also, when using a database, you would be able to get ‘favorite’ songs, you could track wich song is played the most and you can order on this..

BramWerbrouck avatar Sep 26 '21 06:09 BramWerbrouck

I would love to see a way to import large libraries by either "artist - title" or "disc id - artist -title". Something along those lines to make the browse function a little cleaner. Currently, I have a lot of DISCID's listed in alphabetical order. It's not a huge issue but a nice to have. The program works great and I appreciate all the effort that's been put in. Thanks!

eddiemartinez22 avatar Aug 17 '22 19:08 eddiemartinez22