Hi all,

I am looking for a local database that is easily accessible via the command line.

It can be SQL or non-SQL

Whats my use case? I want to use it kinda like a second brain. A place to save my notes, my todo lists, my book reading lists, links / articles to read later, etc.

I want it to be a good CLI citizen so that I can script its commands to create simpler abstractions, rather than writing out the full queries every time.

Maybe sqlite is what I need, but is that ideal for my use case?

Edit: removed notes, as evidently they aren't suitable for this and aren't like the rest.

  • ZWQbpkzl [none/use name]
    ·
    5 months ago

    Yeah I only suggested obsidian because its so popular and is completely out-of-the-box.

    If you want everything exactly as you want it you'll need to spend time coding it all yourself. Otherwise you're shopping around for different tools for specific things. Some editor plugin for notes. Another for tasks. Another for reminders etc.

    My issue with task warrior was its syncing service taskd. It required that you generate a self signed ssl certificate. You couldn't host it behind caddy. But all the issues listed I'm pretty sure it covers. Its extremely robust.