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.

  • k4j8@lemmy.world
    link
    fedilink
    arrow-up
    1
    ·
    5 months ago

    No command line interface, but if you’re focus is a single solution with a consistent interface for lists, to-dos, etc., AppFlowy might be what you are looking for.

    I’m a huge fan of NocoDB, including their kanban views, group by options, and forms. You could use the GUI to create the tables and relations and then use the REST API to quickly update from the command line. It can use any database for its storage, so you could still create scripts or read the data for specific needs.