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.
If you want something a bit more powerful than SQLite, MySQL and PostgreSQL both support CLI interactions and scripting too.
For note-taking and to-do lists both seem a bit overkill, and I’d recommend MariaDB instead of MySQL.
I agree they’re overkill. I’d use something like Joplin for note taking and to-do lists, which stores its data in SQLite anyway.