Lyrics & Knowledge Personal Pages Record Shop Auction Links Radio & Media Kids Membership Help
The Mudcat Cafesj

User Name Thread Name Subject Posted
GUEST,Joerg Managing a repertoire held in memory (42) RE: Managing a repertoire held in memory 29 Aug 00

"... same problem - I don't have a problem remembering songs, but I do have a problem remembering which songs I can remember ..."

Yes, I know.

Just forget databases. The best database - unless you have to deal with millions of songs - is still a text file. Simple reason: In a text file you can search for anything you ever entered. But with a database you have to enter the data knowing what you want to be able to ever search for. And even worse: It works 'best' if you know everything you'll ever want to search for and even everything you'll ever want to enter BEFORE you set up the database itself. And it's hard to remember what you once thought you would want to know when you want to know something you can't remember.

'My way' (fnarr fnarr): Enter the title of each song that comes to your mind into a separate new line of a text file. If you want to add additional data, separate these e.g. with TAB or some other unusual character. From time to time load this text file into e.g. Excel with some option 'separated by e.g. TAB' and then sort the lines. Duplicate entries will then be joined in adjacent lines, and you can easily delete everything that's duplicate while copying everything you want to keep into the line that you keep. The save the result again to a text file with the option 'Separated by ... (whatever)".

Understood? It sounds complicated but it isn't. The advantage is that you only have to UNDERSTAND ONCE and you'll always KNOW HOW. No need to remember something or even know something in advance. The only thing to remember is to DO IT SOMETIMES. Difficult enough if your mind is normally filled with your job or your children or your love or ... or ...

Inclusive OR's
Of course!


Post to this Thread -

Back to the Main Forum Page

By clicking on the User Name, you will requery the forum for that user. You will see everything that he or she has posted with that Mudcat name.

By clicking on the Thread Name, you will be sent to the Forum on that thread as if you selected it from the main Mudcat Forum page.

By clicking on the Subject, you will also go to the thread as if you selected it from the original Forum page, but also go directly to that particular message.

By clicking on the Date (Posted), you will dig out every message posted that day.

Try it all, you will see.