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.

  • cy_narrator@discuss.tchncs.de
    15·
    4 months ago

    Using a database for notes is like going 2km in a plane.

    You can use any relational database for this though but why would you subject yourself to this?

      • ᴇᴍᴘᴇʀᴏʀ 帝AEnglish
        1·
        4 months ago

        Obsidian has a huge number of plug-ins, that cover a wide range of uses. I also use Zettel Notes as a quick md file editor and that has the ability to capture pages in markdown to read later. And/or you can use Omnivore.

      • cy_narrator@discuss.tchncs.de
        1·
        2 months ago

        If you are generally interested in designing databases its a good exercise to try and build one yourself. That is the only situation I recommend you go this route