I do this for food, especially snacks, because sometimes I'll find something OUTSTANDING & then totally forget about it down the road lol. Or forget that I've tried something pretty mediocre until I have it again & then I'm like, oh...yeah
I do it for food too. I add tables as I see fit. If I get the idea I could use a new table for whatever, I can add it very easily. I have functionality that makes it super simple and convenient. The whole thing started out super super modest, with just one table. It was a table we used for tech support for a product at a software company I worked at. After I moved on from that company, I kept expanding the system and adding features. I still use that product from that job, it's a report writer and the owner of the company granted me a license when I left their employ. So, I can actually use the data we had to troubleshoot issues, should I have any with the report writer, which I use very frequently.
Presently there are almost 500 separate tables in my system and each belongs to one of approximately 20 groups of tables. For instance one of the groups is transportation. It includes a table for my car, one for my bicycle, one for my quad skates, etc.
My food table is named Recipe, but if I enter "food" or even "fd" in the search field it goes right to that table, because I assign nicknames to tables if and when I want to. My Recipe table has 408 records right now. I have a complex search algorithm. I can ask the function to return the records that have up to 3 must-be-included strings or up to 3 strings, any of which included puts them in the selected set of records for inspection.
I can and do write code specific to tables if I see fit to create it.
If I decide that a record belongs in another table I can easily copy or move it to that table, which comes in handy.
This thing is a super extension of my mind and life. Like I said, it's important that it not be a substitute for consciousness, but an enhancement. Like you, I'm good with a keyboard and love to write. I have info in my system that's really useful if I need it, stuff I wrote 20 years ago even, that I'd never remember without my system. Much of it I'll for sure never see again, there's just so much. A lot of it is fascinating, when I look at it. If I need to know something I've forgotten, I can find it IF I entered the info in the system, well there's a good chance. Of course, there are times I should have entered info and didn't, or not enough.