@User oh boy, that's a rabbit hole. i started with evernote and one note. when i got over a hundred tags in evernote, I ende up moving my notes into vim.
i ended up creating a fork of soywiki (
http://danielchoi.com/software/soywiki.html) where I experimented with dendron concepts and its been my main note repository for the past five years.
while authoring in soywiki, i've experimented with different "frontends" for my notes. "frontends" i've experimented with: nv, nvAlt, tiddlywiki, media wiki, taskwarrior, bear, notion, roam, obsidian, etc
frustrations and inability to translate the hierarchal system i had in soywiki into any of these other systems led me to build dendron :)
when you say database GUI, can you elaborate on what you mean?