For a decade or so, Dokuwiki has been my "go to" application for a personal wiki. Simple syntax, quick and easy to get up and running, and doesn't even need SQLite -- your pages are just plain text files in a directory and, yes, you can edit them in the browser or $EDITOR.