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?

  • matcha_addict@lemy.lolOP
    link
    fedilink
    English
    arrow-up
    0
    ·
    2 months ago

    First, I want to apologize for mentioning notes. Notes should be separate from the rest, and I agree with you on what you said about notes.

    For the rest, I’ve asked before on suggestions for apps to save my todos, links, etc. There were a couple issues

    • I couldn’t find something that gives me the same interface for all of these. They are all lists of things with some attributes and relations, but most apps out there handled each one of these separately and differently

    • they lacked features I wanted. For example, dependent tasks, a flexible tag system I can query by, etc.

    A DB would let me do all of that.