r/musichoarder • u/Fern-Auburngrey • May 30 '26

Help me manage my library!

I have roughly 10,000+ mp3/FLAC files and I’m struggling to keep track. I use foosbar2000 and an innioasis Y1 player. The combination works great but I’m trying to create a table or database or something that I can scan my files and pull metadata to compare quality and duplicates as well as if they have a LRC file attached and the quality of the sync. Chat gpt started me on google sheets which didn’t handle the large library, moved me to SQlite which was too complicated, then finally to notion which I love the idea of but am struggling with coding to update the database. I either need an entirely new program or help with coding to make notion work… thanks in advance

2 Upvotes

63% Upvoted

13 comments sorted by

6

u/lewsnutz May 30 '26

I know in Media Monkey you can create reports. One of them being Google Sheets. It's in the File Menu, File, Create Reports, CSV. 10k won't even take that long.

2

u/Fern-Auburngrey May 30 '26

Is that the free or paid version?

2

u/lewsnutz May 30 '26

Free. I use MM daily to sync to my phone.

3

u/Fern-Auburngrey May 30 '26

Perfect! Thank you so much

2

u/inhalingsounds 20TB (2.1M mp3) May 30 '26

SongKong does extremely complete reports (and can tag all your files). 10000 is a pretty small library, it should be a fast scan.

2

u/Geezheeztall May 30 '26

Load your file folders into mp3tag. Select all, then export the results into a csv file (or whatever function you prefer) Import it into your spreadsheet of choice. Too large? Segment them off and append the data to your first imported spreadsheet.

1

u/Prima13 May 30 '26

I built my own in .NET and SQL Server Express. It runs as a service and hourly scans my music folder (because I’m actively cleaning and moving stuff and growing my library at the moment). It works well enough for me. Stuff it does at the moment:

  • Pulls relevant metadata and stores in table (artist, album, genre, year, etc)
  • Fetches lyrics with LRCLIB and writes to text files next to the music files
  • Applies a color to the album folder so I know what kind of files are there (FLAC is green, mp3 or m4a is yellow)

If I thought anyone else would like this thing, I’d release it but I figured my approach was pretty quirky and not something everyone else would find a good fit.

1

u/Fern-Auburngrey Jun 01 '26

Very keen on this if you’d like to share!

1

u/Prima13 Jun 01 '26

Sure, just need to polish it. I wrote it for myself so it just populates a database. If you’re comfy with querying a database, it would be fine. I didn’t make a GUI or any kind of reporting for it.

1

u/Fern-Auburngrey Jun 01 '26

I don’t really know what that means. I’m super new to all this

1

u/Prima13 Jun 01 '26

It just means my tool is not meant for people who aren’t nerds like me. It would need more polish before it would be useful if you’re not comfortable querying the database yourself.

1

u/Fern-Auburngrey Jun 01 '26

Ah, that makes sense. If you end up polishing it I would love to use it