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.

  • matcha_addict@lemy.lolOPEnglish
    12·
    4 months ago

    I don’t think it would suffice. It would work for notes, but I want to also have a todo list in there, for example. Be able to check things off, query by due date, by assignee or task, etc.

    • subignition@fedia.io
      13·
      4 months ago

      I don’t think a database is a good fit for your use case at all, unless you’re willing to reinvent a lot of wheels.

      • matcha_addict@lemy.lolOPEnglish
        2·
        3 months ago

        What would then? I haven’t found anything that has command line interface and supports dependent tasks and a flexible, queryable tag system

        • subignition@fedia.io
          1·
          3 months ago

          I’m sorry, I don’t have a suggestion. If it were me I would not be looking at a CLI solution for this at all.

    • atzanteol@sh.itjust.worksEnglish
      51·
      4 months ago

      For todo stuff there’s the excellent “todo-txt” for cli use. Though not great for notes. Perhaps separate tools would be fine?

      • matcha_addict@lemy.lolOPEnglish
        1·
        3 months ago

        Todo txt lacked some features I needed, which would be trivial to implement as a SQL column.

        I do not remember what it was… Maybe it was dependent tasks? I believe so.