search

SathyaBhat / spotify-dl

Downloads songs from your Spotify Playlist
http://sathyasays.com/2015/12/29/spotify-dl-download-your-spotify-my-music-songs-as-mp3/
MIT License
1.74k stars 214 forks source link

Improved history, database and statistics #82

Open lucanello opened 4 years ago

lucanello commented 4 years ago

Currently, downloaded videos are saved in a .txt file which is not very handful. Informations like the song title, Spotify song ID, YouTube video title, YouTube video length and YouTube ID are missing. Also the downloaded file name and timestamps are missing.

Those informations should be added and saved in a structured format e.g. JSON, CSV or even a database like SQLite. This improvement makes these informations accessible for further use, e.g. when periodically syncing your Spotify library.

For fast implementation these informations can be saved as CSV which makes conversions to other types of structured data easy.

SathyaBhat commented 4 years ago

in https://github.com/SathyaBhat/spotify-dl/pull/80/commits/7fb57a043456145bb7d62aca2df214d783e58017 I added limited support for sqlite - primarly to save the youtube video id against the search the term. This can be expanded upon