Welcome to the rabbit hole of selfhosted note-taking apps. https://selfh.st/apps/?tag=Note-Taking
Unfortunately, this is going to be a bit of a journey. You’ll probably end up going through a few of these options until you find one that works for you and fits your workflow.
The article is from 2022. I’m guessing if it was written today, it would be about bluesky.