Database for managing my zettelkasten
Find a file
2025-01-21 17:44:26 +00:00
out chore: improve Controller 2025-01-17 11:03:30 +00:00
src fix: tag export functionality 2025-01-17 17:48:04 +00:00
tests initial commit 2024-08-26 15:38:09 +01:00
.gitignore chore: remove db from git 2025-01-21 17:44:26 +00:00
eolas-db-ERM.png chore: add ERM diagram 2024-11-03 14:31:15 +00:00
README.md chore: update readme 2025-01-21 17:43:59 +00:00
setup.py fix: tag export functionality 2025-01-17 17:48:04 +00:00

eolas-db

This CLI application parses entries in my zettelkasten and extracts key metadata about each entry. It creates and populates an SQLite database and offers different options for exporting representations of the relations.

Local development

source venv/bin/activate
python3 src/cli.py [opts]

Production

Generate single executable

source venv/bin/activate
pyinstaller --onefile ${HOME}/repos/eolas-db/src/cli.py --name eolas-db [opts]

Run executable

${HOME}/repos/eolas-db/dist/eolas-db

Or:

sudo mv ${HOME}/repos/eolas-db/dist/ /usr/local/bin
eolas-db  [opts]

Options

populate

Parse entries and extract key metadata and body text, import into database tables.

generate-graph

Output a network graph of connections between entries and tags

export-tags

Export a one-to-many JSON object of tags to entries.

ERM

ERM diagram for eolas-db

Resources

https://www.digitalocean.com/community/tutorials/how-to-use-the-sqlite3-module-in-python-3