Personal Music Listening Database project using SQL and Python
This program is a simple command-line application that lets you interact with a music database. You can view songs, search for songs, and look at albums by artist, along with a few other basic features.
Requirements
- Python 3
- sqlite3 (comes with Python, so nothing extra to install)
Files
- music_app.py → main program
- music.db → database file (needs to be in the same folder)
Setup Put all the files in the same directory. As long as music_app.py and music.db are together, it should run fine.
How to Run Open a terminal in the folder and run:
python music_app.py
Usage When the program starts, it will show a menu with numbered options. Just type the number for what you want to do and press enter.
Some of the main options include:
- printing all data in the database
- searching for songs by title
- displaying albums for a specific artist
Other options allow you to add data like artists, albums, songs, and listening history.
Notes
- Make sure the database file (music.db) stays in the same folder as the program
- If the database file is missing, the program may not work unless the tables are created in code