Completely agree. Most ORMs focus on hiding SQL away (for good reasons, such as portability and type safety), but I wish there were more approaching it in the reverse. That is, have the user write schemas, queries and migrations in SQL, and generate models with typesafe APIs in return. I’m only aware of SQLDelight in this space, but it’s such a great idea to have the source of truth be actual SQL, and a build time generator and validator working alongside you.

Todoist would work great for this. Projects can be shown as a list or a board (configurable), and you can have sections like “todo”, “doing”, and “done”. In a board format, these would be similar to a kanban board, except for the “done” automation — when you’re done, you need to tick the task card. You also get assignees, due dates, comments, attachments, native apps everywhere, and so on.

We’ll be able to tell with real comparative data now that both options are available, but I’d be shocked if SQLite itself is the bottleneck, especially in a low concurrency scenario (which is the case for most installations of star apps).