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.

  • Anna@lemmy.ml
    link
    fedilink
    arrow-up
    37
    ·
    4 months ago

    I wouldn’t recommend a DB for note taking purpose. You can use Markdown with vim.

    • fmstrat@lemmy.nowsci.com
      link
      fedilink
      English
      arrow-up
      2
      ·
      4 months ago

      Agreed. You can still do tags with filenames like ===Category===Tag 1---Tag 2===Note name.md or some such format.

    • matcha_addictOP
      link
      fedilink
      English
      arrow-up
      1
      ·
      4 months ago

      Perhaps I shouldn’t have said note taking. But the rest still applies.