I have kept a text file of wine notes for years. Each entry is like:
Wine #1 maker and wine name Date #1: Notes and cost Date #2: Notes and cost etc. Wine #2 maker and wine name Date #1: Notes and cost Date #2: Notes and cost etc.
I don't rely on any online knowledge on wines, and am not looking to do so. That's why I entitled this question using the word "personal wine notes". I also don't wish to rate each wine. My notes will tell me what I need to know. Depending on my mood when I review the notes, I may decide to give a wine another try.
What I need is to be able to sort the entries by: (i) date of last try or (ii) alphabetically. The former lets me see the most recent wines I tried without being hampered by wines that I tried years ago. The latter lets me look up a specific wine that I may come across, or that someone may have recommended.
Additionally, I would like to access the "database" of notes from both my desktop/laptop and my smartphone, and I don't want to go through any cloud service (other than webmail, e.g., gmail).
The apps that I've read about don't cater to these deceptively simple requirements. As someone who mashes data in my day job, I can envision a some partial conceptual solutions. For example, if I had a Microsoft Access database, then each wine can be a single entry in a data table of wines, which links to a table of notes. The notes table will have a date field and a field for text notes (including cost). I can then write some code to associate each wine with the date of its most recent note, then sort by either that most recent date or by the wine identification text.
This is fine if I only want to look up the database on the computer, but it does not permit updating on the smartphone. What works for accessing from phone and computer is to maintain a draft email in my gmail account, which I can access from both the phone and the computer. But it doesn't allow for the sorting described above. I've basically entered wines in chronologically. Sometimes, when someone recommends a wine, it's hard to check whether the wine is deep down in the text file (from years past).
I got tired of that, and took a text mashing editor (vim), made all the entries into one physical line of text, with delimiters separating the different date entries, sorted by wine name, then converted each entry back to the multiline format illustrated above. Without a database, however, I can't re-sort the wines by date of most recent trial.
Is there a solution that permits the sorting that I want (by wine or by date of most recent trial), accessible for update or lookup from both desktop/laptop and smartphone? Avoiding the cloud would be preferred.