1

I'm looking for an SQLite client that can help me to make practical use of the DB. The plan is to insert mp3's as BLOBs (or perhaps just as references to external files). Each record will also include transcripts/notes/tags.

I'd like to be able to access this DB in such a way that I can click on the mp3 and listen to it, then add text data in the other fields, and finally search on text in the DB. LibreOffice Base is a nice client that allows me to define forms, but I'm not clear if simple access to the mp3 is possible. Are there other options?

I should say up front that I can do bash scripting and C, but I don't have python.

10
  • If you don't get much traction here, you might move the Q to dba.sx or softwarerecs.sx
    – Jeff Schaller
    Apr 19, 2016 at 0:04
  • Thanks, Jeff. I looked at DBA, but those guys look like uber pros! I was kind of scared off ...
    – Diagon
    Apr 19, 2016 at 0:07
  • If you want to "click", perhaps you could consider a web browser and a simple PHP or perl app, or from bash, a number of scripts to list, search and manipulate your database and/or play your music. I'd go for the second. What do you think? Apr 20, 2016 at 3:54
  • @ZiggyCrueltyfreeZeitgeister - Thanks man. Since I don't have PHP or perl either, I'd have to go with the bash scripts. Thing is, I'm just very surprised that a more straightforward solution isn't available. I mean, this isn't the 1980's. We're well into the age of computers already!
    – Diagon
    Apr 20, 2016 at 19:39
  • 1
    @Ziggy - I see! This is a surprise. The metadata format, ID3, has a user-defined text information frame (TXXX). I could dump the transcript/notes/tags into there using a cli tag editor, and use other cli commands to retrieve/search/sort. Or maybe just XMMS2 would provide that. Ok! I had no idea that mp3's had room for this kind of stuff. Thank you for pointing it out. :)
    – Diagon
    Apr 24, 2016 at 4:52

1 Answer 1

1

Following up on the comments, one option to simplify this requirement without resorting to developing a user interface to link sound files and a database, and considering your skills in shell programming, is using command line tools to edit/retrieve tags on MP3 files (Here's a QA with plenty of resources and alternatives for reading and manipulating mp3 tags from the command line), and using XMMS2 or similar to build and maintain the library of files, and see or manually edit individual file's MP3 tags.

The benefit of this approach is that XMMS2 is not only very good at handling a library of sounds/music (including creating playlists and so forth) but also in editing MP3 tags, which can be manipulated from command line scripts through a variety of open source well documented and popular tools.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.