I'm looking for a client that helps me to make practical use of a DB. I'm looking at SQLite since it's simple, embedded (stored in a file rather than accessed via a server) and has a shell interface that I can use to script in data. The plan is to insert mp3's as BLOBs ("binary large objects"); and I understand there are two ways to do this: either put the mp3 itself in the DB, or merely include a reference to the mp3 file. Each record will also include transcripts/notes/tags
What kind of client can I use to access this DB as a user? I'd like to be able to 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?