Yep, that’s the right way to describe it: “never-ending search”. I’ve been on this quest for a very long time.
This is where (in my view) Todoist shines. Actually Todoist is quite remarkable. The ability to create workflow templates for different kinds of projects is potentially very useful. Problem is, I haven’t quite mastered it.
Todoist’s UI has one or two quirks that annoy me. I probably ought to get used to them, because it does everything I want. I’m very fond of its ability to put dated tasks on my Google Calendar.
Moe mentioned Coda. I did a lot of work with Coda earlier in the year, as I was traveling the path that ultimately brought me to Tadabase.
When I began to realize Airtable wasn’t going to meet my needs, I found Coda, and I lived with it for a couple of months. I should have been able to realize more quickly than that that Coda wasn’t going to meet my database development needs even as well as Airtable does. After all, Airtable really is a database app, while Coda is a writing app with some interesting built-in database-like functionality. (Kind of like Word with an Excel table inserted in a document: It’s still not Excel.) I spent more time with Coda than I should have because the whole concept was novel to me – well, and because it’s a very slick piece of work. And Coda’s developers certainly have made rapid progress with it in 2020.
Still, I’m not a huge fan of these mind map apps. I guess I’m too linear. I did use it to build a to-do “doc” (their term for what you make with Coda) and it was okay, but in the end Coda is a writing app, and I want my to-do list to be a database: I want not just quick data entry, but quick searching, sorting, etc. Coda has some database features, including a capable (if awkward) way of creating ad-hoc relationships between tables. But ultimately, it’s not a useful tool if you’re planning to store more than a few dozen records.
I use Typora now for most of my writing, because (a) it’s breath-takingly beautiful and (b) it has the best support for Markdown anywhere (akin to Dropbox Paper but even better).
And as I said, for my serious database needs, I’m here.