historian

{
  "aliases": [],
  "alternatives": [],
  "build_dependencies": [],
  "categories": [],
  "caveats": null,
  "conflicts_with": [],
  "dependencies": [],
  "deprecated": 0,
  "deprecation_reason": null,
  "desc": "Command-line utility for managing shell history in a SQLite database",
  "disable_reason": null,
  "disabled": 0,
  "enrichment_fetched_at": "2026-06-20T23:38:39+00:00",
  "first_seen": "2026-06-20T23:34:18+00:00",
  "full_name": "historian",
  "github_default_branch": "main",
  "github_last_commit_at": "2024-02-11T23:37:24Z",
  "github_readme_excerpt": "historian\n=========\n\nCommand-line utility for managing shell history in a SQLite database.\n\n`~/.bash_history` is deduped and imported into a database.\n\n### Requirements\n\n* SQLite\n* a home directory\n\n### Installation\n\nDownload and 1) add the directory to your `$PATH`\n\n    export PATH=\"$PATH:/Users/jerry/historian\"\n\nor 2) add `hist` as an alias.\n\n    alias hist=\"/Users/jerry/historian/hist\"\n\n### Getting Started\n\nImport your `~/.bash_history`\n\n    $ hist import\n\n### Super Installation\n\nAdd `hist import` to your `.profile` (assuming `hist` is in your path):\n\n    $ echo hist import \u003e\u003e ~/.profile\n\nThis will import your .bash_history every time you launch a new shell.\n\n### Usage\n\nShow config:\n\n    $ hist config\n    version:      0.0.2\n    bash_history: /Users/jerry/.bash_history\n    db:           /Users/jerry/.historian.db\n    sqlite3:      /opt/local/bin/sqlite3\n\nSearch:\n\n    $ hist search monsters\n    690\n        echo a zombie with no conscience \u003e\u003e ~/monsters\n    689\n        echo ghoul \u003e\u003e ~/monsters\n    688\n        echo goblin \u003e\u003e ~/monsters\n    687\n        echo lochness \u003e\u003e ~/monsters\n\nSearch (shorthand):\n\n    $ hist /monsters\n    690\n        echo a zombie with no conscience \u003e\u003e ~/monsters\n    689\n        echo ghoul \u003e\u003e ~/monsters\n    688\n        echo goblin \u003e\u003e ~/monsters\n    687\n        echo lochness \u003e\u003e ~/monsters\n\nView log:\n\n    $ hist log\n    1020\n        rm -f README.md\n    1019\n        emacs README.md\n    1018\n        rm -rf .git\n\n### Pitfalls\n\nLive like your db file could be corrupted at any time.\n\nBe wary of running specially crafted `hist` commands or against\n`~/.bash_history` files.\n\n### Cool Things in the Future\n\n* `export` to append to `~/.bash_history`\n* `scrub` items from history\n* set or autodetect configs\n* other shells than bash\n* timestamp support\n",
  "github_repo": "jcsalterego/historian",
  "github_stars": 551,
  "github_topics": [
    "history",
    "shell"
  ],
  "homepage": "https://github.com/jcsalterego/historian",
  "homepage_og_description": null,
  "homepage_og_image": null,
  "homepage_title": null,
  "installs_30d": 3,
  "installs_365d": 9,
  "installs_90d": 3,
  "keg_only": 0,
  "keg_only_reason": null,
  "last_seen": "2026-06-20T23:34:18+00:00",
  "license": "BSD-2-Clause",
  "llm_generated_at": null,
  "llm_model": null,
  "name": "historian",
  "oldnames": [],
  "one_liner": null,
  "optional_dependencies": [],
  "rank_30d": 11990,
  "rank_365d": 18019,
  "rank_90d": 16723,
  "raw_hash": "da6eb53c48d32016",
  "recommended_dependencies": [],
  "revision": 0,
  "ruby_source_path": "Formula/h/historian.rb",
  "tap": "homebrew/core",
  "test_dependencies": [],
  "uses_from_macos": [
    "sqlite"
  ],
  "version_head": null,
  "version_stable": "0.0.2",
  "versioned_formulae": [],
  "why_use_this": null
}