How I built a CLI music player in Python and what I learned

A Python programmer, who had been mastering the language through tutorials, chose to create a practical application rather than a simple to-do list. The outcome was a command line music player that connected with the Deezer API to search for artists and songs, used yt-dlp for audio fetching and streaming, VLC for playback control, and SQLite for local storage of playlists and favorite artists.

The tools at the programmer's disposal included the Deezer API for accessing music data, yt-dlp for handling audio, VLC for playback management, SQLite for storing playlists and favorite artists, and requests for making API calls.

One aspect stood out as particularly intriguing. When the programmer added the capability to save artists and songs at the same time, they encountered a "database locked" error. Initially, they hypothesized a missing commit, having inadvertently executed two commits following each insertion. Even after merging the commits, the error persisted.

Eventually, it was discovered that a previous development version had left a database connection open. This lingering connection was running in the background, locking the database. By terminating the processes, and ensuring proper connection closure upon exit, the issue was resolved swiftly.

The programmer learned an important lesson: the bug might not always be in the line of code they're currently examining; it could also reside in the system or the environment itself. Their next steps involved developing a graphical user interface, packaging the application for easy installation, conducting extensive testing, and sharing the project on GitHub. Their GitHub repository address is https://github.com/Iheb-eng/music-app. They welcome any feedback or suggestions.