Here is a recent discussion, where I shared how I preserve notes in greater detail (scroll up to the OP if that’s coming too much out of the blue).
Scrivener is a front-line tool for me, a place where writings and notes start, and eventually conclude (or fade away). Once they reach that point they get compiled or exported to Markdown, where the content joins the place where the nearly nine million words of the overall archive is stored. That exists as hundreds of thousands of simple plain text files, that all manner of software can open and work with, including my own—I have written extensive scripts for creating and managing my notes.
It is stated in another thread I think, than the one I linked to, but for a good while I did in fact use Scrivener as a “short-term memory” system of the overall archive. I had the most recent two or three years imported into it, and did all initial writing of notes there, great and small. It’s incredibly good at that, but I don’t use it that way any more because having data solely hosted inside of software is too crippling for how I work.
This system has gone in and out of several programs over the years, some for quite a long time too. One of the nice things about the system is that it was designed specifically to not need software, to even work in notebooks and index cards. It has no technical requirements. So, by extension, it gets along comfortably in most software.